Unable to display detail data

[sharda]

Hello,

I am trying to drill through from a information map I created from a cube but received this error message:

The immediate MDX execution failed

• The server encountered an error accessing a source data table.

Thanks,
Sharda

[sharda]

Hello All,

Any reason as to why I am unable to drill through using WRS from an IM that was created by an OLAP cube? Is there a permission issue?

Thanks,
Sharda

[Madelyn_SAS]

This SAS note explains several reasons why you might not be able to drill through to detail data in SAS Web Report Studio:

http://support.sas.com/kb/24/491.html

Also, you do need to enable the drill-through capability in the information map. Open the properties for the map. There is an "Allow drill-through to detail data" option.

[sharda]

Thank you Madelyn,

I will go through the options and let you know the results.

Sharda

[sharda]

Hello Madelyn,

One of the options to fix the error is to do this, where do I do this and what changes to the code below do I need to make:
1. Limit the number of returned rows using the MDX DRILLTHROUGH
statement:

DRILLTHROUGH maxrows 1000 firstrowset 5000
select .... on columns,
.... on rows
from ....

This will retrieve rows 5000-6000.

Thanks,
Sharda

[sharda]

hello Madelyn,

Could you please let me know where I can find the steps to achieve one of the recommendation you suggested below?

Limit the number of returned rows using the MDX DRILLTHROUGH
statement

Thanks,
Sharda

[Madelyn_SAS]

This will require assistance from OLAP Server specialists in technical support. Please fill out the request form, providing as many details about the issue as possible:

https://support.sas.com/ctx/supportform/createForm

[sharda]

Ok thank you Madelyn.