Skip to Content
avatar image
Former Member

KPI cockpit : modelling question

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 26, 2007 at 08:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

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

      kr