Skip to Content
0

Crystal (BOBJ) MDX connection to MS Analysis Services cube

Mar 05, 2017 at 04:52 PM

76

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Joe Peters Mar 06, 2017 at 01:21 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded