on 08-16-2005 10:02 AM
Hi:
There is a charicteristic in a query, but i can't find it in the char list in the multiinfocube from which the query retrieve data. so why did the charicteristic exist in the char list of the query?
It might be a Navigational Attribute. Check the Nav. attributes selected in the cube.
Regards,
Sree
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Guixin,
Nav. attributes are attributes of characteristics in the InfoCube that can be used for navigating in a way similar to the way normal characteristics in an InfoCube.
Attributes are cube independent.
Nav. attributes can be set as time dependent or independent. Time independent save the hassle of re-alignment runs. For e.g. is transaction data is by amterial and it has an attribute color. Color can be changed at a later point in time and all data in the cube can reflect the new color of that material.
Cheers
Aneesh
Hi Guixin,
A navigational attribute allows you to include data from this attribute independantly in the query and use it in all navigation functions. It behaves exactly like a characteristic in a query, but unlike a characteristic, the values for the navigational attribute are not stored in the InfoCube; the values are pulled from the master data tables. Lets say you have Customer info coming in as transactional data and have Customer included in your cube. Now you also want to filter by country of Customer, but Country is not provided in the transactional data. You can include Country from the Customer attributes (navigational) as a navigational attribute in your cube, and use it in your queries.
Hope this helps...
Hi,
"It behaves exactly like a characteristic in a query, but unlike a characteristic, the values for the navigational attribute are not stored in the InfoCube"
You mean that physically values of characteristic in a cube stored in cube table? what table? does it store in the same table with key fague ?
Well actually the values of the char are not even stored in the cube tables...it is just the corresponding SID for a char value that is stored in the cube table. These tables are the dimension tables. They key figures are stored in the other cube table known as Fact Table. To take a look at SID values vs. Actual values of a char you can look into the char's S table.
Hope this helps...
Guixin,
It might be a navigational attribute, in which case it won't be in the characteristics but in the navigational attributes screen.
Does the characteristic technical name have '__' in it? If so, then it is a a navigational attribute.
Aneesh
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.