on 02-26-2007 8:22 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.