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

Remove a navigational attribute

Posted on Aug 01, 2006 at 05:48 PM 61 Views

I want to delete one navigational attribute from master data. I have data loaded for this master data in BWQ , if I do this change , do I need to delete the data and reload.

Thanks

BW Content and Extractors
Add comment
10|10000 characters needed characters exceeded

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 05:55 PM

    i think you have to delete the data before changes

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 07:06 PM

    I have some cubes loaded already , what will happen if I drop the master data .

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Aug 01, 2006 at 07:12 PM

      Hi Radhika,

      you need to drop the loads from all the infoproviders where this master data object is used before you drop the data for this master data.

      Thanks and Regards

      Subray Hegde

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 06:47 PM

    Hi Radhika,

    You are right. You need to drop the data before you remove the attribute and then reload it.

    Thanks and Regards

    Subray Hegde.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 07:25 PM

    Is there any way I can hide this attribute so that the users do not see it when they create a query based on this master data or pull this as an attirbute in any other infoprovider.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Aug 01, 2006 at 07:28 PM

      Hi Radhika,

      If that attribute is a custom attribute, you can make it "Attribute Only" so that no one can use it in queries. This way, your attribute is not available for reporting. Hope this helps.

      Thanks and Regards

      Subray Hegde

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 07:34 PM

    For this change I do not have to delete the master data right ?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 07:42 PM

    What if in the info object setting for this attribute under BEx I make it as " NO DISPLAY" , Will it still show under the master data as an attribute.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Aug 01, 2006 at 07:58 PM

      Hi Radhika,

      No matter whether you set it as 'Attribute Only' or make it 'No Display', it will be an attribute of the master data. Only thing is You will not be able to display it in the reports. When you make it as 'Attribute Only', it will not be available in Bex as an attribute of this master data. In both these cases, you can not display the data. Hope this helps.

      Thanks and Regards

      Subray Hegde

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 02:44 PM

    Hi,

    If this attribute is not used in any reports then I think you can go to your cube and edit, go to Nav.attributes tab, this attribute should be listed there and deselect the I/O switch. It will give errors if it is used in any queries. Post your response if it works.

    Add comment
    10|10000 characters needed characters exceeded