Hi all,
I am working with BI 3.5 and I am building a query having a row structure. The query has a workbook with a graph created in Excel.
I am wondering if there is any way to see an empty structure if I make a selection for which there is no data. I now get No applicable Data Found and the structure disappears.
The graph I have created in Excel is plotting the data in the structure. If I execute the query and make a selection for which there is no data, I get reference errors in the graph which remains even if I refresh the query and make a selection for which there is data.
One way to solve this is by writing VBA code that is executed after the workbook is refreshed, but is there a better way? Is there a way to get an empty structure instead of the No applicable data found?
Thanks in advance.
C.L.