Filter visibility of rows based on PDF cube

Valerio Lupo

It's possible filter by a PDF cube? I want filter a layout by a PDF cube and see only the row where the PDF is present. What is the condition?

Sebastian Gurt

Hi Valerio,

 

I don't think this is possible. I am not able to find a condition that works.

Are you able to show just the BLOB cube in the layout and disable "Show all" by rows? This should result in only displaying lines with pdfs.

 

BR

 

Sebastian

Unknown

Regarding conditions,I agree with Sebastian Gurt. As an alternative approach I tested this with a procedure that is a trigger on the DataView, so when the PDF is uploaded a flag of 1 is generated in a different cube at the same level for which the PDF is uploaded (Region in the screenshot below).  Now we can simply filter on the flag to only display the rows with the PDF documents attached:

The procedure looks like this:

With the trigger for the Procedure on the 'Upload' DataView. 

Ideally I would like to be able to filter directly on the existence of PDF, but the alternative above might work for some situations.