Difference between Scorecard Manager and Proclarity Dashboard

Hello,

I would like to know what is the difference between Proclarity Dashboard Server and Business Scorecard Manager. I tried to search on the internet but couldn't find any. I know that both are Microsoft products. Suppose i have proclarity desktop professional installed, which tool is better to use as interface for users? Could anyone tell me what are the features that distinguish each so that i would know which is more suitable for my requirements?

Thanks in advance

Christina

Hello. Business Scorecard Manager (BSM)is the choice if you woud like to build balanced scorecards.

ProClarity Professional cannot publish reports to BSM but only to Sharepoint, ProClarity Analytics server and ProClarity Dashboard server.

However, this will change in a new product about to be released, called Performance Point.

Both ProClarity and BSM will be integrated into this product.

HTH

Thomas Ivarsson

|||

Thanks for your reply.

Could you please clarify what you mean by balanced scorecards?Doesn't Proclarity dashboard provide balanced scorecard?

Another question please:

The proclarity dashboard uses the views from the PAS to integrate it in the dashboard.

The BSM, how does it construct its views? does it use the office tools or it has is own view designer?

Thanks

Christina

|||

Hello! With BSM you can create measure or KPI hierarchies with parent KPI giving different weight to child measures or KPI . There is no way that you can do that in Proclarity professional. You can build KPI in the KPI-builder or present KPI that are built in Analysis Services 2005, but they will always be presented flat, not in a KPI hierarchy.

Balanced Scorecard is a large topic to discuss here but if you search on that word or 'Northon Kaplan' you will find more information.

A Dashboard is not by itself a Balanced Scorecard, like you will find out when you read about the theory.

I think that BSM mostly use Office webcomponents for views.

Regards

Thomas Ivarsson

|||

Hi, Christina,

If you have Business ScoredCard Manager 2005 installed, try it and you will see from the scoredcard point of view that you can get more out of it compared what you can get from ProClarity Dashboard.

Basically, ProClarity dashbord intergrate 4 types of views: ProClarity analytics view, KPI view which you can either create from dashboard studio or ProClarity professional or Analysis Services, Web page view, and finally Note view which you can post your comments.

While with Business ScoredCard Manager 2005, you can better manage your scoreds into objectives etc. And importantly, you can build your scoredcards with data coming from both of relational database source and multi-dimensional data source. And you can publish your business scorecard views into SharePoint site or SQL Server 2005 Reporting Services. Also, you can add reports views together with your ScoreCard views to let users have a more information.

Significantly, it is very excited that with the seamless integration between ProClairty and Business Scorecard Manager 2005, you can integrate business scorecard views with ProClarity analytic views, thus you can jump from Business ScoredCard view to ProClarity Analytic client to drill down to analyse more behind your scorecard views.

Also, as Thomas kindly advised, Performance Point will be an excited release to see more out of it.

Hope it helps.

Kind Regards,

Yours sincerely,

|||

Thank you Thomas and Helen for your replies.

I looked for Balanced Scorecard on the net and got your point about it. I just need to install the trial version of BSM to try it.

I am now interested in knowing about the Performance Point. Do you know when it will be released? I am not very satisfied with the performance of Proclarity Dashboard and want to study the possibility of moving to BSM with the Performance point.

Thanks for your help

Regards,

Christina

|||

Hello Christina!

Performance Point will be released between september and november this year.

It is possible to try the beta version here: http://www.connect.microsoft.com/

HTH

Thomas Ivarsson

|||

Thank you Thomas for your help

Regards,

Christina

Difference between .rdl and .rdlc files

What is the difference between reports created using Business Intelligence Projects Template and the reports created using .rdlc file which is present in the various file types displayed. Why SSRS needs to be installed when you can create reports using .rdlc file.

The way I understand it, .rdl is a server controlled report and .rdlc is a client-side controlled report. You have to deploy an .rdl file to a report server and access it using that server. With a .rdlc report, you can create the report and use a ReportViewer control to run the report in your application.

|||

RDL files are created by the SQL Server 2005 version of Report Designer. RDLC files are created by the Visual Studio 2005 version of Report Designer.

RDL and RDLC formats have the same XML schema. However, in RDLC files, some values (such as query text) are allowed to be empty, which means that they are not immediately ready to be published to a Report Server. The missing values can be entered by opening the RDLC file using the SQL Server 2005 version of Report Designer. (You have to rename .rdlc to .rdl first.)

RDL files are fully compatible with the ReportViewer control runtime. However, RDL files do not contain some information that the design-time of the ReportViewer control depends on for automatically generating data-binding code. Bymanually binding data, RDL files can be used in the ReportViewer control.

Note that the ReportViewer control does not contain any logic for connecting to databases or executing queries. By separating out such logic, the ReportViewer has been made compatible with all data sources, including non-database data sources. However this means that when an RDL file is used by the ReportViewer control, the SQL related information in the RDL file is simply ignored by the control. It is the host application's responsibility to connect to databases, execute queries and supply data to the ReportViewer control in the form of ADO.NET DataTables.

|||

Thanks Tamer Fathy. But I have certain doubts. I can build reports using the .rdlc files provided by VS 2005. The data could be fetched from any database.To display the report, we have got the reportviewer. The reports as far as I understand will be hosted on the application server not on Report Server as in case of
SSRS 2005. So what are the additional advantages of SSRS 2005 and what are the components that I should install to receive the benefits? I have got sql server 2000 as my backend.

Thanks in advance

|||

you don't need reporting service as you use rdlc read this areticle and see the samples

http://www.gotreportviewer.com/

|||

Thanks Tamer Fathy. But I did not understand the following abstract from the article you asked me to go through.

Q: Why doesn't the ReportViewer control support parameter prompting in local mode?

A: The ReportViewer control does not prompt for parameters when in local mode. It prompts for parameters when it is connected to a Report Server.

In local mode it does not make sense for ReportViewer to prompt for parameters. The rationale is as follows: The most common use of report parameters is to pass to queries as values of query parameters. But unlike the Report Server, the ReportViewer control does not execute queries itself. Rather, queries are executed by the host application, and the result is passed to the ReportViewer control. So the ReportViewer control does not have the opportunity to set query parameters. Applications should take advantage of the parameterization features of Visual Studio data wizards instead.

|||

You welcome any time :),

concerning your question it was easy, this is the difference between the RDL and RDLC in case you need to pass parameters to your reports if you use RDLC which in client side processing as get the data from the database and assign it to the report you need to handle the passing of the parameters by developing the form which get the parameters from the user and then use it in your query then when you get the results you pass it to the report to display.

but if you use server side processing you can use the report viewer control (custom control used to view reports in your application (web or windows)) to handle the parameti hope i explain it in good way and i help you

|||

Thanks Tamer Fathy. But I have one more doubt. Making use of .rdlc file type and the reportviewer provided by VS2005 instead of SSRS 2005 would mean that the reports will be on the application server rather than being hosted on the reportserver since I won't be having a seprate report server. Will this affect the performance of my application server?

Thanks in advance.

|||

no this will not affect your application performance as it wil be as you query the data base for specific data

Diagram of the SP relations

All,
Is it possible to get something like a diagram of the SP relations? I'm
working with one DB and the business logic is done so that the SP can
execute another SP inside itself, the next SP can call another one, etc. So
that we can get 3-4 different sub-layers inside one SP. If I need to make
one simple change to any SP, for example to add a new parameter, I get so
huge pleasure that it's really hard to make everything right. I need to add
these parameter correctly to all SPs, plus correct the app source code. If I
could keep some automatically generated schema with all these relations on
my desk it would be much easier to break through this crazy logic. Please
help who knows how to simplify that. Don't tell me that this approach is
stupid, I know that. :( To change anything means to redo the whole DB,
that's not acceptable now, the app is in production.
Just D.Well, you could use the dependency table but that is
often inaccurate. This isn't a dead on solution but
may provide you with a good start.
It analyzes the text of the stored procedure and orders
all of them by order of "real" dependency.
http://www.eggheadcafe.com/articles/20030609.asp
Robbe Morris - 2004-2006 Microsoft MVP C#
Earn money answering .NET questions
http://www.eggheadcafe.com/forums/merit.asp
"Just D" <no@.spam.please> wrote in message
news:wTWog.8849$Nv.6431@.fed1read10...
> All,
> Is it possible to get something like a diagram of the SP relations? I'm
> working with one DB and the business logic is done so that the SP can
> execute another SP inside itself, the next SP can call another one, etc.
> So that we can get 3-4 different sub-layers inside one SP. If I need to
> make one simple change to any SP, for example to add a new parameter, I
> get so huge pleasure that it's really hard to make everything right. I
> need to add these parameter correctly to all SPs, plus correct the app
> source code. If I could keep some automatically generated schema with all
> these relations on my desk it would be much easier to break through this
> crazy logic. Please help who knows how to simplify that. Don't tell me
> that this approach is stupid, I know that. :( To change anything means to
> redo the whole DB, that's not acceptable now, the app is in production.
> Just D.
>|||Just D wrote:
> All,
> Is it possible to get something like a diagram of the SP relations? I'm
> working with one DB and the business logic is done so that the SP can
> execute another SP inside itself, the next SP can call another one, etc. S
o
> that we can get 3-4 different sub-layers inside one SP. If I need to make
> one simple change to any SP, for example to add a new parameter, I get so
> huge pleasure that it's really hard to make everything right. I need to ad
d
> these parameter correctly to all SPs, plus correct the app source code. If
I
> could keep some automatically generated schema with all these relations on
> my desk it would be much easier to break through this crazy logic. Please
> help who knows how to simplify that. Don't tell me that this approach is
> stupid, I know that. :( To change anything means to redo the whole DB,
> that's not acceptable now, the app is in production.
> Just D.
>
This is stupid, you should redo the whole DB... ;-)
Seriously though, you can search the syscomments table to figure out
which sproc reference the one you're changing. Not the perfect
solution, but it should help you find all the things you need to change
when adding a parameter...

Devloper Edition on Vista

Hello all,
Quick question. I know that SQL Developer Edition works on XP sp2. Anyone
know if SQL Developer Edition will work on Vista Business. I'm ordering a
new notebook and don't want to have to remove the OS if I don't have to.
Thanks
JohnI'm running Dev Ed on Vista (Ultimate), no real problems. SQL Books Online lists what OS are
supported for each SQL Edition, and Vista with Business should be fine. Just install SQL 2005 sp2
after initial install, so you are supported (etc).
You are in for some work if you want to install RS. Basically, you need to make Vista "present " IIS
6. It was a while since I did this, but with some help from Google etc it wasn't that tough.
I should add that I disabled UAC. I ran it for a couple of days, but it annoyed me too much. I don't
think it caused any particular SQL Server problems, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"John Holt" <johnh@.regionv.k12.mn.us> wrote in message
news:DED2615C-7B03-489F-A288-A5350FA2F6F4@.microsoft.com...
> Hello all,
> Quick question. I know that SQL Developer Edition works on XP sp2. Anyone know if SQL Developer
> Edition will work on Vista Business. I'm ordering a new notebook and don't want to have to remove
> the OS if I don't have to.
> Thanks
> John|||I agree with Tibor. I've been using SQL Server 2005 DE since Vista Business
released and no problem at all.
Regarding to IIS, IIS is not being fully installed by default so you need to
add some components to its installation so that you'll be able to use it for
your RS or anything else.
You may want to check out the following link to learn about exactly what
components of IIS should be installed to make RS checkbox enabled when in
SQL Server Setup.
http://support.microsoft.com/default.aspx/kb/934164
--
Ekrem Önsoy
"John Holt" <johnh@.regionv.k12.mn.us> wrote in message
news:DED2615C-7B03-489F-A288-A5350FA2F6F4@.microsoft.com...
> Hello all,
> Quick question. I know that SQL Developer Edition works on XP sp2.
> Anyone know if SQL Developer Edition will work on Vista Business. I'm
> ordering a new notebook and don't want to have to remove the OS if I don't
> have to.
> Thanks
> John|||Thanks for your input guys. I really appreciate it. Vista it is.:-)
John
"John Holt" <johnh@.regionv.k12.mn.us> wrote in message
news:DED2615C-7B03-489F-A288-A5350FA2F6F4@.microsoft.com...
> Hello all,
> Quick question. I know that SQL Developer Edition works on XP sp2.
> Anyone know if SQL Developer Edition will work on Vista Business. I'm
> ordering a new notebook and don't want to have to remove the OS if I don't
> have to.
> Thanks
> John|||"John Holt" wrote:
> Thanks for your input guys. I really appreciate it. Vista it is.:-)
> John
> "John Holt" <johnh@.regionv.k12.mn.us> wrote in message
> news:DED2615C-7B03-489F-A288-A5350FA2F6F4@.microsoft.com...
> > Hello all,
> > Quick question. I know that SQL Developer Edition works on XP sp2.
> > Anyone know if SQL Developer Edition will work on Vista Business. I'm
> > ordering a new notebook and don't want to have to remove the OS if I don't
> > have to.
> >
> > Thanks
> > John
>
I'm having problem installing SQL Reporting Server on Vista Business without
success. Microsoft Vista said 1% incompatiability problem. It is a real
nightmare!

Developer Edition & Windows Server 2003 Small Business Server

I have Small Business Server 2003 and am teaching myself VB.Net. I purchased
the package Visual Basic Step By Step and put it on the server hoping to ac
cess the SQL Server on the server PC. But VB Step by Step won't recognize th
e SQL Server that came with
Small Business Server 2003. If I purchased the Developer's Edition of SQL Se
rver, could I put it on my server or would I have to move VB to my desktop P
C, put SQL Server DE on the desktop machine and work from there?
SteveC"jn316sc" <jn316sc@.discussions.microsoft.com> wrote in message
news:6750BF87-F6EE-4134-A50D-AE9CD88D6F26@.microsoft.com...
> I have Small Business Server 2003 and am teaching myself VB.Net. I
purchased the package Visual Basic Step By Step and put it on the server
hoping to access the SQL Server on the server PC. But VB Step by Step won't
recognize the SQL Server that came with Small Business Server 2003. If I
purchased the Developer's Edition of SQL Server, could I put it on my server
or would I have to move VB to my desktop PC, put SQL Server DE on the
desktop machine and work from there?
> SteveC
VB.NET can see your SBS SQL Server on the local machine as well as across
the network. How are you trying to access the SQL Server? My initial guess
is that you are probably having a security issue.
Try opening a new windows application.
Open the Form
Drag & Drop a SQLConnection Object and follow the wizard.
While in the wizard, use the Trusted Connection option.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Developer Edition & Windows Server 2003 Small Business Server

I have Small Business Server 2003 and am teaching myself VB.Net. I purchased the package Visual Basic Step By Step and put it on the server hoping to access the SQL Server on the server PC. But VB Step by Step won't recognize the SQL Server that came with
Small Business Server 2003. If I purchased the Developer's Edition of SQL Server, could I put it on my server or would I have to move VB to my desktop PC, put SQL Server DE on the desktop machine and work from there?
SteveC
"jn316sc" <jn316sc@.discussions.microsoft.com> wrote in message
news:6750BF87-F6EE-4134-A50D-AE9CD88D6F26@.microsoft.com...
> I have Small Business Server 2003 and am teaching myself VB.Net. I
purchased the package Visual Basic Step By Step and put it on the server
hoping to access the SQL Server on the server PC. But VB Step by Step won't
recognize the SQL Server that came with Small Business Server 2003. If I
purchased the Developer's Edition of SQL Server, could I put it on my server
or would I have to move VB to my desktop PC, put SQL Server DE on the
desktop machine and work from there?
> SteveC
VB.NET can see your SBS SQL Server on the local machine as well as across
the network. How are you trying to access the SQL Server? My initial guess
is that you are probably having a security issue.
Try opening a new windows application.
Open the Form
Drag & Drop a SQLConnection Object and follow the wizard.
While in the wizard, use the Trusted Connection option.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Developer Edition & Windows Server 2003 Small Business Server

I have Small Business Server 2003 and am teaching myself VB.Net. I purchased the package Visual Basic Step By Step and put it on the server hoping to access the SQL Server on the server PC. But VB Step by Step won't recognize the SQL Server that came with Small Business Server 2003. If I purchased the Developer's Edition of SQL Server, could I put it on my server or would I have to move VB to my desktop PC, put SQL Server DE on the desktop machine and work from there?
SteveC"jn316sc" <jn316sc@.discussions.microsoft.com> wrote in message
news:6750BF87-F6EE-4134-A50D-AE9CD88D6F26@.microsoft.com...
> I have Small Business Server 2003 and am teaching myself VB.Net. I
purchased the package Visual Basic Step By Step and put it on the server
hoping to access the SQL Server on the server PC. But VB Step by Step won't
recognize the SQL Server that came with Small Business Server 2003. If I
purchased the Developer's Edition of SQL Server, could I put it on my server
or would I have to move VB to my desktop PC, put SQL Server DE on the
desktop machine and work from there?
> SteveC
VB.NET can see your SBS SQL Server on the local machine as well as across
the network. How are you trying to access the SQL Server? My initial guess
is that you are probably having a security issue.
Try opening a new windows application.
Open the Form
Drag & Drop a SQLConnection Object and follow the wizard.
While in the wizard, use the Trusted Connection option.
HTH
Rick Sawtell
MCT, MCSD, MCDBA