When using an OLAP datasource such as Essbase, the only way I can find to get at the data is to insert an OLAP Grid into the report header/footer section.
What I would like to do is display the data in other sections (eg. detail section), outside of the OLAP Grid. Mainly so I can combine it seemlessly with data from other sources.
In Crystal Reports Designer, is there a way for me to either:
1. Refer to the data in the OLAP Grid using a Formula Field?
2. Access OLAP data directly without using the OLAP data grid?
I looked at some of the MDX info in the help section, but it seems to me that the functionality only exists within the OLAP Grid.
I am currently using Crystal Reports 2008.
A big thanks to anyone that can help.