Adding Attributes to 0UCCONTRACT

[Former Member]

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 !!!!

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Further, talking about option 1,

Yes I can access attributes of Connection Objects this way in the query, but i would not be able to create variable on those, because Connection Object is not part of the Info Provider.

So is the second option the only answer, can any one advice other options as well.

Regards

[Former Member · Accepted solution]

Naveen,

if you add those objects as attributes to 0UCCONTRACT you also have to activate them as navigational attributes. Additionally you need to activate them as nav.-attr. in the provider definition as well. After reopening of the query you will be able to create variables form them.

regards

Siggi

[Former Member · Accepted solution]

Hi Siggi,

Thanks for your response.

Yes as you said i can create Variable on Connection Object this way but my requirement is to create variable on attributes of connection object.

And thats the requirement.

Kindly update me !!

[Former Member · Accepted solution]

can any one suggest the best way could be !!

Thanks

[Former Member · Accepted solution]

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