question

EduardoVerga-3982 avatar image
0 Votes"
EduardoVerga-3982 asked EduardoVerga-3982 answered

SSAS Cube do not sum measure without specific dimension

Hi everyone,


I believe this is a simple question, but I can't find out the reason why this is happening. We have a cube here where it just SUM a measure if I drag a specific dimension when I use it.

If I don't drag the dimension "Cenário", Forecast value is always 0:

115429-image.png


When I drag the dimension "Cenário", Forecast true value appears:

115440-image.png


Can anybody help me, please?

sql-server-analysis-services
image.png (84.5 KiB)
image.png (98.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlexeiStoyanovsky avatar image
0 Votes"
AlexeiStoyanovsky answered EduardoVerga-3982 commented

The only attribute in the dimension is set to not aggregatable, and its default member is DRE Oficial, the value of the Forecast measure for which is 0.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for the explanation!

How can I change the defaut member to another value?

0 Votes 0 ·
EduardoVerga-3982 avatar image
0 Votes"
EduardoVerga-3982 answered

I found where are this parameters (they are in the Attribute Property, inside the Dimension). I set "IsAggregable" = True and "DefaultMember" = Nothing and now works perfectly. Thank you very much!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.