KPI cockpit : modelling question

[Former Member]

Hi,

We are making a KPI cockpit in the Visual Composer based on BW keyfigures. In our application we have 4 tables in which we show the keyfigures based on different queries. Thus in one table we show multiple keyfigures from multiple queries thanks to the "union" operator. In the first column we show the different keyfigures (from different queries), in the next colums we show the values and trends

This is how one of our table looks

Key figure Value Trend Exception

Net Value 100 € Down Red

Weight 20 Kg Up Green

Headcount 25 Same Yellow

The keyfigures above originate from different queries (co-pa, hr,...)

But, now we'd like to offer drilldown possibility from the tables to detail queries and/or webreports but our biggest problem is that the target report is fully dependend on the keyfigure row that is selected from the table. Is it possible to create a model in VC in which the target report choosen is dependend on a certain row that is selected in the table ?

thanks for your feedback

[Former Member]

Hi Double U,

I'm not sure whether I fully understood your problem. Getting a row index from a table is not possible (e.g. row 3 is selected). Still you can distinguish by using the table field "Key_figure" in guard conditions. I don't know how you plan to invoke your reports, but you might do the following. Drag four connectors from the out-port of your table. An event listener for the "select"-event should be generated automatically. For every connector you define a special guard condition. For example:

"IF(@key_figure=="Net Value",true,false)"

would be the guard condition on the connector to your Detail Report on Net Value.

In case this is not what you plan to do, please provide us with more details.

Best regards,

Benni

[Former Member]

Thank you Benjamin, your answer looks promising. I'll give this a try today and provide feedback here.

kr