Skip to Content
author's profile photo Former Member
Former Member

Info Cube Design - Diff Info Package

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Aug 27, 2005 at 09:37 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.