Hide Some Members in a Time Dimension

Question

My time dimension has WEEKS MONTH and YEAR levels.There are some calculated members that my customer wants to see in the YEAR level.
Is there a way of hiding theses calculated members for WEEKS or MONTH level, and show only for YEAR level? Can MDX expression make the WEEKS or MONTH level be ignored?

Answer 1

Hi,
You could try use SCOPE function in MDX,

try something like :

 SCOPE([DimDate].[Month].[Month].MEMBERS, [DimDate].[Week].[Week].MEMBERS,[Measures].[Measure]);   
            THIS = NULL;   
    END SCOPE;   

Regards,
Lukas

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.