2 Replies Latest reply on Dec 19, 2016 6:24 AM by 02ed818fde09e559d4f05c32551dc435d6e13989

    MDX Expressions in RCE



      RCE module allows to create custom MDX expressions. It works well as long as it is about simple expressions but I have an issue building some more sophisticated ones. For that matter, we need to have the exact name of a cube member that is usually decribed as (if I remember ...) [Dimension].[Hierarchy].[Parents].[member ID] or close.


      Where can I find this info? Or is there an editor I missed?




        • Re: MDX Expressions in RCE
          Courtney Grimes

          Hi Christine,

          Unfortunately,most of RCE's MDX capabilities are swept under the rug--and it's always been a sore point for me that the tech RCE is based on allows for MDX queries but RCE strips this.


          With the new UI update, it looks like perhaps even the ability to format output via MDX has been removed? The closest I can find is the Calculated Measure editor prompt. At any rate, it used to be much more prominent.