Custom MDX queries

Hi Team,

The product is fantastic and lot of options where we need to have explore on periodically.

In pyramid 2018 we want to write the custom MDX queries. Can you please help us so that we can proceed further. 



B Rama Krishna

Artha Solutions

3 replies

    • Rama_Krishna_B
    • 6 yrs ago
    • Reported - view

    pyramid team,can you please help us on this

    • Yakov_Shaul
    • 6 yrs ago
    • Reported - view

    Hi Rama,
    In Pyramid 2018 we do not currently support custom MDX because of the complexity involved in matching things up in the client tools. Since the product now supports multiple scripting types, direct SQL/MDX queries, our internal PQL query engine converts the right UI selections into their proper syntactical language. Making this customizable has some major drawbacks for processing and stability. Instead, we aim to deliver the same customizable outcomes in the query through calculated members, sets and the relationship editors in the modeling.

    Never the less, the dev team says there is still a possibility that it will be added sometime in 2018 specifically for MDX.

    Kind Regards,

    • Rama_Krishna_B
    • 6 yrs ago
    • Reported - view

    Thank you  yakov.

Content aside

  • Status Answered
  • 6 yrs agoLast active
  • 3Replies
  • 189Views
  • 2 Following