I understand that calculated measures can't be coupled with drillthrough, but maybe there's another way.
I define a calculated measure with a L30 days flag that starts on the last day with order data. Now if I use this flag in conjunction with the Order Sales measure, then I can do a drillthrough. Problem is, with excel (2000 version), how could I get last 30 days w/o using the calculated measure?
Is there a way to define a measure with a combination of attribute filters that would allow drillthrough and also be accessible from excel and last but not entirely needed: have the definition housed in the AS project so that it's logic is centralized and reusable?
What version of the Analysis Services do you have?
What calculation do you use to determinate current date and last 30 days?
|||I'm using ssas 2005 sp2
The calculation is: SUM([L30 Days].&[Yes], [Sales])
|||You could try setting up a many to many relationship although this might require having two date dimensions, one that is linked to the actual date and one that is linked via an intermediate measure group to itself and the previous 29 days. Marco Russo's whitepaper on many to many relationships at www.sqlbi.eu shows how drilltrhough works with many to many relationships.
No comments:
Post a Comment