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

Question

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

KKottha

Old Hand

Points: 399
More actions
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....?

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

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

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 1

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

sanjeewan99 Say Hey Kid Points: 700 More actions · Answer 2

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

KKottha Old Hand Points: 399 More actions · Answer 3

KKottha

Old Hand

Points: 399

October 4, 2012 at 2:08 pm

#1545784

Thank you Robert and Sanjeewan......

KKottha Old Hand Points: 399 More actions · Answer 4

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?

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 5

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

KKottha Old Hand Points: 399 More actions · Answer 6

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