Sunday 15 April 2012

reporting services - Time Duration Measure using Dimensions in SSAS -



reporting services - Time Duration Measure using Dimensions in SSAS -

one requirement of bi project have create duration measure shows sla start date of case until date of study (ssrs study parameter). i'm trying create calculated measure in cube. safe have datetimes in dimensions , calculate measure way? there improve way design dimensional model this? think become performance issue (not sure if it's possible).

create fellow member measures.x [dimtime].[datetime_int_value].currentmember.value - [dimcase].[startdate_int_value].currentmember.value

reporting-services ssas mdx dimensional-modeling

No comments:

Post a Comment