ssas - Should ID be in User Hierarchy? -
i have seen go both ways in different implementaions. in hierarchy there let's 6 levels bottom level id (example productid), there product name unique. tend think id not need in hierarchy if product name "human" identifier.
safe take out of hierarchy?
update: clear - product dimension has prodid , prodname on each record. join fact table on prodid. hierarchy had both prodid , prodname prodid lowest level. can not remove prodid hierarchy?
build hierarchy based on ids , change "namecolumn" property of attribute name, can see user friendly name being calculated id
Comments
Post a Comment