We have a dimension that reflects person age and the cube will be used for SSRS reports that can be run as of last year, or 2 years ago, or present time (or more variations). Obviously the age will be different depending on the report 'as of' date; Any
way to configure discretizations buckets to be dynamic? And if the user will select the bucket without a date member (say pulling that attribute directly into an Excel pivot table) what would be a good way to gracefully handle it?
View Complete Post