Skip to Content

Dimensions in Info Cube

Hi Gurus,

Why there is only 16 dimensions in an Info cube ? why not more ?

thanks

venkat

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on Aug 21, 2007 at 06:34 AM

    Hi,

    SAP thinks that 16 is enough, and so far after 7.5 years as BW consultant I have not seen this as a critical limitation. You should be fine with 16 (13 + 3 SAP defined)

    Kind regards

    /martin

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Basically dimensions are created so that it works as index and retrieve data faster, and the same char can reside in one dimension...but there is a limit because if you increase the no. of dimensions..then the no. of joints will be high and query performence will be hampered while reading data from cube.....so 16 dimensions are suggested by SAP for good query performence and sufficient Dimensions to assign char to it.

      Award points if helpfull.

      Thanks

      Tripple k