Hello
My time dimension has MONTH and YEAR levels.
There are some calculated members that my customer wants to see in the YEAR level.
But when I load the cube in Excel these calculated members are shown for months too.
Is there a way of hiding theses calculated members for MONTH level, and show only for YEAR level?
Can I write a MDX expression that make the MONTH level be ignored and be shown in Excel?
Thank you.
Benedito R. Almeida Filho - BI
