MDX Query max allowed length?

[Benny Bürger]

Hi,

is there a maximal allowed length for a MDX Query?

I have a problem where the following error occurs:

FEHLER #5002: Caché-Fehler: <SUBSCRIPT>%CombineFiltersWithSlicer+74^%DeepSee.Query.query.1 *tSetText("...

I could create an example in which the same error occurs using the samples namespace:

DRILLTHROUGH SELECT FROM [Patients] %FILTER [AgeD].[H1].[Age Group].&[30 to 59] %FILTER [AgeD].[H1].[Age Bucket].&[50 to 59] %FILTER {[AgeD].[H1].[Age].&[50],[AgeD].[H1].[Age].&[51],[AgeD].[H1].[Age].&[52],[AgeD].[H1].[Age].&[53],[AgeD].[H1].[Age].&[54],[AgeD].[H1].[Age].&[55],[AgeD].[H1].[Age].&[56],[AgeD].[H1].[Age].&[57],[AgeD].[H1].[Age].&[58],[AgeD].[H1].[Age].&[59],[AgeD].[H1].[Age].&[50],[AgeD].[H1].[Age].&[51],[AgeD].[H1].[Age].&[52],[AgeD].[H1].[Age].&[53],[AgeD].[H1].[Age].&[54],[AgeD].[H1].[Age].&[55],[AgeD].[H1].[Age].&[56],[AgeD].[H1].[Age].&[57],[AgeD].[H1].[Age].&[58],[AgeD].[H1].[Age].&[59],[AgeD].[H1].[Age].&[50],[AgeD].[H1].[Age].&[51]}

By removing one entry from the Query everything is working fine:

DRILLTHROUGH SELECT FROM [Patients] %FILTER [AgeD].[H1].[Age Group].&[30 to 59] %FILTER [AgeD].[H1].[Age Bucket].&[50 to 59] %FILTER {[AgeD].[H1].[Age].&[50],[AgeD].[H1].[Age].&[51],[AgeD].[H1].[Age].&[52],[AgeD].[H1].[Age].&[53],[AgeD].[H1].[Age].&[54],[AgeD].[H1].[Age].&[55],[AgeD].[H1].[Age].&[56],[AgeD].[H1].[Age].&[57],[AgeD].[H1].[Age].&[58],[AgeD].[H1].[Age].&[59],[AgeD].[H1].[Age].&[50],[AgeD].[H1].[Age].&[51],[AgeD].[H1].[Age].&[52],[AgeD].[H1].[Age].&[53],[AgeD].[H1].[Age].&[54],[AgeD].[H1].[Age].&[55],[AgeD].[H1].[Age].&[56],[AgeD].[H1].[Age].&[57],[AgeD].[H1].[Age].&[58],[AgeD].[H1].[Age].&[59],[AgeD].[H1].[Age].&[50]}

Is there something like an upper limit and if there is one is it possible to extend it somehow?

Thanks for any useful hints.

Benny

[Benny Bürger]

The problem occurs only when using a DRILLTHROUGH. 

Without a DRILLTHROUGH the MDX query seems to have no length limit...

[Amir Samary]

I have also found this problem and filled a Prodlog for it with a quick and dirty solution so I could keep going... Try opening a WRC reporting the problem and mentioning my name so support may decide if the can share the dirty patch with you or if what I did is more dangerous than the problem itself (it worked for me though).

Kind regards,

Amir Samary

Sent from my iPad

On 05-02-2014, at 9:09, Benny Bürger <benny....@gmail.com> wrote:

The problem occurs only when using a DRILLTHROUGH. 

Without a DRILLTHROUGH the MDX query seems to have no length limit...

--
--
You received this message because you are subscribed to the Google
Groups "InterSystems: DeepSee Community" group.
To unsubscribe from this group, send email to
intersystems-deepsee-...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/intersystems-deepsee-community?hl=en?hl=en
 
---
You received this message because you are subscribed to the Google Groups "InterSystems: DeepSee Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-deepsee-...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Benny Bürger]

Ok, I opened a ticket at WRC.

Thanks for the information,

Benny

2014-02-06 Amir Samary <amirs...@gmail.com>:

You received this message because you are subscribed to a topic in the Google Groups "InterSystems: DeepSee Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/intersystems-deepsee-community/VjrA9rMLGjc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to intersystems-deepsee-...@googlegroups.com.