SAP NetWeaver BI with Microsoft SQL Server 2012 Reporting Services using XMLA

[Former Member]

I am currently implementing SAP BW and am trying to connect the Microsoft SQL Server 2012 Reporting Services product.  I am able to connect to SAP BW but there is one problem when i click on Query Designer after adding a DataSet the screen just displays the dialog prompt saying '' NO CUBES WERE FOUND. VERIFY THAT YOU HAVE SELECTED A VALID CATALOG''.

The advanced information depicts the following:

[Former Member]

We are using port number as 8000 but the port number generated at the end of XML file is 8101, after running Test Service in XMLA.
May i know why is it so?

[Former Member]

Hello Raunak,

I am getting exactly the same problem you get with the Reporting Services query (I am using Reporting Services 2008 R2). Have you been able to resolve the problem? If yes, I will be thankful if you can tell me how you managed to solve the problem.

Thank you in advance,

Khalil NaserAldin

[srinivasan_vinayagam]

Hi Ranuak,

Follow this thread to solve your issue

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/007b637b-c7af-2e10-f089-c2690ae04...

[Former Member]

Hi Srinivasan,

sorry but the problem still persists. I used the same steps.

[Prabhith]

Hi ,

Just a very basic question from my end:

I believe that "Microsoft SQL server Report Builder" is the 3rd party which uses MDX as interface.

Have you set the property using OLE DB for OLAP in your queries?

BR

Prabhith

[Former Member]

Yes i have

[jeff_albion]

Hi Raunak,

I don't believe this question is related to SQL Anywhere. I have moved this question to as I believe that is the most appropriate resource...?

Thanks,

Jeff Albion

SAP Active Global Support