Union & BI queries

[Former Member]

Hi,

We have constructed a KPI dashboard which is based on +- 50 queries delivering KPI's from many areas. (SD, PS, FI, CO,...)

We used the VC Union function to group the KPI's and display them together in a couple of VC tables.

However, it can happen that a certain infocube is empty due to a reload at a certain moment which gives the "No Applicable Data" in the query that is based on this cube. This is not a problem and logical ofcourse but as a result of this all other queries from other cubes which were joined via the "Union" function won't be displayed in the Visual Composer anymore since the Union function can't live with one query that has no applicable data.

This is ofcourse very frustrating. Is there anything we can do from VC side to bypass this behaviour ? I was thinking that we should maybe load a flatfile in each cube which gives always just the KPI name and 0 values for the keyfigures. But then this flatfile request may never be deleted from the cube. Are there any better alternatives because I don't like mine too,much. (breaking the connection for the affected query temporarily is a solution that I would like to avoid as well)

kr

[Former Member]

1) If all your datasources come from BI, use a Multiprovider in BI, a multiprovider is also nothing else than a UNION-statement

2) Read this WIKI entry:

https://wiki.sdn.sap.com/wiki/display/VC/Norecordsreturnedshalldisplayalternatemessage

[Former Member]

Mario,

A multicube is no option, the cubes are very different (different infoobjects,...) which makes this a no-go for a multicube.

I think the flatfile solution will be the easiest after all.

[Former Member]

Hi RSC,

Did you fix your problem and how?

Or does somebody else knows a way to fix this problem.

I struggle the same problem.

Regards,

Joris Meeuwsen

[Former Member]

Hi,

I just stumbled upon the same problem.

Does anybody have a solution?

Is there another / similar thread about this issue?

Kind regards,

Daniel

[Former Member]

Hi Double U,

I think your suggested solution would be the fastest. An Alternative could be to write an ABAP RFC FM which works as a Union Operator then you needn't the dummy request.

Best Regards,

Marcel