Hide Some Members in a Time Dimension

KamiFen 121 Reputation points
2020-09-08T05:39:31.053+00:00

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?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,282 questions
0 comments
Accepted answer
  1. Lukas Yu -MSFT 5,821 Reputation points
    2020-09-08T05:52:22.64+00:00

    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.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.