none
cannot re-use calculated members from SSAS cube into SSRS reports.

    Question

  • 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
    is the calc member script ( this is based on YtoY template)

    Create
    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

    Thursday, January 17, 2013 7:21 PM

Answers