0 Replies Latest reply on Apr 10, 2015 8:18 PM by rkomma

    Using MDX query in RPD

    rkomma

      I have a MDX query that I want to use in the RPD as "Table Type" =Select

      I did create a new object as "Physical Dimension" and gave the below script as Essbase 11 specific SQL, but this does not work and an getting the generic error "[nQSError: 15002] Missing navigation space for subject area test. (HY000)". Any Idea as to how to use the MDX in RPD?

       

      MDX Script:

       

      with set classes as '{[Class_Data],[Inventory_Class_Data]}'

      set ledgers as '{[Actuals_Ledger],[Finance_Ledger],[Reclass_Ledger],[Allocation_Ledger],[Blending_Ledger],[HCSADJ_Ledger]}'

      set bu as '{[UTHCS],[UTMBG],[CONSL]}'

      set account as 'Except ({filter ([Accounts].Levels(0).members, IsAncestor([SRECNA],[Accounts].CurrentMember)),

      filter ([Accounts].Levels(0).members, IsAncestor([MISC_AUDIT],[Accounts].CurrentMember)),

                                        filter ([Accounts].Levels(0).members, IsAncestor([SNA],[Accounts].CurrentMember))},{[Change in Net Assets and Restatements]})'

      set funds as '{filter ([Fund].Levels(0).members,IsAncestor([All_Funds],[Fund].CurrentMember)),

      filter ([Fund].Levels(0).members,IsAncestor([Do Not Use Funds],[Fund].CurrentMember))}'

      select {[Act]} on columns,

      Non Empty (CrossJoin(CrossJoin(

      CrossJoin(account,funds),

      CrossJoin(ledgers,bu)

      ),classes)

       

       

        ) on rows

      from [finrpt15.work]

      where (FY15,YTD_Apr,UTMB_INSTITUTION);







      Thanks,

      Ravi