Skip to Content
0
Former Member
Apr 30, 2009 at 04:42 PM

OLAP data in Crystal Reports

59 Views

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.