hi!!! i have a new question .. i have a dimension and i have set a hierarchy for it.. it worked when i processed the cube but when i browse the cube it displays the hierarchy correctly: the main hierarchy then by clicking the (+) it displays the second level hierarchies and so on but the data is not correctly ordered. so i changed the property 'key columns' of the other id`s i have in my dimension.. now the sequence of the data is correct. but the tree in my browser displays expanded i mean,, individually. each by each record.....it is not in groups of data like before.. i don`t know if anyone can understand me .. i'm a new user of this tool. please i need some help
this is what i have i my dimension:
fidwhid= my pk
then the other keys:
.ficanalid
.fidivisionid
.figciaid
.fiempid
then the descriptions
.fdesccanal
.fdescdiv
.fdesccia
.fdesemp
i did something like this in the key columns property
ficanalid = fidwhid,ficanalid
fidivisionid=fidwhid,ficanalid,fidivisionid
figciaid= fidwhid,ficanalid,fidivisionid,figciaid
fiempid=fidwhid,ficanalid,fidivisionid,figciaid,fiempid
so the data is correctly matched. but the hierarchies are not in groups..
Key columns define the uniqueness of attribute values. Because you've included your PK as one of the columns in the key columns for each attribute, each attribute will have a unique value for every unique value of the PK which is every row in the table. This means that every attribute has the same number of values. To solve this, you only want to include columns in the Key columns of an attribute that are necessary to uniquely identify different instances/values of this attribute. Then use the OrderBy property of each attribute to control how the attribute is ordered.
Hope this helps,
No comments:
Post a Comment