Question:
Hi all ,
I am working on a project where I need to extract specific KPI's from multiple infocubes to the one master infocube. This master infocube is to be used to report on these KPI's like a balanced scorecard.
One source infocube can contain the KPI "Total Costs" another could contain the KPI "HR - Turnover", or "Headcount". Is it possible to use the existing queries in each infocube as a way to populate the master reporting infocube.
Answer:
1. Why not use a multi-cube?
or
2. Create a cube design with the KPI's and information you need which feeds off the existing Datasources from the other Cubes?
- Stephen
Answer:
Technically you should be able this, by using transaction RSCRM_BAPI and some staging approach, like transactional ODS or DB connect. However, I am not sure you really want to do that.
Answer:
I am working on the second phase of a project and I can't change the cube design. I am not allowed to change it
The cube is designed with the following
Company Code eg. 1000
Site eg. 1001
Performance Measure eg. 1 where KPI 1 is the "Total Costs" KPI
Time Variant eg. 10 for month, 20 for full year
Calendar day eg. 20030331 for fiscal year 2003 period 9
Value type eg. 10 for actual, 20 for budget etc, 30 for forecast
Measure Value eg. key figure for reporting
I need to continue using this cube design as we are using a front end tool (Arcplan inSight) on-top of the BW query. In the past the data into this cube was loaded using a csv file. The csv file is generated using vb code. The vb code parses a monthly excel report and creates the csv file. The excel report looks like this
Date: 20030331
FY March 2003
KPI Name actual budget forecast
Total Cost 10 20 25
Absenteeism 5
Turnover 2 2 4
So as you can see populating the cube is relativley easy.
With this new phase of the project I have new KPI's. These KPI's don't exist in excel reports but in other BW cubes. So I need to determine a way to extract the data from the required cubes and load it into my cube. These is perhaps 5 to 10 cubes that we need to get data from.
We are using BW 3.0B. Thanks.
Answer:
Hi,
When you are using BW3.0 and you can not change the cube design then I would suggest use the infoset feature in the infoprovider which will help you resolve your issue.
Hope this helps you.
Samuel