Dynamic Visibility of Data Blocks (Hide When No Data is Present)?

wdeer
wdeer Customer
10 Comments 5 Likes Name Dropper 5 Up Votes
in Platform

I have a data view object that is storing 5 different report types in 5 different cubes. The rows are dimensioned by fiscal year and month and there is no dimension on column, meaning that the 5 columns are the 5 data blocks in the layout.

I would like to hide data blocks (Legal Income Statement & Legal Balance Sheet in the example) when data is not present based on the selection. We do have data loaded in this block for other intersections, just not for the current selection (blacked out in the top bar).

Is there a concept of dynamic visibility or local variables in Board where we could use "If then" logic to hide when no data is present? Are there any other workarounds I'm not thinking of? Your help is much appreciated!

image.png
Tagged:

Answers

  • wdeer
    wdeer Customer
    10 Comments 5 Likes Name Dropper 5 Up Votes

    I may create a separate question for this but, since it's a related topic, I'll include it here to see if anyone knows the answer.

    I used a data reader to load pdf files to a blob cube. The files and file paths used to load into the cube had detailed naming convention; However, since loading into the cubes, the report names now default to "@Month.pdf " which will cause confusion to users. Is there a way to keep the same file name that was loaded?

Categories