Chaging to Navigational attribute and it effects

[Former Member]

Hi Experts,

User is requesting to change the display attribute to navigational attribute. This change would affect around 10 info provider in my case. My question u2013 is it alright to transport these changes even though the cubes having the data in the target system. Does the change will automatically adjust to the current structure in the target system? Please note we donu2019t have any staging layer to reload the data. What is the best option to do this or any suggestion on the things that need to be carefully dealt with? I donu2019t have a sand pit to test this scenario, you inputs will be helpful.

Regards

Subbu

[Former Member]

Can I throw something into the mix here... I'm facing a similar scenario with object 0WBS_ELEMT, but with a notable difference.

Once additional navigational attributes have been added to 0WBS_ELEMT it becomes impossible to activate the infoobject due to an unfeasibly long runtime of the process that inserts SIDS into the navigational attribute table (/BI0/XWBS_ELEMT). This ran for 3 days in our QA environment before giving up.

I therefore have two options that I can see prior to import of the infoobject changes;

i. Delete all data out of all cubes / DSO's / infoObjects that are connected to 0WBS_ELEMT

ii. Reconstruct and delete the SID tables for 0WBS_ELEMT via SE14

*Note: No transactional data is to be deleted prior to transport.

Option i. is tantamount to a full system re-load and is not feasible, so I am left with option ii. which brings around a different issue in that the SIDs no longer function correctly and reporting by the new navigational attributes is not avialable without a data refresh.

I have re-loade and activated the master data, carried out the attribute change run in full and checked the integrity of WBS via RSRV with no impact.

Is there a programme that can be run to repair or re-generate the SIDs????

Thanks for any help on this.

James

[Former Member]

Hi

Yes, it is ok to transport the objects to the target(even though the cube has data).

Just that the Source, Transformation, DTO of the InfoObject in whcih the attribute is changed to navigational attribute should also be transported to the target system.

In the target system once the changed objects are avaialable please activate all the Infoproviders again.

Regards, Hyma

[Former Member]

Hi

Yes, it is ok to transport the objects to the target(even though the cube has data).

Just that the Source, Transformation, DTO of the InfoObject in whcih the attribute is changed to navigational attribute should also be transported to the target system.

In the target system once the changed objects are avaialable please activate all the Infoproviders again.

Regards, Hyma

[mansi_dandavate]

Hi,

It wont affect any existing Cubes where you are using this InfoObject...

Just be careful that when you switch the attribute on, the transformation and DTP for that infoObject will become inactive...

So you will need to transport them too..

Rest all is fine..

[Former Member]

Its not a problem. Just turn the attribute to Nav and switch them On in any infoprovider you need.