hi i need some help,, i have a dimension like this:
dimgeo
fiDWHgeoid as my primary key
and these attributes
ficanalid
fidivisionid
figciaid
with thier description fields:
fcdesccanal
fcdescdivision
fcdescgcia
the problem: how can i make a unique key that includes the three id`s i listed in only one and unique key so when i browse my cube it will display the correct match.. i'm really really new in this, i saw a property which is key columns should i use it and it so.. how? please i need some help.
You can try and modify the KeyColumns property for your "fiDWHgeoid " attribute to include more than a single column into this.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
I did what you said but at the moment f processing it it comes this error:
Error 1 Cube 'Aforecubo' > Measure Group 'Fact Comite' > Dimension 'Dim Geo Afore' > Measure Group Attribute 'Fc Desc Division Afore' : Same count of key columns as in dimension attribute is required. This measure group attribute has 1 key columns, the dimension attribute has 2.
|||This error means that you have 2 columns your dimension key based upon. But when looking at relationships to the measure group, you still have a single attribute mentioned there.
Now, you've modified the dimension key, you need to make sure you can connect your dimension to the measure group.
I will have to take back my suggestion to modify key columns. You probably need to go back to relational database and solve the problem of unique keys there.
You can make intermediate attribute keys unique by adding more columns into the Key columns collection, but for the key attribute of the dimension you need pay attention to the way data in measure group is referenced correctly.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
1.-when you create the dimension select the 3 keys columns for example A,B,C
2.-Save your dimension
3.-Edit your dimension
4.-From de data source view drag the same 3 columns that you have selected before to the hierarchy pane to create a hierarchy
5.- See in Attributes pane that now you have a 3 key atributte key and this 3 atributtes individually
This is all
No comments:
Post a Comment