Dataview Drill down no value / show all

Flavio Gläser
Flavio Gläser Customer
Fourth Anniversary Advocate First Comment 5 Up Votes
edited April 2020 in Platform

Hello together

 

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: 

image

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:

image

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?

 

Many thanks

Flavio

Answers

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers

    Hi

     

    the question is, which element should be shown, if the filter is zero for all lines? As an idea, maybe a complex filter also using the DownTotal will help (if dt(x)>0, normalFilter, 0)

     

    regards

    Björn

Categories