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

Info object

Posted on Feb 09, 2005 at 07:01 AM 13 Views

Hi BW Experts,

Can anyone help me on this.

We have created a customised cube ZABC_C01.

This is a sales related Billing cube.

in this we are using dimensions as customer, material, bill date, organization.

in 0customer info object we have lot of disp. and navigational attributes (account group, city, address ....etc)

same as for other info objects also we have lot of disp. and navigational attributes(material, billdate....etc)

Now i want to know whether for each of the attribute we have 3 master data tables? (master, text and hierarchy)

how exactly we have to model the infoobject can any one help me on this?

thanks

xys redd.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 09, 2005 at 07:30 AM
    0

    Hi XYS redd,

    I design infobject and cube attributes based on the slowly changing nature of attributes.

    -Know from the requirements about attributes which should reflect the state as on day of reporting. These should go to attributes of Infoobject.

    -If the attributes are slowly changing then make it a point to keep it in cube or time dependent attribute of master data

    -Sometimes due to performance in reading master data tables you can make a decision to keep some attributes in the cube itself(If the cube is small, I generally do this).

    I think you should also analyse what transaction report the cube caters to and do some ERD to understand.

    Best Regards,

    Anil

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Feb 09, 2005 at 09:07 AM

      However, remember always that if you activate navigational attributes you have to be sure that are related to info really needed from your report requirements point of view in order to avoid to do a too complex star schema (with related performance issue !)

      Bye,

      Roberto

  • author's profile photo Ashwin Gadi
    Ashwin Gadi
    Posted on Feb 09, 2005 at 10:23 AM
    0

    Hi !

    the info objects which are solly used as display attributes in other objects as exclusive attributes and will have no master data,no text ,no hirarchies.

    And All the infoobjects which are used as navigational attributes will be having masterdata.

    This mean only infoobjects which are used as navigational attibutes will have 3 tables. and others will not have them all.

    With regards

    Ashwin

    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.