|
Home > Archive > MS SQL Server OLAP > November 2005 > looking for a webpart or webcontrol to display 2005 KPI?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
looking for a webpart or webcontrol to display 2005 KPI?
|
|
|
| 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.
| |
|
|
|
| but if I don't want to use the scorecard tool, what are my other options?
"Deepak Puri" < deepak_puri@progress
ive.com> wrote in message
news:%23PGUCS06FHA.472@TK2MSFTNGP15.phx.gbl...
> 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.droptable.com ***
| |
| Deepak Puri 2005-11-17, 8:24 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[color=darkred]
...
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.
...[color=darkred]
http://www.proclarity.com/files/pro...yellowstone.pdf[color=darkred]
...
SQL Server 2005-style KPIs
...[color=darkred]
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.droptable.com ***
| |
|
| 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@progress
ive.com> wrote in message
news:%23%23He6S%236F
HA.1416@TK2MSFTNGP09.phx.gbl...
> 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/pro...yellowstone.pdf
> ..
> SQL Server 2005-style KPIs
> ..
>
>
> - Deepak
>
> Deepak Puri
> Microsoft MVP - SQL Server
>
> *** Sent via Developersdex http://www.droptable.com ***
| |
| Deepak Puri 2005-11-18, 11:24 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.droptable.com ***
| |
| ChrisHarrington 2005-11-20, 3:23 am |
| Jerome,
How would you want the KPIs displayed?
"Jéjé" < willgart@BBBhotmailA
AA.com> wrote in message
news:%23Djhpvx6FHA.252@TK2MSFTNGP15.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.
>
>
| |
|
| 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@TK2MSFTNGP09.phx.gbl...
> Jerome,
> How would you want the KPIs displayed?
>
> "Jéjé" < willgart@BBBhotmailA
AA.com> wrote in message
> news:%23Djhpvx6FHA.252@TK2MSFTNGP15.phx.gbl...
>
>
| |
| ChrisHarrington 2005-11-22, 3:24 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@BBBhotmailA
AA.com> wrote in message
news:O9C67Pd7FHA.2152@TK2MSFTNGP10.phx.gbl...
>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@TK2MSFTNGP09.phx.gbl...
>
>
| |
| Vladimir Chtepa 2005-11-23, 9:24 am |
| Does Report builder support not only relational data view?
"Deepak Puri" < deepak_puri@progress
ive.com> schrieb im Newsbeitrag
news:%23%23He6S%236F
HA.1416@TK2MSFTNGP09.phx.gbl...
> 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/pro...yellowstone.pdf
> ..
> SQL Server 2005-style KPIs
> ..
>
>
> - Deepak
>
> Deepak Puri
> Microsoft MVP - SQL Server
>
> *** Sent via Developersdex http://www.droptable.com ***
| |
| Deepak Puri 2005-11-23, 8:24 pm |
| An AS 2005 UDM (cube) can be used to generate a Report Builder model,
from which users can create ad-hoc reports. But there are some issues in
mapping UDM to such a model (see Chris Webb's blog entry below) - it's
the first cut:
http://spaces.msn.com/members/cwebb...w.droptable.com ***
|
|
|
|
|