Post reply

How to convert BO reports to SSRS reports and reports from cubes

  • October 3, 2012 at 9:11 am

    #282509

    We have alraedy BO reports......

    But our data is in tables and cubes......

    Do u have idea how can we connect to cubes and do the reports....?

  • October 3, 2012 at 12:30 pm

    #1545148

    Are you trying to use SSRS to connect to a SSAS cube? or SSRS to connect to an DB2 OLAP source?

    Either way, you should be able to create a new datasource that links to your cube. Just select the appropriate connection type, point to the correct server and OLAP database. Then you can create a new dataset and you're on your way.

    HTH,

    Rob

  • October 4, 2012 at 3:28 am

    #1545410

    Hi ,

    If you are using SSRS Reports you have to create two data source one for Cube and one for TSQL,

    For more detail you can have look into this link

    http://www.bi-rootdata.com/2012/10/passing-multi-value-tsql-parameter-to.html

    http://www.bi-rootdata.com/2012/09/execute-mdx-query-with-tsql.html

  • October 4, 2012 at 2:08 pm

    #1545784

    Thank you Robert and Sanjeewan......

  • October 4, 2012 at 2:20 pm

    #1545797

    1. can we use Report Builder 3.0 to create adhoc reports? Is this statement correct?

    2. To create a model from a SQL Server Analysis Services cube, you must use Report Manager. Model Designer cannot be used to create models from cubes, and a cube-based model cannot be modified in Model Designer afterwards

    If your model is generated from a Analysis Services cube and the cube has been changed, you should regenerate the model. To make the Analysis Services cube-based model more efficient, it is recommended that you make your changes within the cube.

    3. Below is conversation between 2 persons:

    Hi,

    Our client needs a reporting tool which allows the end-users to create adhoc reports

    Backend is OLAP (SSAS) cube.

    I tried Report Builder in SSRS. But it cannot use SSAS cube.

    Please suggest a reporting tool which can use SSAS cube as back-end and allows the users to create adhoc reports.

    Thanks.

    -----------------------------------------------------------------------------------------------------------------

    AFAIK Report Builder can be used to build ad hoc reports using a cube as an initial data source.

    1. Create and publish a Report Model from an SSAS Cube: http://msdn.microsoft.com/en-us/library/ms345292(v=SQL.105).aspx

    2. Publish the Report Model (see Lesson 5): http://msdn.microsoft.com/en-us/library/ms167048.aspx

    3. Use Report Builder to create reports from the Report Model. http://msdn.microsoft.com/en-us/library/dd220475.aspx

    All this 3 statements are correct? I am so confused with this.......How can we craete a Report Model using cube? Where can We create? In Report manager Or Model Designer? If so Can we change that?

  • October 5, 2012 at 6:13 am

    #1546017

    Report Builder 3.0 can use a SSAS cube for its datasource. What makes you think it can't?

    Create a new Data Source. Choose the 'Microsoft SQL Server Analysis Services' as the connection type. Choose the server and database. Then build your dataset using that data source you just created.

    Rob

  • October 5, 2012 at 7:38 am

    #1546078

    1. Can I build SSRS Reports(Report Server Project) by using SSAS cube? If I do this by using Report builder "USERS" can build their Ad hoc Reports? Can I modify this afterwards, if I want to make any changes?

    2. Can I build SSRS Models(Report Model Project) by using SSAS cube? If I do this by using Report builder "USERS" can build their Ad hoc Reports? Can I modify this afterwards, if I want to make any changes?

    Thanks,

    Keerthi

Viewing 7 posts - 1 through 6 (of 6 total)

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