Set up a fact table for these goals and then create a measure group in
the cube. You can then use a measure as the goal.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <A470BBC2-3F77-4637-9EB0-1AA0F9136F5C (AT) microsoft (DOT) com>,
AndrMattos (AT) discussions (DOT) microsoft.com says...

The MDX expression for the KPI Goal could be like:

when [Region].[Region].CurrentMember
is [Region].[North America]
then 1000
when [Region].[Region].CurrentMember
is [Region].[South America]
then 500
when [Region].[Region].CurrentMember
is [Region].[Europe]
then 800
else 200 end

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Hi Mattos,

Could you describe the problem - what is your test, and are you seeing
an error or the wrong value? To facilitate trouble-shooting, you might
follow Mosha's suggestion to define an MDX script calculation which
evaluates to the goal, then set the goal to this calculation:

http://sqljunkies.com/WebLog/mosha/a...005/12/31.aspx
However, if the expression is a simple reference, such as
[Measures].[Sales], then no hidden calculated measure will be created,
and KPIValue, KPIGoal, KPITrend etc functions will simply return that
measure. Therefore, one can (perhaps even should) create all the
calculations in the MDX Script (where they really belong in the first
place), and resolve all the precedence rules there using power of MDX
Scripts.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Mattos,

Unfortunately, I can't figure out how the filters in KPI browser view
work, but you can use an MDX query to confirm whether the KPI Goal is
working as intended. Here's an example from Adventure Works, where the
[Product Gross Profit Margin] KPI goal varies by Product Category:

[Product].[Category].Members on 1
from [Adventure Works]
---------------------------------------------------
Product Gross Profit Margin Goal
All Products 0.12
Accessories 0.4
Bikes 0.12
Clothing 0.2
Components 0.1
- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

It probably depends on the context of the [DIM LABORATORIO] dimension
when you are viewing the KPI information.

The first thing I would suggest is trying Deepak's suggestion of
creating a calculated MDX measure for your target.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <2C7B43C3-5A85-4DD4-9030-035B167B3B41 (AT) microsoft (DOT) com>,
AndrMattos (AT) discussions (DOT) microsoft.com says...