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
Creating Beautiful Reports
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
Creating Beautiful Reports
SAS Visual Analytics Learning Center
Ok thank you Madelyn.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.