Can anyone explain me how to work with the filter tab on Cube drill through
options?
I added an extra table and specified the joining clause in this tab. It
works fine for the first time; but after saving the cube it gives invalid

Hi, I will rewrite my question.
I'm having trouble to show averages of a measure in a cube, where the normal
aggregation function for a measure is SUM.
I see no AVG aggregation function for measures (I see Min, Max, Count,

We need to make a choice between using MS AS or Cognos PowerPlay. PowerPlay  
has a much better interface and some advantages.
Can anyone comment on this? Also, does anyone know of good fron-end products
to create MS AS cubes rather than using the Microsoft UI?

Was looking at the FoodMart 2000 Database in AS and the HR cube as an
example and had these quesions
1) I was looking at MetaData on the right pane and see the following
dimensions :

1) How can I schedule a daily full backup of the AS Database ? I know in SQL
server, therese a SQL Agent that i can run a job .. But on my AS Server, all
I have is AS.. Also what the command to use ? Can one send me an example ?
2) I looked at the data folder and I see so many ...

Does it also listen on 1433 like SQL Server ?

1) Can an AS database be created from multiple data sources .. i.e. can we
create cubes with tables( dimensions) that may belong on different data
sources ?
2) What kind of storage mode do I currently have ? How do I check ? I know

I have to prepare a deployment plan for a data warehouse solution which
include this:
* 1 Data warehouse server (SQL Server 2000) for a 32 gb database / 4
processors

Any experience with WhereScapeRed (Data warehouse lifecycle management
software: design, build and manage data warehouses) with MS SQL Server
2000 + MS Analysis Services 2000 www.http://www.wherescape.com ?
Regards, Marco www.gmsbv.nl

I am evaluating the BI Accelerator samples Excel 2003 SP1, however I receive
this warning "The Analytics Builder Workbook requires Excel XP, SP1 or
greater" and then the Excel file closes.
Is there a work around for this please?

I am trying to manipulate data before it is inserted into a column.  For
instance
I am reading in a MAC addreess which looks like '00DE0B16AA99'  and when I
do an insert into the column I want it to be '00:DE:0B:16:AA:99'  In other

With my OLTP on another server, OLAP cube design works up to the point of
actually processing the cube, then it errors processing the dimension.
If I move the OLTP database (SQL Server 2000) onto the machine running the
OLAP it works fine.

Hi All;
I have a web application which is being used at large scale and there are
upto 10,000 entries per day. Currently, there is no Begin Tran/Commit
Tran/Rollback Tran and b/c of that we found some data corruption. Now, I

What is correlation name and how can I use it? I get this error when trying
to process the cube for the first time using DSO.
An unhandled exception of type 'System.Runtime.InteropServices.COMException'
occurred in AutomatedCubeCreation.exe

I have recently created cubes using the company I work
for data. I would like to switch form using Crystal
Reports to using AS and Reporting Services.
However I am not the greatest public speaker. Does anyone