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
Thanks,
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
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.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Thank you Madelyn,
I will go through the options and let you know the results.
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
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
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Ok thank you Madelyn.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.