This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 22%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEV%3C/text%3E%3C/svg%3E)
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:
When I drag the dimension "Cenário", Forecast true value appears:
Can anybody help me, please?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
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.
Thanks for the explanation!
How can I change the defaut member to another value?
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!