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