June 9, 2011 at 1:03 am
Hi,
I have created calculated measures [monthrevenue] for month, [yearrevenue] for year.
In actions tab, I created new drill through action. In that, Drill through columns, while selecting Measures, I can't see the above calculated measures. I see only default measures that are created while creating cube.
Please help.
Thanks.
Thank You
June 9, 2011 at 5:27 am
By default, you can't use drillthrough with calculated measures. There are ways around it though, as is discussed here:
http://sqlblog.com/blogs/mosha/archive/2008/09/01/drillthrough-on-calculated-measures.aspx
Drillthrough's are expanded upon in the ASSP project on codeplex:
http://asstoredprocedures.codeplex.com/wikipage?title=Drillthrough&ProjectName=asstoredprocedures
Hope this helps 🙂
June 9, 2011 at 5:58 am
Thanks for the reply.
However I heard that we can set scope for calculated measures so that the calculated measures will appear for drill through.
How far it is correct?
Thanks.
Thank You
June 9, 2011 at 8:08 am
I think if you tried that SSAS would still know that it is a calculated measure being used in the scope.
I had a quick google search and found this from a SQL Server board:
instead of a calculated member, one could create a physical measure, and then override its values using Scope statements with the calculation that needs to be performed? That way, to client applications this will still appear as a measure and drill through actions wouldn't be prohibited.
I have no idea if this approach would work though. If you do try it then post back what the result was.
Good luck 🙂
June 10, 2011 at 7:18 am
Thanks a lot for your help.:-)
It worked. I created a physical measure with 0 value. Later in calculations, I override its value using MDX scope
Thank You
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply