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