XQE-MDX-0017 error

[kolla]

Hi All,

I have created a list report in report studio using Dimension model .

List 1 -- Query1 - and corresponding prompts

List 2 -- Query2 - and corresponding prompts

while running the report I am getting the below error.

XQE-MDX-0017
The query: "Query1" requires more resources than allowed. The number of rows returned in the MDX exceeds the maximum.
The allowable value is "8" OOM and the estimated value is "11.7" OOM (OOM is the order of magnitude, i.e. log10(N), where N the number of elements).

help me to resolve this issue.


Thanks,
Kolla

[kolla]

Hi All

I found the solution..

In query explorer ---> Select the query
In properties pane : set Suppress as Nulls

attached screenshot is for your reference.

Please let me know if you find any alternative solution..

Thanks,
Kolla

[kolla]

sorry Guys
the above solution is not working
can anyone help me on this