Connecting to MS SQL Analysis Cube Using Information Design Tool

[former_member242731]

Hi

Please I created an OLAP Cube in the MS SQL Analysis how can I connect to it using Information Design 4.1 Tool as it is my first Time ?

Regards

[former_member242731 · Accepted solution]

What Value Shall replace the Server (http://Servername/olap/msmdump.dll) , and how can I publish the Cube Through the HTTP ???

[Henry_Banks · Accepted solution]

Hi,

"server name" is the name of your OLAP host

here are some how-to wikis

Microsoft SQL Server Analysis Services (SSAS) OLAP Connection - Business Intelligence (BusinessObjec...

How to configure HTTP access to SQL Server Analysis Services on MICROSOFT Windows Server - Business ...

Setting up OLAP Microsoft Analysis Service through an XMLA connection with SSO - Business Intelligen...

Regards,

H

[former_member242731 · Accepted solution]

thank you

[Henry_Banks]

Like this http://scn.sap.com/docs/DOC-22025 

[Henry_Banks]

followed by this

[Henry_Banks]

Hi,

wrong forum, i've moved you to semantic layer

there are tutorials for this.  Have you searched?

you need to create an OLAP connection in IDT, then create a Business Layer (customiseable universe outline) and publish it to repository. 
(this will create a UNX universe which client tools can consume i.e. Webi, Crystal, Dashboards etc)

However, for pure olap use-case, you should be using a tool like Analysis.  In this case, you need only consume the olap connection

regards,

H