![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
Can somebody please share with me the structure of the BSM or the scorecard accelerator cube and the underlying database table structure for the fact table. If possible can somebody kindly email the dump of the scorecard cube and the fact table script to this email address: karenmiddleol (AT) yahoo (DOT) com Also can you please email me the KPIs in the Scorecard cube My install somehow is not working I cannot even browse the cube. Thanks Karen |
#3
| |||
| |||
|
|
the business scorecard manager 2005 tool is completly different from the scorecard accelerator tool. with BSCM you can connect a KPI value to "any" type of data (MDX query, SQL query , Excel file...) each KPI can use a different source. So there is no recommandation for how to setup your cubes. You just have to be carrefull for the dimensions you want to use for deeper analysis in the scorecard (a product dimension from 2 different sources should have the same design to allow you to filter the 2 sources with only 1 dimension) using the scorecard accelerator 1 scorecard is linked to 1 cube, the recommanded structure is describe in the documentation of the tool. "KarenM" <karenmiddleol (AT) yahoo (DOT) com> wrote in message news:1147807509.336956.27930 (AT) j55g2000cwa (DOT) googlegroups.com... Can somebody please share with me the structure of the BSM or the scorecard accelerator cube and the underlying database table structure for the fact table. If possible can somebody kindly email the dump of the scorecard cube and the fact table script to this email address: karenmiddleol (AT) yahoo (DOT) com Also can you please email me the KPIs in the Scorecard cube My install somehow is not working I cannot even browse the cube. Thanks Karen |
#4
| |||
| |||
|
|
Many thanks Jeje Is there some good documentation on the BSC Accelerator or the BSM Manager. Thanks Karen Jeje wrote: the business scorecard manager 2005 tool is completly different from the scorecard accelerator tool. with BSCM you can connect a KPI value to "any" type of data (MDX query, SQL query , Excel file...) each KPI can use a different source. So there is no recommandation for how to setup your cubes. You just have to be carrefull for the dimensions you want to use for deeper analysis in the scorecard (a product dimension from 2 different sources should have the same design to allow you to filter the 2 sources with only 1 dimension) using the scorecard accelerator 1 scorecard is linked to 1 cube, the recommanded structure is describe in the documentation of the tool. "KarenM" <karenmiddleol (AT) yahoo (DOT) com> wrote in message news:1147807509.336956.27930 (AT) j55g2000cwa (DOT) googlegroups.com... Can somebody please share with me the structure of the BSM or the scorecard accelerator cube and the underlying database table structure for the fact table. If possible can somebody kindly email the dump of the scorecard cube and the fact table script to this email address: karenmiddleol (AT) yahoo (DOT) com Also can you please email me the KPIs in the Scorecard cube My install somehow is not working I cannot even browse the cube. Thanks Karen |
![]() |
| Thread Tools | |
| Display Modes | |
| |