Conditional display of columns on a dataview

Adam Elvin

I have this dataview and I would like to find a nice way to hide/show the 3, 6, 9 month columns without having to go into the layout and select the hide block option.  I started off with a small data entry cube so that I can place a tick to decide which columns I want to show but I can't find a way to have that affect which columns can be seen on the data view.

 

Any good tips and tricks out there to help me achieve this?

Björn Reuber

Hi Adam,

 

I think you can easily solve this using a Dynamic Select.

A possible Solution could be following:

New Entity "Moving Avg Selection" containing following Elements "3 Month", "6 Month" and "9 Month"

A cube based on "Moving Avg Selection" and Month. In this cube you can configure which Month should belong to "3 Month", "6 Month" and "9 Month". Then you use this cube as a dynamic select (with option "periods <>0) and add a selector for the entity "Moving Avg Selection" on your screen. So with selecting one of those member automatically the entity month get selected cause of the dynamic select.

 

Regards

Björn

Fabian Frommann

Hi Adam,

 

you could also keep track of your idea.

Include your data entry cube into the layout of the data view three times.

• One time with refer to 3 month avg,
• one time with refer to 6 month avg
• and another time with refer to 9 month avg.

The data entry cube will be virtually ripped up and shows "0" or "1" (depending on your entry in the data entry layout) in every single row.

Now you have to multiply your data cubes with your filter cubes (data entry cubes) in a column algorithm. I.e. 3 month avg filter * 3 month avg data. Depending on your data entry on the filter cube, the column will be shown or not. Do this for any avg. Important is to disable "show all" in your axis configuartion on columns.

 

Regards

FabFro

Adam Elvin

Thanks Fabian

A good solution, although I will point out a problem I had, my first column was Current Month, then I had YTD and I wanted a Fiscal YTD average.  To achieve this I had pulled in the month entity and used an algorithm to derive the right month number, i.e. if July then 1 if August then 2 and so on. Having the month entity (hidden) did cause a problem with un ticking the show all button and the functionality you described did not work.  So I just created a new cube by month to hold the YTD Divisor for each month so that a cube can be used in the YTD average algorithm instead of a combination of cubes and algorithm which then allowed your solution to work.

Thanks!