Dimensional Modelling: Excluding Unused Dimension Attribute Members
User Rating: / 19
Written by Benny Austin   
Thursday, 23 May 2013 18:20

In a self-service BI platform, every member of a dimension attribute is available for browsing irrespective of whether the member has an associated fact or not. Though the unused members disappear when browsed alongside facts, they are still undesirable when used as filters. This is especially true with role playing dimensions which cover a broad range of data to cover every scenario. No one wants a date filter starting at 1900-01-01 and going all the way to 9999-12-31.




Pyramid Analytics