lo, co-pa extrations

[Former Member]

hi all,

while doing lo or co-pa extrations, while assigning dimentions to info cube, if i have more than 40 infor cubes to be assigned to 13 dimentions. so i can assign multile characterstics to each cube. i have two doubts regarding this.

1) if dimension size is over 10% of the cube i should create a line item dimention on performance maintanance basis, but i cannot create a line item dim cause the dim has more than 1 characterstic.

so how do i know what characterstis are the ones that take up space and needs to be maintained as a line item diemntion, when there are more than 40 to 60 characterstics. any help will be appreciate.

thank you,

george

[Former Member · Accepted solution]

Hi george,

1) Since you are loading the data you would have to have an idea on how many unique

values of a CHAR in a dimension has multiple rows in the fact table.

2) based on each CHAR you would decide whether it is a line item DIM or not.

Look at the link for details:

http://help.sap.com/saphelp_nw04/helpdata/en/a7/d50f395fc8cb7fe10000000a11402f/frameset.htm

Good luck, BB

[Former Member · Accepted solution]

hi BB,

thnaks fo ryour healf can you clarify this for me, is there a tcode to see the unique

values of a CHAR in a dimension and how many rows it has in a fact table. is tht done in se11 se16 or is there a better way to find out

[Former Member]

Hi,

you go for line item dimension in the case when you have siomething like document number in your case it will CO_PA doc or sales doc which comes from copa or billing doc this all should be assigned to separate dimensions and made line dimension as there number will be huge and will have data unique to them that is each billing odc will have a unique values and will cause increase in space of dim table......so why nor kkep them separate so it willresult in less number of records. and infact you can make all the 13 dimension as line item.... no issues with that.

it has nothing to do with the length of the char it is do with the size of the dimension tables....

you can go to SAP_INFOCUBE_DESIGNS program and give your cube name and check which dimension is occupying how much space and depending upon that you can redesign by ressigning char to dimensions....basically all the dimension having wrong assignemnts will show up in red.

you can assign pnly one char to a line itme dimension.

there are many links on line item dimension and scenarion they should be used on forum.

Thanks

Ajeet