cannot re-use calculated members from SSAS cube into SSRS reports.
-
Thursday, January 17, 2013 7:21 PM
Hi,
Although
I can use the calculated member in SSAS cube browser to filter data, cannot use
the same when using the cube as a datasource in SSRS.Here
Create
is the calc member script ( this is based on YtoY template)
Member
CurrentCube.[Dim Date].[Dates Dim Date Calculations].[Year Over Year Growth
%]
As "NA" ;
Create
Member
CurrentCube.[Dim Date].[Dates Dim Date Calculations].[Year Over Year
Growth]
As "NA" ;
Scope(
{
[Measures].[Units]
}
)
;
//
Year Over Year Growth %
(
[Dim
Date].[Dates Dim Date Calculations].[Year Over Year Growth %],
[Dim Date].[Calendar Year].[Calendar Year].Members ( 1 ) : Null,
[Dim
Date].[Date SID].Members
)
=
(
(
[Dim Date].[Dates Dim Date Calculations].[Current Dim Date],
[Dim Date].[Dates].CurrentMember
)
-
(
[Dim Date].[Dates Dim Date Calculations].[Current Dim Date],
ParallelPeriod(
[Dim Date].[Dates].[Calendar Year],
1,
[Dim Date].[Dates].CurrentMember
)
)
)
/
(
[Dim Date].[Dates Dim Date Calculations].[Current Dim Date],
ParallelPeriod(
[Dim Date].[Dates].[Calendar Year],
1,
[Dim Date].[Dates].CurrentMember
)
) ;
(
[Dim Date].[Dates Dim Date Calculations].[Year Over Year Growth %],
[Dim Date].[Calendar Year].[Calendar Year].Members ( 0 ),
[Dim
Date].[Date SID].Members
) = Null ;
Format_String(
(
[Dim Date].[Dates Dim Date
Calculations].[Year Over Year Growth %],
[Dim Date].[Date SID].Members
)
) = "Percent" ;
//
Year Over Year Growth
(
[Dim
Date].[Dates Dim Date Calculations].[Year Over Year Growth],
[Dim Date].[Calendar Year].[Calendar Year].Members ( 1 ) : Null,
[Dim
Date].[Date SID].Members
)
=
(
[Dim Date].[Dates Dim Date Calculations].[Current Dim Date],
[Dim Date].[Dates].CurrentMember
)
-
(
[Dim Date].[Dates Dim Date Calculations].[Current Dim Date],
ParallelPeriod(
[Dim Date].[Dates].[Calendar Year],
1,
[Dim Date].[Dates].CurrentMember
)
) ;
(
[Dim Date].[Dates Dim Date Calculations].[Year Over Year Growth],
[Dim Date].[Calendar Year].[Calendar Year].Members ( 0 ),
[Dim
Date].[Date SID].Members
) = Null ;
End
Scope ;
RRS
All Replies
-
Friday, January 18, 2013 8:57 AMModerator
Hi srituraj,
Calculations defined in Query Context can be reused only within the query while calculations defined in Global context can be reused across sessions. This means that measures which are defined within the global scope will come out faster after the first time it has been run (since it is already there in the cache) compared to the query scope measures. Details please see: http://beyondrelational.com/modules/2/blogs/65/posts/11592/where-to-store-calculated-measures-ssas-cube-or-ssrs-reports.aspx
Thanks,
Eileen
If you have any feedback on our support, please click here
Eileen Zhao
TechNet Community Support
- Edited by Eileen ZhaoMicrosoft Contingent Staff, Moderator Friday, January 18, 2013 9:01 AM
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Thursday, January 24, 2013 1:59 AM
.png)
