Thursday, May 25, 2006

Key columns and dimension attributes

add key to hierarchy & create duplicate key attribute -

When you need to see the key of a dimension within an attribute or hierarchy, add a duplicate attribute for the key, and use this duplicate attribute rather than the existing key attribute.  This will increase aggregations and (supposedly) improve query performance.