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

Popular posts from this blog

java - Play! framework 2.0: How to display multiple image? -

gmail - Is there any documentation for read-only access to the Google Contacts API? -

php - Controller/JToolBar not working in Joomla 2.5 -