Post reply

ssrs report using SSAS and OLTP both for data source

  • August 25, 2015 at 1:18 pm

    #299944

    i am creating ssrs report, i got to use SSAS as well as OLTP both for data source, for example some fields might be from cube, some from relational data base.

    how could i do it? please help. many thanks.

  • August 26, 2015 at 8:03 am

    #1822488

    You can display both of the values in one report but in separate grids, but they cannot be in the same grid. For example, you cannot have 5 column in the same tabel in SSRS with Column 1,2,3 from OLTP and Column 3,4 from OLAP. It's just not possible based on set based language like SQL.

    If you want the data on separate grids, you need to create two data sources, one for OLAP and one for OLTP. Then put data in two different tables.

    If you want to display data on the same table, then you need to stage data from OLTP and OLAP. Find relationship between both, and join the data so they are in the same select statement. Then use that select statement to run the SSRS report.

    ------------
    🙂

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply