i have one Cube with historical "fixed" data and one month of data that still is in review and can be changed slightly. My customer wants to select the fixed data with one Time-Hierarchy and the fixed + new data with another. I can not get it to work, especially the Total sum. I tried scopes for the different hierarcies but with no success...
I managed to hide the new month element in one hierarchy and made different measures for historical and new data, but now i have to select different measures based on which hierarchy is selected.
i imagined it has to work like this:
scope([TIME].[History]);
Measures.Sales = Measures.Sales_History;
end scope;
scope([TIME].[History and new]);
Measures.Sales = Measures.Sales_History_and_new;
end scope;
With this code i get one Measure for both hierarchies but not the other...
Thanks for the help!