topic Re: Unable to display detail data in SAS Web Report Studio

Unable to display detail data

sharda — Fri, 03 Jun 2016 14:50:22 GMT

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

Re: Unable to display detail data

sharda — Mon, 06 Jun 2016 13:30:52 GMT

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

Re: Unable to display detail data

Madelyn_SAS — Tue, 07 Jun 2016 13:53:07 GMT

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.

Re: Unable to display detail data

sharda — Tue, 07 Jun 2016 20:53:00 GMT

Thank you Madelyn,

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

Sharda

Re: Unable to display detail data

sharda — Wed, 08 Jun 2016 13:50:41 GMT

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

Re: Unable to display detail data

sharda — Tue, 14 Jun 2016 16:38:11 GMT

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

Re: Unable to display detail data

Madelyn_SAS — Tue, 14 Jun 2016 17:36:37 GMT

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

Re: Unable to display detail data

sharda — Fri, 17 Jun 2016 14:39:41 GMT

Ok thank you Madelyn.