Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2004-04-22 : 02:53:19
|
Hi,I have a Star schema based dimension called Customer which has these levels:ALL Customers Level1: Customer Type Level2: Customer Sub Type Level3: Customer Name When a user is browsing the cube, is it possible to hide the the 1st level (and all it's sub-levels)? For example, If the Customer Type = "Low Ranked" then I do not want it to be diaplyed to the user while (s)he is selecting from the dimension. HOWEVER I only want it to be hidden from being displayed but it's effect should always reflect e.g. Suppose:- Sales (measure count) for Customers with Type "High Ranked" = 100
- Sales (measure count) for Customers with Type "Medium Ranked" = 50
- Sales (measure count) for Customers with Type "Low Ranked" = 10
Now if the user selects 'ALL Customer Type' in the dimension he/she should get a total Sale (measure count) of 160 (i.e. 100+50+10).However when the user expands the Customers Dimension (i.e. ALL Customers), the resulting child nodes should only list 2 nodes i.e. High Ranked and Medium Ranked.I went to the cube editor --> Advanced Properties and looked at the 'Hide Member If' property but amongst the 5 options there is none which allows me to specify the criteria. Maybe the solution already is in one of those 5 options and thus please help me.TIA.Thanks & Regards.-J |
|
|
|
|
|
How can I hide specific level(s) of a dimension?