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
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
sorry Guys
the above solution is not working
can anyone help me on this