Skip to Content
avatar image
Former Member

How many Line_Items in an InfoCube??

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)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 16, 2007 at 04:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 04:13 PM

    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).

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 05:04 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.