I have a fact table i set as both dimension and fact. so this one is linked to different dimension tables and at the same time, some of its values are in measure group.
the thing is, in the list of its attributes, i can see the keys to which the different dimensions are linked. i cannot remove these key because they serve as links. but i dont want the users to see this key. it's not helpful to them anyway. how can i do it?
Example:
Fct_ServiceJobItem (Set as both dimension and fact)
JobNo
LineNum
Partkey
Amount
Dim_Parts (Dimension)
PartKey
PartNo
.
.
I dont want to see the Partkey in the Dimension Fct_ServiceJobItem. But this is linked to Dim_Parts and removing it can cause error.
cherriesh
In the designer , highlight the Fact, or attribute you want to hide and press F4.
set Visible for facts, or attributehierarchyvisible for dimensions to false
No comments:
Post a Comment