Info Cube Design - Diff Info Package

[Former Member]

Hi,

I have designed an infocube, for example, in which there is only one dimension with one characteristics and 3 KFs.

Char1 KF1 KF2 KF3

Now for char1, KF1 and KF2 data are uploaded from SAP modules using an infopackage, example

material 879.00 562.00

whereas KF3 for char1 are uploaded from excel file using a different info package, example

material 584.00

Now how do i make sure that there is only one record for a unique combination of char1. that means

material 879.00 562.00 584.00

let me know any specific setting, which needs to be done..

thanks

Rajiv

[Ashwin]

Hi!

One question What is the purpose of using a cube in this case.

1) if Data in excel shet contains this single dimention carecter and K3. then you can directly map it to Cube in update rules. BW will join them correctly because in any cube all the charecters will be formed as a componded primary key. In your case there is only one char and hence it will act a a primary key and hence when you are loading the 3rd keyfigure it is placed in the correct record which is identified with the key where other 2 keyfigures are stored.

2) I think Its not a good idea to use a cube here. Even if you are using a cube I think it is better to declare that single charecter as a line item dimention because it is always different. i think you know clearly that when you have a single key then the dimention table wil be equal to that of fact table in which case we declare these chars as lineitem dimention. By making the dimens as line item , it will be stored in fact table . I your case having the dimention in fact table means there will be just a fact table an no other tables. So There will be technically no difference when you use a ODS and report on it or a Cube. and if you use a ODS it is more better for performance in your case.

Hope it helps (dont forget to assign points if it helps)

with regards

ashwin

[Former Member]

Yes,

Thanks a lot for ur info..

I had just given an example of one Dimension, one char. In real scenario, I have 6 different dimension with multiple char and multiple KF, in which few KF are coming from SAP and others from NON-SAP.

can you provide some info on this.

Rajiv

[Ashwin]

Hi!

if all the Characters are same for all the key figures then they will be loaded into correct records.

while creating update rules you can see that some key figures will be grayed out and not loaded. if you click on any update rule you can see a Tab for characteristics. that means these key figure is identified with a combination of all these characteristics. An hence

if you have 2 different data sources which load 2 separate key figures but have all the charecters which identify it, then these records are loaded correctly into the Cube.

with regards

ashwin

[Ashwin]

Hi!

Is it clear to you or...

with regards

ashwin