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

Chaging to Navigational attribute and it effects

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2009 at 04:23 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 27, 2009 at 04:27 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2009 at 04:31 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2009 at 04:31 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 07, 2009 at 12:05 PM

    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

    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.