I am trying to create a report in crystal from actuate. I have a stored procedure residing in OLAP database. The access in the application is through EPM database. So in Actuate, the connection is established through EPM database and the stored procedure used to create the report is accessed as AUDIT_TRAIL@OLAPDB.
I created the report in crystal by directly connecting to the OLAP database and it works fine. But the performance is very bad( about 6-7 times slower than Actuate). So I was wondering if there is a way to connect to EPM database in Crystal but access the stored proc in OLAP somthing like
Any help is appreciated. Not sure if there is a way in crystal and if so how to set this up.
Thanks,
Kiran
IP Logged