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

Nav Attribute

Hi Guys ,

I have a question on Navigational attributes .

If there is a object ex 0MATERIAL which is used as a object in Info cube and the same object is used as Navigational Attribute .In reporting how will the 2 objects Differ .

I know that NAV attr and Normal char behaves the same in report .Is there any diff view the way it shown in the report .

Regards

Santosh

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Dec 13, 2011 at 10:25 AM

    the 0material in the cube will be the value that has been loaded into the cube (ie transactional data). the navigational attribute will give the current (or latest in any case) value of 0 material.

    so, for a given key in a cube you could have more than one line with different materials, but the navigational object will always have the same value.

    you can differentiate using the description of the field in the report, for the rest they are all the same as it's the same object.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 10:45 AM

    Hi Santosh,

    Basically when you use 0material as infoobject in infocube then the value of 0material reamins constant throught out the life time of that data unless you are reloading same transaction data with changed material value.

    But in case when you are using 0material as navigation attribute it is master data and it will always show you the current value. Though the value of your transaction data is same but value of 0material can be different because of it's navigation attribute behaviour.

    Regards,

    Durgesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 13, 2011 at 12:00 PM

    Hi,

    One is transaction data and another one is master data.

    Navigational attribute will give the master data level values which are statics at one level unless you have time dependent navigational attribute.

    second is transaction data which will give you correct entry at the time of posting.

    so both above values can also be different for certain records.

    They may not always same.

    Thanks and regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 13, 2011 at 07:56 PM

    Hi Santosh

    Please check the below explanation and let me know if it gives you a clear picture.

    **************************************************************************************************************************************************

    One scenario could be if your Navigation Attr is time dependent.

    In that case you keep your cube data as per the time of transaction. Let's say you have material and material type both in cube.

    Now , material M01 has type "Software" during the transaction ( in 2010). So you have your transaction data.

    Material Type Year Amount

    M01 Software 2010 1000 <----


    this is your result in BEx

    Now, in 2011 material type got changed to "Peripheral" . If your master data is time dependent then you can have history of this change in master data table but not in cube.

    So if you report on the cube by taking material type from Navgation attr ( time dep) then you will see in result.

    M01 Peripheral 2010 1000 <----


    this is your result in BEx

    Now from the above example if you use Material Type both from Navigational Attr and Cube , you can show both 'Historical" data and 'Current' Data.

    Regards

    Anindya

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 12:05 PM

    Hi,

    When we add 0MATERIAL at cube level, then this data is coming from transactio. However some of the attributes of 0MATERIAL such as material group etc. we would like to display in query, in that case navigational attributes come into picture. These navigational attr belongs to 0MATERIAL master data. By enabling them at cube level we can show at query level.

    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.