Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Non Key granularity attribute in Parent-Child Hierarchy Expand / Collapse
Author
Message
Posted Wednesday, December 23, 2009 2:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 15, 2010 1:34 AM
Points: 1, Visits: 11
Hi, I have a parent-child dimension. The dimension table has 3 fields a) ParentID b) NodeKey and c) NodeID. The fact table has 2 fields a) NodeID and b) Data. In the dimension, the ParentID serves as a parent, and the NodeKey is the key attribute. In the data source view I am linking the fact table's NodeID to the dimension table's NodeID. In the cube, under "Dimension Usage" I have selected the dimension table's NodeID as "Granularity Attribute". I get a warning message that I will have to make sure that all other attributes must be related to this attribute. I can see in the "Dimension structure" that the NodeID is related to the NodeKey attribute already. After processing the cube, the data is not aggregated though I can see the dimension hierarchy properly. What am I missing?
Post #838417
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse