I have a dataview with 4 cubes and 1 of the cubes is a budget cube which has just some Basic entities.
If I show the new data on a high level everthing looks fine:
But if I drill down for example on the age (it is a entity that the budgeting Cube doesnt know) the result looks like this:
The grey marked rows are shown (but they have no data in the past even in the budget cube) and the total budget will be shown on every line.
I could work with a filter row when I sum up all values. But the result is the same. If I create a filter row just with the past values I have the problem that elements just having data in the budget now will be excluded.
Do you know a workaround?