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

Redesign the Infocube

Posted on Oct 24, 2006 at 11:39 PM 13 Views

Greetings,

Can some body guide me if there is a best practice "How to redesign(review) the infoproviders".

Since some our queries were long running , we are inprocess of reviewing the data model to change accordingly.

Thanks in advance.

Thanks

Shan

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2006 at 02:32 AM
    3

    Before going the remodleing step, which may be necessary, have you tried all the other features that help performance? e.g.

    - compression

    - aggregates

    - additional indexes

    - partitioning - supported to differnt degrees by different DBs

    For Infocubes - main objective is probably to review the existing dimensions to see if splitting them up into more smaller dimensions, and review teh relationships among the characteristics to see if some that are currently in teh same dimension, really should be split into separate dims.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Martin Mouil Padeti
      Oct 25, 2006 at 03:27 PM

      @ Praveen,

      These cubes already modeled good, i have this document since when it was created.

      @ Pizzaman.

      Yeah , we followed most of guidelines from SAP.

      @ Martin

      Dimension/Fact tables looks fine.

      Since this is a redesign , just would like to have some light from experts to know the best practice like any client implemented document that has review check list.

      Am sure there is a big difference with design and redesign , just wanted to know how,where it differs.

      thank you

      Shan

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Oct 24, 2006 at 11:50 PM
    0

    Hello Shan,

    Please check if document is of any help.

    http://help.sap.com/bp_biv235/BI_EN/documentation/Multi-dimensional_modeling_EN.doc

    Regards,

    Praveen

    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.