September 8, 2011 at 1:57 am
Hi all,
I've just built a training cube for a department in my company and have noticed when shadowing users that particular dimensions are being used again and again. The cube has a few hundred dimensions.
This is just a thought, but is there anyway in SSAS I can create a "Frequently Used Dimensions" grouping in Dimensions, so users can quickly navigate to these (users are currently all accessing via Excel 2007 Pivot Tables).
Ta
Neil
September 8, 2011 at 4:40 am
I am not sure there is any way to do it automatically, but you could always create a perspective that only includes the dimensions that are mostly used based upon your observations.
September 8, 2011 at 4:41 am
Of course, was staring me in the face! Thanks!:-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply