Crystal (BOBJ) MDX connection to MS Analysis Services cube

[former_member261222]

Hello.

Need help using Microsoft Analysis Services MDX code in Business Objects (Crystal 2016, ideally,… but not picky).

We have existing Microsoft Reporting Services reports that we need to port to BOBJ so we can retire the MS Reporting Servces servers. The MDX is fairly involved, so we’d rather not recreate the logic from scratch for each.

We can run the MDX in Microsoft SQL Mgt Studio against our MS Analysis Services server,… get back good data in table format. Ideally, I’d like to use this MDX directly in Crystal (or any BOBJ tool),… similar to how I can use SQL code directly in Crystal. Is this possible?

I've looked into:

(1) Crystal 2016 has an OLAP Report Wizard,… which connects to the cube and brings back a pivot table. No opportunity to edit/replace the MDX that I can see?

(2) This Wiki suggests using IDT to create a Universe using an XMLA OLAP connection,… and then use Crystal Enterprise or WEBI. However, requires updating the MS Analysis Server to support XMLA.

Software versions:

* MS SQL/Analysis 2005

* BOBJ 4.2 SP2. Crystal 2016, Crystal Enterprise, WEBI, IDT, UDT

Any thoughts or ideas would be appreciated.

Thanks in advance!

-Joel

[Joe_Peters]

For what it's worth....

2) Yes IDT requires a connection to msmdpump, but that doesn't have to be installed on the SSAS server. All it needs is an IIS server and a couple of files copied from SSAS. If you have IIS running on your BO server, you could actually set it up there.