Skip to Content
author's profile photo Former Member
Former Member

size of cube and ods?

Hi to all

What is the max size of the cube and ODS?

I heared cube size is 100 gb ? Is this right?

Please let me know?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 01, 2006 at 11:46 AM

    hi

    cube/ods size cann't be defined by Data Base...

    it depends on the dimensions(Max 16 including 3 system defined,and each demension can accommodate max of 248 characteristics).....and the size of the fact table...

    Thanks

    Teja

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 01, 2006 at 11:48 AM

    hi

    i think more important is disk space, reporting perfomance and daatbase management system than 100 GB.

    Hope it helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 01, 2006 at 11:59 AM

    Hi Dear,

    what you said is not true.

    There is nothing like a maximum size of a cube. After all, the cube data is getting stored in the underlying. database. So, the size of a cube depends on the size of the database. This is why we have the Tcode "DB02" where we can adjust the database parameters so that the performance can be enhanced.

    Thanks,

    Raj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 01, 2006 at 02:58 PM

    Can you clarify your question - are you looking for a theoretical maximum size or do you want to know how big a particular ODS and Cube are.

    The maximum size of a table is going to depend on the DB, but generally, the maximum table size a DB can support will be far larger than anything you are likely to ever need in BW - at least in terabytes in current versions of major DBs. Performance with large tables is likely to become a problem long before running into maximum size.

    If you want to know how large a table is, DB02 can provide that. ST14 can be used to run a job and collect size information on ODS, Cubes, Dimensions, master Data, PSA, etc.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.