Anybody ever done any Crystal Reports based off an Analysis Services database?
I got tasked with what I thought was a simple job of developing some crystal reports from a sql server database, only to find out that the data source is actually an OLAP cube.
Crystal appears to be very limited in its ability to create and format reports from OLAP datasources. Is it possible to treat this like a regular datasource in order to get more reporting functionality? I am really not interested in the pivot functionality, since these will just be canned reports.
P.S. If you want to know why the data is in a cube rather than a reporting database, the answer is "Nobody asked me".