SSAS - Hide Some Calculated Members for a Time Dimension Level RRS feed

  • Pergunta

  • 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

    quarta-feira, 25 de setembro de 2019 11:01

Todas as Respostas