dbTalk Databases Forums  

looking for a webpart or webcontrol to display 2005 KPI?

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.olap looking for a webpart or webcontrol to display 2005 KPI?

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


Discuss looking for a webpart or webcontrol to display 2005 KPI? in the microsoft.public.sqlserver.olap forum.



Reply
Page 1 of 2 1 2 >
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default looking for a webpart or webcontrol to display 2005 KPI? - 11-16-2005 , 08:09 PM





Hi,

I'm looking for a wbepart or a webcontrol which render AS2005 KPIs
any link? or guide?

I don't want to create my own control.

thanks.

Jerome.



Reply With Quote
  #2  
Old   
Deepak Puri
 
Posts: n/a

Default Re: looking for a webpart or webcontrol to display 2005 KPI? - 11-17-2005 , 12:59 AM





How about Business Scorecard Manager 2005 - you can directly use the KPI
defined in SQL Server 2005, or customize it further, and it provides
various Web Parts.

http://www.ipma-wa.com/prodev/2005/dashboard_bsm.ppt


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote
  #3  
Old   
Jéjé
 
Posts: n/a

Default Re: looking for a webpart or webcontrol to display 2005 KPI? - 11-17-2005 , 06:06 PM


but if I don't want to use the scorecard tool, what are my other options?


"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

Quote:
How about Business Scorecard Manager 2005 - you can directly use the KPI
defined in SQL Server 2005, or customize it further, and it provides
various Web Parts.

http://www.ipma-wa.com/prodev/2005/dashboard_bsm.ppt


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***



Reply With Quote
  #4  
Old   
Deepak Puri
 
Posts: n/a

Default Re: looking for a webpart or webcontrol to display 2005 KPI? - 11-17-2005 , 08:06 PM


SQL Server Report Builder also supports AS 2005 KPI's, as apparently
does Proclarity 6.1 beta. I've think seen a demo of incorporating a KPI
into RS 2005 Report Designer, but with "some assembly required".

http://www.sqljunkies.com/WebLog/sqlbi/default.aspx
Quote:
...
Thanks to Brian Welcker, to display KPI and calculated measures into a
Report Model it's necessary to associate each KPI and calculated member
to a specific measure group; I didn't (and it's the default, guys!) so I
could see them into the browser of SQL Management Studio but not into
the Report Model. Once I defined this association, Report Builder allow
me to use calculated measures and KPIs, including graphics.
...
Quote:
http://www.proclarity.com/files/prod...ellowstone.pdf
Quote:
...
SQL Server 2005-style KPIs
...
Quote:

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***


Reply With Quote
  #5  
Old   
Jéjé
 
Posts: n/a

Default Re: looking for a webpart or webcontrol to display 2005 KPI? - 11-17-2005 , 11:11 PM


thanks for the link.

I know that Proclarity support a lot of AS capabilities, but the price is
high.

regarding the option to generate a model from a data source, I have some
missing attributes in the model.
For example, I have the First name & last name attributes of my customer
dimension set to "NotOptimized" and these attributes doesn't appears in the
model!
any idea why?


"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

Quote:
SQL Server Report Builder also supports AS 2005 KPI's, as apparently
does Proclarity 6.1 beta. I've think seen a demo of incorporating a KPI
into RS 2005 Report Designer, but with "some assembly required".

http://www.sqljunkies.com/WebLog/sqlbi/default.aspx

..
Thanks to Brian Welcker, to display KPI and calculated measures into a
Report Model it's necessary to associate each KPI and calculated member
to a specific measure group; I didn't (and it's the default, guys!) so I
could see them into the browser of SQL Management Studio but not into
the Report Model. Once I defined this association, Report Builder allow
me to use calculated measures and KPIs, including graphics.
..


http://www.proclarity.com/files/prod...ellowstone.pdf

..
SQL Server 2005-style KPIs
..



- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***



Reply With Quote
  #6  
Old   
Deepak Puri
 
Posts: n/a

Default Re: looking for a webpart or webcontrol to display 2005 KPI? - 11-18-2005 , 10:33 AM


Unfortunately, I haven't worked much with Report Builder; but it would
be worthwhile to pose this question in the Reporting Services Newsgroup,
which is very active, if you don't get an answer here.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

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

Default Re: looking for a webpart or webcontrol to display 2005 KPI? - 11-20-2005 , 12:10 AM


Jerome,
How would you want the KPIs displayed?

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

Quote:
Hi,

I'm looking for a wbepart or a webcontrol which render AS2005 KPIs
any link? or guide?

I don't want to create my own control.

thanks.

Jerome.



Reply With Quote
  #8  
Old   
Jéjé
 
Posts: n/a

Default Re: looking for a webpart or webcontrol to display 2005 KPI? - 11-20-2005 , 07:11 AM


I want a simple list of all the KPIs or KPIs under a specific folder.
the dimensions be defined with "static" member and the user can't change.
(for the moment)

"ChrisHarrington" <charrington-at-activeinterface.com> wrote

Quote:
Jerome,
How would you want the KPIs displayed?

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote in message
news:%23Djhpvx6FHA.252 (AT) TK2MSFTNGP15 (DOT) phx.gbl...
Hi,

I'm looking for a wbepart or a webcontrol which render AS2005 KPIs
any link? or guide?

I don't want to create my own control.

thanks.

Jerome.



Reply With Quote
  #9  
Old   
ChrisHarrington
 
Posts: n/a

Default Re: looking for a webpart or webcontrol to display 2005 KPI? - 11-22-2005 , 12:01 AM


See http://msdn2.microsoft.com/en-us/library/ms126258.aspx
The MDSCHEMA_KPIS Rowset gives you the list of KPIs. As you can see on this
page, you can restrict by CATALOG_NAME, SCHEMA_NAME, CUBE_NAME, KPI_NAME,
and CUBE_SOURCE. An example XMLA query would be:
<?xml version="1.0" ?>
<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<Body>
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>MDSCHEMA_KPIS</RequestType>
<Restrictions>
<RestrictionList>
<CATALOG_NAME>Adventure Works DW</CATALOG_NAME>
<CUBE_NAME>Adventure Works</CUBE_NAME>
<KPI_NAME>Product Gross Profit Margin</KPI_NAME>
</RestrictionList>
</Restrictions>
<Properties>
<PropertyList>
<Catalog>Adventure Works DW</Catalog>
<DataSourceInfo>Local Analysis Server</DataSourceInfo>
</PropertyList>
</Properties>
</Discover>
</Body>
</Envelope>

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

Quote:
I want a simple list of all the KPIs or KPIs under a specific folder.
the dimensions be defined with "static" member and the user can't change.
(for the moment)

"ChrisHarrington" <charrington-at-activeinterface.com> wrote in message
news:ell7ZkZ7FHA.1416 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Jerome,
How would you want the KPIs displayed?

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote in message
news:%23Djhpvx6FHA.252 (AT) TK2MSFTNGP15 (DOT) phx.gbl...
Hi,

I'm looking for a wbepart or a webcontrol which render AS2005 KPIs
any link? or guide?

I don't want to create my own control.

thanks.

Jerome.



Reply With Quote
  #10  
Old   
Vladimir Chtepa
 
Posts: n/a

Default Re: looking for a webpart or webcontrol to display 2005 KPI? - 11-23-2005 , 07:51 AM


Does Report builder support not only relational data view?

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> schrieb im Newsbeitrag
news:%23%23He6S%236FHA.1416 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Quote:
SQL Server Report Builder also supports AS 2005 KPI's, as apparently
does Proclarity 6.1 beta. I've think seen a demo of incorporating a KPI
into RS 2005 Report Designer, but with "some assembly required".

http://www.sqljunkies.com/WebLog/sqlbi/default.aspx

..
Thanks to Brian Welcker, to display KPI and calculated measures into a
Report Model it's necessary to associate each KPI and calculated member
to a specific measure group; I didn't (and it's the default, guys!) so I
could see them into the browser of SQL Management Studio but not into
the Report Model. Once I defined this association, Report Builder allow
me to use calculated measures and KPIs, including graphics.
..


http://www.proclarity.com/files/prod...ellowstone.pdf

..
SQL Server 2005-style KPIs
..



- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***



Reply With Quote
Reply
Page 1 of 2 1 2 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

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.


Contact Us - dbTalk Databases Forums - Archive - Top