How to Enable XMLA Query Size Protection

There are two custom advanced engine settings:

  • query.language.mdx.cellLimit.enabled
  • query.language.mdx.cellLimit.value

To prevent large MDX result sets from hindering the AtScale engine's stability and performance. These settings add a configurable cell limit for MDX-only queries.  

Procedure

  • query.language.mdx.cellLimit.enabled - Enable if you want to configure an MDX query cell limit. This setting is enabled by default and can be toggled off.
  • query.language.mdx.cellLimit.value - Input a numerical value stipulating the MDX query cell limit. The default cell limit is one million.  An MDX query's cell count is the number of cells that contain measure values in the result set.

    1. Select Settings > Engine beneath Organization Settings. 
    2. Use your browser's search function to search query.language.mdx.cellLimit.enabled
    3. Enable or disable the setting.
    4. Search query.language.mdx.cellLimit.value. Set the value if the setting in Step 2 is enabled. 

Was this article helpful?

0 out of 0 found this helpful