MicroStrategy ONE

MDX Treat Key Date Qualification as ID Date Qualification

The MDX Treat Key Date Qualification As ID Date Qualification VLDB property determines how date qualifications are processed for MDX cube sources. You can choose from the following settings:

  • Do not treat a date qualification on a key form as a date qualification on an ID form: This option processes date qualifications by using the member properties. While this can impact performance, you can use this option to support date qualifications on data that cannot be processed by using the unique name.
  • Treat a date qualification on a key form as a date qualification on an ID form (default): This option provides the best performance for processing date qualifications by using the unique name rather than the member properties.