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

How to re-arrange objects within dimension

I'm stumped on how to delete an infoobject from a dimension. All I really want to do is re-arrange a large dimension to effect the way index is created. Can someone tell me the steps to change the dimension. Its obvious how to add them.

Thanks

Richard

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Oct 11, 2005 at 04:23 PM

    Richard,

    You can try this: Remove the object from the cube (move from left to right) and then add it again (right to left). It will be without the dimension assignment.

    The functionality Roberto mentions will be available with BI in NetWeaver 2004s.

    Hope this helps...

    Message was edited by: Bhanu Gupta

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2005 at 05:02 PM

    Richard -

    The Dimension table index is created based on the order the characteristic appears in the cube. So if you have a characteristic that is fairly selective and is used to filter data in the queries, just make that characteristic the first one in the cube of the characteristics in that dimension, e.g.

    Chr1 - Dim 2

    Chr2 - Dim 1

    Chr3 - Dim 3

    Chr4 - Dim 1

    Chr5 - Dim 2

    Chr6 - Dim 2

    Assuming none of these are set as line item, the result of the indices on the Dim tables would be:

    - Dim 1 indexed on Chr2, Chr4

    - Dim 2 indexed on Chr1, Chr5, Chr6

    - Dim 3 indexed on Chr3

    If you have multiple chars in the same dim that are both fairly selective and both used independently in many queries, you might end up creating a secondary index, e.g. add a secondary index on Dim table 2 on Chr6

    An interesting observation I made the other day is that the opposite appears to happen for dim tables created for aggregates. It that case, the dim table indices get built based on the order the characteristic last appears in the cube - or from the bottom up. I need to pursue this with SAP to find out if that is by design or the developer just chose to do it that way, not understanding the DB index use implications.

    Now, it probably isn't worth even doing this unless the Dim table ends up being at least a few thousand rows.

    Oracle 9 was supposed to do a better job of keeping small tables frequently referenced with a short table scan in the buffer, but it still has problems. If you check your table accesses, you'll find many small master data tables that are frequently referenced still going to disk. Oracle 10 should resolve this problem and keep these tables in the DB buffer.

    Another thing you can look at is using your DB buffering to pin the smaller dim tables in the buffer, or put them in the Keep (Oracle) buffer. SAP Table buffering is NOT not used for BW fact and dimension tables since the queries do aggregation.

    hope this helps,

    Pizzaman 😊

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      The secondary indices that we are talking about adding are on the dimension tables.

      They are NOT affected by the drop/create index jobs on the manage tab, which drop/create indices on the fact tables.

      I have not had the need to empty and refill a cube (and opting to delete dimension tables) that has a secondary dimemsion table that I added. It is possible the secondary dim table index could be lost in that situation, but I just don't know.

  • Posted on Oct 11, 2005 at 04:11 PM

    Hi Richard,

    Does this cube have data? You cannot remove a char from the dimension if there is data...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2005 at 04:18 PM

    Hi Rich,

    till now this is not possible...but I remember that there is a new functionality that allows to adjust dimension WITH data inside...

    Just a second to check if I'm able to find something (release and so on..)...

    Bye,

    Roberto

    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.