dbTalk Databases Forums  

Individual KPI status indicator symbols / RDBMS and MS AS in MS RS

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


Discuss Individual KPI status indicator symbols / RDBMS and MS AS in MS RS in the microsoft.public.sqlserver.olap forum.



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

Default Individual KPI status indicator symbols / RDBMS and MS AS in MS RS - 10-16-2006 , 04:44 AM






Hi Everyone,

I have got the following challenge: we have a detailed relational data base
with Key Performance Indicator information. On top of that we are using a MS
2005 cube to calculate roll ups and do analysis. In the RDBMS we also store
status indicator pictures (binary).

Despite trying different options we so far havent found a way to show a
combination of the analysis services data and the status indicator pictures
in one report.

We would really appreciate ideas and suggestions how to make this happen?

E.g.

*A way to use individual status indicator pictures in MS AS?
*Combine the cube data and the status information indicator picture from the
RDBMS in one Reporting Services report.?
*Other options how to combine the two sources e.g. Excel?

Thank you very much for your help upfront!

cu

Chris

PS: using BSM 2005 is not an option.


Reply With Quote
  #2  
Old   
Marco
 
Posts: n/a

Default Re: Individual KPI status indicator symbols / RDBMS and MS AS in MS RS - 10-16-2006 , 09:07 AM






Hi,

You should use a HTML server/client where you can show images based on
KPIs.

We have great experience with ReportPortal whoing this in an OLAP
Report, KPI Report or even the new KPI 2005 report.

You can download afree 60 days trial from www.gmsbv.nl

Regards, Marco



Chris schreef:

Quote:
Hi Everyone,

I have got the following challenge: we have a detailed relational data base
with Key Performance Indicator information. On top of that we are using a MS
2005 cube to calculate roll ups and do analysis. In the RDBMS we also store
status indicator pictures (binary).

Despite trying different options we so far havent found a way to show a
combination of the analysis services data and the status indicator pictures
in one report.

We would really appreciate ideas and suggestions how to make this happen?

E.g.

*A way to use individual status indicator pictures in MS AS?
*Combine the cube data and the status information indicator picture from the
RDBMS in one Reporting Services report.?
*Other options how to combine the two sources e.g. Excel?

Thank you very much for your help upfront!

cu

Chris

PS: using BSM 2005 is not an option.


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.