Re: Business Scorecard Accelerator

#1

[forwarding to OLAP newsgroup]

"Samuel Mugabe" <mugabes (AT) mtn (DOT) co.ug> wrote

Quote:

Hello ,

I have created a scorecard and want to map it to the analysis cubes.

The scorecard has 2 Perspectives whose KPIs are to get their values
from 2 different cubes in analysis services.

The problem is when I go to map the scorecard to the views, I can only
select one cube and use its measures yet my KPIs are to rely on 2
diferent cubes.

How do I do this?

Thanks,
Sam.

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

#2

To my knowledge, MS Business Scorecards requires all the data to be in
one cube. However this can be a virtual cube.
If you are using Shared Dimensions, you can create a virtual cube
which is a union of the two base cubes, and then link your Scorecard to
the virtual cube.
It is probably a good idea to consider use of a virtual cube anyway
for your Scorecard, even if you are basing the Scorecard on a single
base cube.

Raman Iyer [MS] wrote:

Quote:

[forwarding to OLAP newsgroup]

"Samuel Mugabe" <mugabes (AT) mtn (DOT) co.ug> wrote in message
news:%23xf5S42vFHA.2312 (AT) TK2MSFTNGP14 (DOT) phx.gbl...

Hello ,

I have created a scorecard and want to map it to the analysis cubes.

The scorecard has 2 Perspectives whose KPIs are to get their values
from 2 different cubes in analysis services.

The problem is when I go to map the scorecard to the views, I can only
select one cube and use its measures yet my KPIs are to rely on 2
diferent cubes.

How do I do this?

Thanks,
Sam.

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Business Scorecard Accelerator

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

Re: Business Scorecard Accelerator - 09-22-2005 , 07:28 PM

Re: Business Scorecard Accelerator - 09-24-2005 , 03:06 PM