creation of cube

[Former Member]

hi experts

can u any body tell me when creating a cube u have only one transaction data source and in that u have char and keyfig .

here my doubt is how to take in the cube i will take all the kf in the kf tab wat abt that char if that is not in the master data its a direct char from r3 whether i have to create diamension for each char in the cube .

hope my doubt is clear to every one .

regards

Anand

[Former Member]

No, It does not matter whether those 20 char are master data or not. The thing is that to match 20 char from R3 datasource, you need 20 char in BW. So, first thing is that you shuld create 20 infoobjects in BW side(may be kf, may be char). Now you group these infoobjects in dimension. In 0ne dimension in BW, you can include 248 Char. All the kf will go to the KF tab.

Now, create a transformation using you R3 datasource and map these 20 infoobject with those 20 R3 fields.

Thanks...

Shambhu

[Former Member]

thanks shanbu

thanks for u r repply

regards

Anand

[Former Member]

If you can explain clearly what you are trying to ask then may be guys can help you but its not at all clear wat are you trying to ask here

[Former Member]

I will explain little bit elobarately

for example in u r data source (transaction data source) u have char and kf .

those char are not master data its s direct field in the R3 .my doubt is when creating a cube those char where i have to take in the cube whether i should create a diamesion for that char in the cube . if that is the case if i have 20 char like that i have to create 20 diamensions.

hope now it is clear.

regards

Anand

[Former Member]

Let me check if i got it clear.

Your question was to check how will you handle if we have more than 13 characteristics in a cube.

In such a case, we can use one dimension for multiple characteristics. Only point to be considered is, while placing multiple characateristics in a single dimension, ensure to place dependant char's under a dimension.

Hope thats clear.

Naveen.A

[Former Member]

thanks for the reply naveen

some wat clear naveen those char are direct char from e3 field and not master data . still we can place in the diamension each char .

Rgards

Anand

[Former Member]

Yes Anand. But before that create characteristics in BW, with same data element properties and then we should be able to place them in dimensions.

Naveen.A

[Former Member]

thanks naveen

thanks for the reply

regards

Anand

[Former Member]

anand 13 dimensions are the max you can deifine in your cube

and it is not a thumb tule to map one char or kf from source to cube in one dimension

you decide which are the logically related char and then create one dimension in Cube and put them under one dimension

you need not create a dimension for key figures from your souce as you can directly put them under key figures tab.

As said earlier you can have 248 char in one dimension but that doesnt mean you should put all of them under one dimension ,

make a logical grouping and then put ur char accordinly in ur dimensions if you do the wrong grouping of char under ur dimensions you dimension table may explode due to too many wrong combinations or combinations which are not required.

[Former Member]

Its not exactly clear.

Can you be a bit more eloborate, as to what are you trying to acheive, with that cube?