Hide default member of Utility dimension in icCube

Asked Dec 01 '18 at 18:03

Active Dec 03 '18 at 09:06

Viewed 38 times

Is it possible to hide default member of Utility dimension, since I do not want to see it when I use the dimension in Excel pivot table.

I have tried to hide it in default perspective but then I am getting an error that default member is missing.

Edit:

I am using version 6.8.3. In the default perspective I have added following line:

-[Stats].[Stats].[L-Stats].[defaultMember]

After I successfully reloaded the cube, when I try to connect to it with Excel pivot table, I am getting an error: Missing default-member for hierarchy 'Stats(4)'

edited Dec 03 '18 at 09:06

asked Dec 01 '18 at 18:03

vldmrrdjcc

2,082
5
22
41

What is the error? Can you paste the message in your question? – Marc Polizzi Dec 02 '18 at 09:47
@MarcPolizzi I have edited the question – vldmrrdjcc Dec 03 '18 at 09:07

Hide default member of Utility dimension in icCube

0 Answers0