Skip to Content
0
C L
Sep 17, 2007 at 05:20 PM

Keep structure when opening empty reports

19 Views

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.