dbTalk Databases Forums  

Microsoft Reporting Services

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Microsoft Reporting Services in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John Keeley
 
Posts: n/a

Default Microsoft Reporting Services - 07-21-2003 , 04:00 AM






What is the scope of Microsoft Reporting Services?
Will it be a reporting tool that reads both relational &
multidimensional data?
Will it be able to combine data from more than one cube & have
calculations performed on them?
Will there be any dynamic narratives (i.e. a way of storing comments
to dynamic data)?
Will it be web & windows based?
Can the data be presented in Excel & still be dynamic?
What are the main competitor tools? Crystal Reports/Analysis? Cognos
Impromtu/PowerPlay? ProClarity? Novaview?

Regards,

John

www.a-la-li-la.org

Reply With Quote
  #2  
Old   
Jacco Schalkwijk
 
Posts: n/a

Default Re: Microsoft Reporting Services - 07-21-2003 , 07:16 AM






http://www.microsoft.com/sql/evaluat...ngservices.asp

answers most of your questions.

--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.


"John Keeley" <duvinrouge (AT) servihoo (DOT) com> wrote

Quote:
What is the scope of Microsoft Reporting Services?
Will it be a reporting tool that reads both relational &
multidimensional data?
Will it be able to combine data from more than one cube & have
calculations performed on them?
Will there be any dynamic narratives (i.e. a way of storing comments
to dynamic data)?
Will it be web & windows based?
Can the data be presented in Excel & still be dynamic?
What are the main competitor tools? Crystal Reports/Analysis? Cognos
Impromtu/PowerPlay? ProClarity? Novaview?

Regards,

John

www.a-la-li-la.org



Reply With Quote
  #3  
Old   
claudio
 
Posts: n/a

Default Re: Microsoft Reporting Services - 07-21-2003 , 10:06 AM



I think that this link is more appropriate for yours questions:

http://www.microsoft.com/technet/tre...L/sql0625.asp]


"John Keeley" <duvinrouge (AT) servihoo (DOT) com> wrote

Quote:
What is the scope of Microsoft Reporting Services?
Will it be a reporting tool that reads both relational &
multidimensional data?
Will it be able to combine data from more than one cube & have
calculations performed on them?
Will there be any dynamic narratives (i.e. a way of storing comments
to dynamic data)?
Will it be web & windows based?
Can the data be presented in Excel & still be dynamic?
What are the main competitor tools? Crystal Reports/Analysis? Cognos
Impromtu/PowerPlay? ProClarity? Novaview?

Regards,

John

www.a-la-li-la.org



Reply With Quote
  #4  
Old   
Thomas Pagel
 
Posts: n/a

Default Re: Microsoft Reporting Services - 07-22-2003 , 04:27 AM



John,

from my point of view this is not what reporting services is made for. Still
there's a lot of "standard reporting" so useres want that stack of paper
with the company logo on the top. OK, they don't really want to have it on
papaer, but still that quite limited kind of more or less static reporting.

There is a need for "Analytical Applications" like ProClarity, Cognos... I'm
just curious about Microsoft's plans for Data Analysers V2...

Perhaps Reporting Services is not perfect for that kind of management
reporting you're looking for. Perhaps SharePoint with different WebParts
from Reporting Services & Excel/ProClarity would be the best solution. From
my experience Managers are looking for some kind of dashboard... SharePoint
is the right solution for that...


Thomas Pagel, Software4You Planungssysteme GmbH

"John Keeley" <duvinrouge (AT) servihoo (DOT) com> schrieb im Newsbeitrag
news:542fe31c.0307220056.597002c (AT) posting (DOT) google.com...
Quote:
Claudio,

Thanks, interesting reading.

My impression is it is Business Objects/Crystal Decisions & Cognos who
have a fight on their hands.

It is not going to be all that dynamic off of AS cubes. No ad-hoc
analysis.

So PowerPlay, Crystals Analysis, ProClarity, NovaView & the Excel
add-ins still have their market. Correct?

Are Microsoft still not fully appreciating that (management) reporting
is best done off of cubes, so that they are as dynamic as possible
(slicer dimensions, drill down/up, decomposition of numbers, dynamic
comments, ranking, writeback)?

I'm not getting that excited.
Please tell me if you have a different impression.

Regards,

John


"claudio" <claudio.lucio (AT) coresynesis (DOT) com.br> wrote

I think that this link is more appropriate for yours questions:


http://www.microsoft.com/technet/tre...L/sql0625.asp]


"John Keeley" <duvinrouge (AT) servihoo (DOT) com> wrote in message
news:542fe31c.0307210100.f075203 (AT) posting (DOT) google.com...
What is the scope of Microsoft Reporting Services?
Will it be a reporting tool that reads both relational &
multidimensional data?
Will it be able to combine data from more than one cube & have
calculations performed on them?
Will there be any dynamic narratives (i.e. a way of storing comments
to dynamic data)?
Will it be web & windows based?
Can the data be presented in Excel & still be dynamic?
What are the main competitor tools? Crystal Reports/Analysis? Cognos
Impromtu/PowerPlay? ProClarity? Novaview?

Regards,

John

www.a-la-li-la.org



Reply With Quote
  #5  
Old   
Nigel Pendse
 
Posts: n/a

Default Re: Microsoft Reporting Services - 07-22-2003 , 04:39 AM



John,

Reporting Services is a direct competitor to Crystal Reports, aimed at
production reporting. That is a valid, important requirement for many
organisations, even if it doesn't excite you.

But don't assume that this is Microsoft's only BI front-end plan -- they do
know the difference between interactive financial analysis and production
reporting, and are not promoting Reporting Services to be something that it
isn't (though of course, some outsiders might do just that). It's just that
Reporting Services is being released this year, so they are now talking
about it. They sensibly prefer not to talk about projects whose release is
further away, but that doesn't mean that they aren't investing in such
projects (18 months ago, Rosetta was also a big secret).

Nigel Pendse
OLAP Solutions
http://www.olapreport.com

"John Keeley" <duvinrouge (AT) servihoo (DOT) com> wrote

Quote:
Claudio,

Thanks, interesting reading.

My impression is it is Business Objects/Crystal Decisions & Cognos who
have a fight on their hands.

It is not going to be all that dynamic off of AS cubes. No ad-hoc
analysis.

So PowerPlay, Crystals Analysis, ProClarity, NovaView & the Excel
add-ins still have their market. Correct?

Are Microsoft still not fully appreciating that (management) reporting
is best done off of cubes, so that they are as dynamic as possible
(slicer dimensions, drill down/up, decomposition of numbers, dynamic
comments, ranking, writeback)?

I'm not getting that excited.
Please tell me if you have a different impression.

Regards,

John


"claudio" <claudio.lucio (AT) coresynesis (DOT) com.br> wrote

I think that this link is more appropriate for yours questions:


http://www.microsoft.com/technet/tre...L/sql0625.asp]


"John Keeley" <duvinrouge (AT) servihoo (DOT) com> wrote in message
news:542fe31c.0307210100.f075203 (AT) posting (DOT) google.com...
What is the scope of Microsoft Reporting Services?
Will it be a reporting tool that reads both relational &
multidimensional data?
Will it be able to combine data from more than one cube & have
calculations performed on them?
Will there be any dynamic narratives (i.e. a way of storing comments
to dynamic data)?
Will it be web & windows based?
Can the data be presented in Excel & still be dynamic?
What are the main competitor tools? Crystal Reports/Analysis? Cognos
Impromtu/PowerPlay? ProClarity? Novaview?

Regards,

John

www.a-la-li-la.org



Reply With Quote
  #6  
Old   
John Keeley
 
Posts: n/a

Default Re: Microsoft Reporting Services - 07-23-2003 , 03:33 AM



I now have a clearer picture as to what Reporting Services is all
about.
I hope that Microsoft are looking at the better Excel add-ins to see
just what they can do themselves.
I'll be publishing some functionality tables on Excel add-ins soon on
my website (www.a-la-li-la.org) which might be of some interest.


"Nigel Pendse" <nigelp.nospam (AT) compuserve (DOT) com> wrote

Quote:
John,

Reporting Services is a direct competitor to Crystal Reports, aimed at
production reporting. That is a valid, important requirement for many
organisations, even if it doesn't excite you.

But don't assume that this is Microsoft's only BI front-end plan -- they do
know the difference between interactive financial analysis and production
reporting, and are not promoting Reporting Services to be something that it
isn't (though of course, some outsiders might do just that). It's just that
Reporting Services is being released this year, so they are now talking
about it. They sensibly prefer not to talk about projects whose release is
further away, but that doesn't mean that they aren't investing in such
projects (18 months ago, Rosetta was also a big secret).

Nigel Pendse
OLAP Solutions
http://www.olapreport.com

"John Keeley" <duvinrouge (AT) servihoo (DOT) com> wrote in message
news:542fe31c.0307220056.597002c (AT) posting (DOT) google.com...
Claudio,

Thanks, interesting reading.

My impression is it is Business Objects/Crystal Decisions & Cognos who
have a fight on their hands.

It is not going to be all that dynamic off of AS cubes. No ad-hoc
analysis.

So PowerPlay, Crystals Analysis, ProClarity, NovaView & the Excel
add-ins still have their market. Correct?

Are Microsoft still not fully appreciating that (management) reporting
is best done off of cubes, so that they are as dynamic as possible
(slicer dimensions, drill down/up, decomposition of numbers, dynamic
comments, ranking, writeback)?

I'm not getting that excited.
Please tell me if you have a different impression.

Regards,

John


"claudio" <claudio.lucio (AT) coresynesis (DOT) com.br> wrote in message
news:<#myevk5TDHA.2280 (AT) TK2MSFTNGP10 (DOT) phx.gbl>...
I think that this link is more appropriate for yours questions:


http://www.microsoft.com/technet/tre...L/sql0625.asp]


"John Keeley" <duvinrouge (AT) servihoo (DOT) com> wrote in message
news:542fe31c.0307210100.f075203 (AT) posting (DOT) google.com...
What is the scope of Microsoft Reporting Services?
Will it be a reporting tool that reads both relational &
multidimensional data?
Will it be able to combine data from more than one cube & have
calculations performed on them?
Will there be any dynamic narratives (i.e. a way of storing comments
to dynamic data)?
Will it be web & windows based?
Can the data be presented in Excel & still be dynamic?
What are the main competitor tools? Crystal Reports/Analysis? Cognos
Impromtu/PowerPlay? ProClarity? Novaview?

Regards,

John

www.a-la-li-la.org

Reply With Quote
  #7  
Old   
claudio
 
Posts: n/a

Default Re: Microsoft Reporting Services - 07-24-2003 , 12:38 PM



I agree with you but there is a wrong. You consider only excel add-in with
the method for Ad-hoc Analysis. Please, Take a look at BI Portal, developed
in .net which use Office Web Components(MSDN example).
OK, I agree that Itīs not a thin client, then take a look at Japanese
Microsoft that have divulged about one Web Control for BI (totally made in
..Net) which pretend to implement all the capabilities (slicer, dimensions,
drill down/up,ranking, writeback and son on). I couldnīt do the download of
this tool
I didīt know about official position of Microsoft for this. But We should
wait something.

regards

"John Keeley" <duvinrouge (AT) servihoo (DOT) com> wrote

Quote:
I now have a clearer picture as to what Reporting Services is all
about.
I hope that Microsoft are looking at the better Excel add-ins to see
just what they can do themselves.
I'll be publishing some functionality tables on Excel add-ins soon on
my website (www.a-la-li-la.org) which might be of some interest.


"Nigel Pendse" <nigelp.nospam (AT) compuserve (DOT) com> wrote

John,

Reporting Services is a direct competitor to Crystal Reports, aimed at
production reporting. That is a valid, important requirement for many
organisations, even if it doesn't excite you.

But don't assume that this is Microsoft's only BI front-end plan -- they
do
know the difference between interactive financial analysis and
production
reporting, and are not promoting Reporting Services to be something that
it
isn't (though of course, some outsiders might do just that). It's just
that
Reporting Services is being released this year, so they are now talking
about it. They sensibly prefer not to talk about projects whose release
is
further away, but that doesn't mean that they aren't investing in such
projects (18 months ago, Rosetta was also a big secret).

Nigel Pendse
OLAP Solutions
http://www.olapreport.com

"John Keeley" <duvinrouge (AT) servihoo (DOT) com> wrote in message
news:542fe31c.0307220056.597002c (AT) posting (DOT) google.com...
Claudio,

Thanks, interesting reading.

My impression is it is Business Objects/Crystal Decisions & Cognos who
have a fight on their hands.

It is not going to be all that dynamic off of AS cubes. No ad-hoc
analysis.

So PowerPlay, Crystals Analysis, ProClarity, NovaView & the Excel
add-ins still have their market. Correct?

Are Microsoft still not fully appreciating that (management) reporting
is best done off of cubes, so that they are as dynamic as possible
(slicer dimensions, drill down/up, decomposition of numbers, dynamic
comments, ranking, writeback)?

I'm not getting that excited.
Please tell me if you have a different impression.

Regards,

John


"claudio" <claudio.lucio (AT) coresynesis (DOT) com.br> wrote in message
news:<#myevk5TDHA.2280 (AT) TK2MSFTNGP10 (DOT) phx.gbl>...
I think that this link is more appropriate for yours questions:



http://www.microsoft.com/technet/tre...L/sql0625.asp]


"John Keeley" <duvinrouge (AT) servihoo (DOT) com> wrote in message
news:542fe31c.0307210100.f075203 (AT) posting (DOT) google.com...
What is the scope of Microsoft Reporting Services?
Will it be a reporting tool that reads both relational &
multidimensional data?
Will it be able to combine data from more than one cube & have
calculations performed on them?
Will there be any dynamic narratives (i.e. a way of storing
comments
to dynamic data)?
Will it be web & windows based?
Can the data be presented in Excel & still be dynamic?
What are the main competitor tools? Crystal Reports/Analysis?
Cognos
Impromtu/PowerPlay? ProClarity? Novaview?

Regards,

John

www.a-la-li-la.org



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.