Question:
Dear All,
I have a report based on a cube that contains transaction data and some target data from MD.
The target data is in the form of:
Month Target
----- ------
03/2005 1.0
04/2005 2.0
05/2005 3.0
Running the report comparing the actual with target appears fine. But when I introduce a free characteristic, the target only appears on the # row:
Month Category Target
----- -------- ------
03/2005 A
B
# 1.0
04/2005 A
B
# 2.0
05/2005 A
B
# 3.0
This is since the target is not defined against the category. In my instance, the category is irrelevant and I want the target to appear on each row of the category:
Month Category Target
----- -------- ------
03/2005 A 1.0
B 1.0
# 1.0
04/2005 A 2.0
B 2.0
# 2.0
05/2005 A 3.0
B 3.0
# 3.0
How can this be achieved?
Ian.
Answer:
Try the max value, or maybe fixed selection
Answer:
Nice try.
The maximum makes no difference.
Constant selection uses the value from the report total for all rows, not at month level.
Thanks for having a look.
Ian.
Answer:
constant selection is the solution
Search the forum, I already wrote a lot about that.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Fred,
Thanks for the help. I was getting confused with Constant Selection on the properties of the key figure rather than on the restricting characteristic.
Cheers,
Ian.