How many Line_Items in an InfoCube??

[Former Member]

Hello BW Experts!!

How many Line-Item Dimensions can be built for an InfoCube??

It should be value between 1-13 (excluding U,T,P Dimensions).

Plz let me know the number and why??

Thanks in Advance.

Regards,

Sapster.

(Its my responsibility to assign points)

[Former Member]

As others have mentioned, the lucky number is 13.

In fact, if you create an aggregate with 13 chars (+1 for time), the BW will create what is known as a flat aggregate - automatically putting each char into it's own line item dimension. This can really help query performance.

[Former Member]

Hello all.. thnaks for ur inputs,

Pizzaman!! could u plzz elaborate ur point for me plzzz?? I did not get what is "(+1 for time)" and whats exactly a "flat aggregate" means!! and how does this really help us in our query performance!!

Thankful to u!!

Assigned points to all of u!!

regards,

Sapster.

[Former Member]

Not knowing the answer I would say 13.

Why - because that is the limit and there is no reason why line-item dimensions can't use all of it (none that I can think of).

[Former Member]

The maximum no of dimensions ofr a cube is 13 and this answers your question.

One thing you must note is when you mark a char as a line item dimension, you cant add any other char to the same dimension.

Ravi Thothadri