Traditional web-based reporting with SAS BI tools

Unable to display detail data

Reply
Contributor
Posts: 40

Unable to display detail data

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

 

 

Contributor
Posts: 40

Re: Unable to display detail data

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

SAS Super FREQ
Posts: 435

Re: Unable to display detail data

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.

Contributor
Posts: 40

Re: Unable to display detail data

[ Edited ]

Thank you Madelyn,

 

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

 

Sharda

Contributor
Posts: 40

Re: Unable to display detail data

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

Contributor
Posts: 40

Re: Unable to display detail data

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

SAS Super FREQ
Posts: 435

Re: Unable to display detail data

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

 

 

Contributor
Posts: 40

Re: Unable to display detail data

Ok thank you Madelyn.

Ask a Question
Discussion stats
  • 7 replies
  • 588 views
  • 0 likes
  • 2 in conversation