Display a KPI need the same Dimension on its Value and Target?

I mean, I have a KPI, it's value is set to a measure of a measuregroup based on a facttable A. and it's Target is set to a measure of another measuregroup based on another facttable B.

Now I want to display the KPI, with a given dimension's slice. My question is, is it needed that the dimension I chose must be shared by both the measures of KPI's Value and Target? For an example, If I dispaly the KPI with the Promotion Dimention, and the Promotion Dimention has a relation to the KPI's Value's related measure(There's a PromotionKey column in facttable A; ), but it has no relation to the KPI's Target's related measure(There's NOT a PromotionKey column in facttable B).

Could I do so?

I think this is SSAS question. I moved it to the SSAS forum...|||

OK.

Help, Help! Thanks.

|||

The KPI should work similarly to the underlying measures - so, in your example, the KPI Target behavior will depend on how the IgnoreUnrelatedDimensions property of the "facttable B" Measure Group is set. If true (default), then the KPI Target should be unaffected by slicing the Promotion dimension; if false, the KPI Target should become null.

http://sqljunkies.com/WebLog/mosha/archive/2005/12/31/cube_init.aspx

>>

Default members, MDX Scripts, Security, KPIs and Perspectives

...

KPI trigger creation of hidden calculated measures only if the MDX expression for the KPI property is not a simple reference to some measure (either calculated or physical). 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.

>>

http://msdn2.microsoft.com/en-us/library/ms365411.aspx

>>

Configuring Measure Group Properties

...

IgnoreUnrelatedDimensions

Determines whether unrelated dimensions are forced to their top level when members of dimensions that are unrelated to the measure group are included in a query. Default setting is True.

>>

|||Thanks! that's what i am looking for! Thank you, Puri.