Reporting Service with Analysis service

I compose two servers. One is for Reporting service and the other is for
Analysis Service. I developed one report with analysis services's cube as a
datasource.
but the report does not execute properly. the message is for datasource
connection error.
So I compose the server again as one server. The RS ans AS installed in this
server.
The report works properly!
Is it impossible to install at seperate server ?
I used SQL server 2000 with current sevicepack.Hey,
It does work with 2 different servers. You may be having issues with
authentication or permissions.
If possible use an admin account from Analysis server in the connection
properties of the datasource.
Bye
Sumit Pilankar
"fogcity" <fogcity@.discussions.microsoft.com> wrote in message
news:FA13FF31-94D4-4619-8E9B-212252B372EF@.microsoft.com...
>I compose two servers. One is for Reporting service and the other is for
> Analysis Service. I developed one report with analysis services's cube as
> a
> datasource.
> but the report does not execute properly. the message is for datasource
> connection error.
> So I compose the server again as one server. The RS ans AS installed in
> this
> server.
> The report works properly!
> Is it impossible to install at seperate server ?
> I used SQL server 2000 with current sevicepack.
>

Reporting Service vs UDM

I am new to both technologies and would has been reading UDM on how to create a cube. My orginal intention is to create cubes for efficient retrieval of data which ends up in reports managment in an application. Can anyone elaborates on how the reporting service differs from UDM? ( or what reporting services are?)I thought they are mutually exclusive?Thanks.

Regards

Alu

Does it mean that the report service generates reports from OLTP database if the UDM is not created? Does it mean UDM can work with reporting serivce which theortically speaking making the best of both if implemented?Thanks.

Regards

Alu

|||

UDM is actually the cube. You can design MDX/Cube-queries in Reporting Services and Report Builder. There is a graphical design tool in RS 2005.

It also possible to query a data warehouse, data mart or OLTP-system with TSQL queries. Reporting Services is not limited to SQL Server for SQL-queries. It will also work with Oracle and DB2.

The only OLAP-engine that is supported is Analysis Services.

HTH

Thomas Ivarsson

|||

I know that alot time decision to use SSRS with or without SSAS(UDM) and vice -versa depends on customer requirements. But generally speaking is there a general guidline on when to favour SSRS without/with SSAS and vice-versa?

Thanks.

Regards

Alu.

|||or rather which is the most common practice among the two combinations? ( with /without)|||

I think both approaches work. Cube-queries is normally about top level, aggregated information.

Relational queries(SQL) are normally leaf level.

OLAP cubes are less efficient with leaf level queries(long responstime) and relational queries(SQL) are less capable with top level queries(also long responstime)

In SSAS you can also relate these two worlds by using actions. An action in SSAS can point to a detailed report in Reporting Services.

It is also easier to create time caculations, like rolling 12 months, Year To Date and so on, in SSAS. You can write these calculation with less code in MDX than SQL will require.

HTH

Thomas Ivarsson

|||

Can i say that whether to use UDM or not depends on the type of reports customer would want?

Regards

Alu

|||

Yes. Thats my opinion. Most customers like both types of reports, leaf level and top level.

Regards

Thomas Ivarsson

|||

But even if thats does, to implement UDM ( if in the initial phase we dont even know if aggreate information is required in future)as well in the application does not harm right? :)

Regards

Alu

|||

UDM/the cube is a separate engine so it will not harm to build cubes.

Regards

Thomas Ivarsson

|||

Thanks alot!.

Regards

Alu

Reporting on an Analysis Services data cube

Hello,

The problem I am having is I am trying to report on an Analysis Services data cube.

I connect fine but for some reason the "MDX query designer" does not appear as an option for creating the query for this data source. Is there a component of SQL 2000 or visual studio I am missing

Any help Would be great

Thank you

One good starting point might be this link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en

It is a rs 2000 sample that uses cubes. I hope this helps

|||Just to confirm - are you using RS 2005 with the Analysis Services Provider - otherwise you won't get the MDX Query Designer?|||

Thank you for your help. I unfortunately am only using RS2003.

SO i need to upgrade to RS 2005 and install Analysis Services Provider before ill get the designer ?

|||

You would need to upgrade RS 2005 - the Analysis Services Provider should get added as part of the upgrade:

http://msdn2.microsoft.com/en-us/library/ms170417(SQL.90).aspx

>>

What's New in SQL Server 2005 > Reporting Services Enhancements

Reporting Services Design-Time Enhancements

New Analysis Services Query Designer

Report Designer includes a new query designer for creating MDX queries. You can use the integrated query designer for Analysis Services to build queries by dragging and dropping server metadata onto a report layout and previewing the results.

>>

Reporting on a Cube -- Time Dimension Issue

Hello,

I have an Analysis Services Cube that I would like to report on. However, the Time Dimension currently only has four columns, Day of Month, Month(name) , Year, and DateKey (DateTime representation at midnight for every day). Thus when I drag the month attribute onto the report, it is sorted April - August - December - etc. instead of Jan - Feb - Mar. How do I fix this? I remember reading something in the MSDN Library about it but I can't find it again now.

ThomasJust remove sorting for Time group in Report. It's well known problem.|||Hmm, I haven't added any sorting, this is just drag-and-drop from the list of dimensions in the "Report Builder" tool for Reporting Services and in Visual Studio. So I haven't added any sorting, however in VS I can modify the User Sort - Value property. Unfortunately if I remove it or set it to another field (my date key field) VS crashes when I try to preview. Any other suggestions?|||The Month attribute KeyColumns should be defined as a composite key consisting of the Year and Month column. This should get sorting right because if no Sort attribute is specified UDM will sort by the key. Take a look at how the Month attribute is defined in the AW sample cube.|||Thanks a bunch, but here's a funny story. I actually figured that out and was coming here to post the answer in case any one else needed it. Seems like you beat me to the punch. Thanks again anyways!