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

Adding Attributes to 0UCCONTRACT

Hi Friends,

We are implementing FI-CA, Contract Account reporting in BW, we are on BW 3.5 and IS U 4.72.

We are extracting Open Items and Cleared Items into cubes and then created Multi Cube to report on.

In Cubes we have Contract(0UCCONTRACT) InfoObject- It has Premise and Installation Number as attributes.

Now User wants selection on Attributes of Connection Object - Like Political Structure.

The options i Have are:

1. To make Premise, Installation Number and Connection Object as attributes to 0UCCONTRACT (Contract), and then mark required attribuites of these objects as navigational attributes, so that we can create variable on it in query.

2. Another option is, to add Premise, Installation Number and Connection Object to the Cube It self, and try to populate them in Update rules accessing master data, based on Contract.

As we are dealing with 7 to 8 million records, i want to understand the best way of doing this.

Do you have any other options or which one is the best among above options.

Contract has -> Installation Number as Attributes

Installation Number has -> Premise as an Attribute

Premise has -> Connection Object as an Attribute

Rest assured, you will get points !!!!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 09:37 AM

    Hi Naveen,

    I would go with option 1, but somehow you need to track changes fo inst.no. and premise while updating the contract to have the attributes updated with the correct values.

    kind regards

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi

      I wil go for option 2

      Reason : You have huge records and it will not have any query performance problem as the required data is stored already in the cube

      Second, you can create you variable as required and fetch data as you want. Flexibility is there

      Assign points if useful

      Cheers

      N Ganesh

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.