on 12-13-2011 10:11 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.