Skip to Content
avatar image
Former Member

Extracting data from Microsoft SSRS Cubes into SAP BW

Hi Experts ,

I have a requirement where I need to extract data from Microsoft SSAS Cubes into SAP BW .

Scenario:

Data present in the SQL server database is used by the MS - SSAS (Analysis Service) and after many calculations and formula implementations, it is coming to MS- SSAS cubes from where  reports are generated .

Now my requirement is to extract data from these MS-SSAS cubes into SAP BW .

can anyone guide on how can I do that . How the connections will be maintained on both sides . It would be great if anyone can give any step-by-step document for the same .

Many thanks in advance .

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 05, 2015 at 12:49 PM

    Hi Samir,

    It is possible in SAP BW.

    You need to use DB Connect and setup a connection with SSAS data base.

    Similar document SAP BW 7.3: How to extract data from SQL Server using DB Connect

    Regards - Kumar

    Add comment
    10|10000 characters needed characters exceeded