Hi

I have a cube with the fact table as below

Fact Table

ID Value Type ForeignKey
1 X1 X 1
2 X2 X 2
3 Z3 Z 6

Dimension Table (Monster master table)

Record_ID Value Description Type
1 X1 desc X1 X
2 X2 desc X2 X
3 X3 desc X3 X
4 Z1 desc Z1 Z
5 Z2 desc Z2 Z
6 Z3 desc Z3 Z

Now I created a dimension called Type (Dimension table)
If someone doesnt select that dimension in Analysis server cube
browser, I want to show all the fact table records. But if someone
selects Type X then I want to show the following output

Description Number of values
desc X1 1
desc X2 1
desc X3 0

Please help

thanks

Milind

Is the cube browser the actual client tool in which you want to do this
- would be simpler with tools where the type could be input as a
parameter to dynamic MDX?


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Deepak

Thanks for the response. I use MDX in stored procedures in SQL server
to submit the queries to the AS2000. I can pass it as a parameter. But
because of the monster table which is a combination of lot of set up
master tables, I cannot display only those records while browsing in
AS2000 cube browser. I was thinking, maybe, give the users readonly
access to browse the cube. But really cannot filter the Type dimension
to the one selected by the user ( the output records I mean). Its
working through MDX since I created a member property for the dimension
and filter that member property in MDX.

thanks

Milind

Hi Milind,

Unfortunately with the cube browser, I'm not aware of any option to
filter out empty rows/columns. But with other user tools (like Excel
pivot table), you could define a virtual dimension like "Type
Description", which could be placed on rows or columns. When Type "X" is
then selected on pages (slicer), only the relevant descriptions would be
listed, since other virtual dimension members would be null.


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!