Question:
Suppose, I have a query with hierarchy characteristic and single key figure. When query is displayed I see a tree with values (every value is connected with every node). The parent nodes contain aggregative values of the child nodes, but I need to get values without any aggregation. I have to see a separated value for every node (parent or child).
Example:
Assume that cube contains the following records
HC KF
1 10
2 15
3 25
and
HC - hierarchy, 2 and 3 nodes have been assigned to 1 node.
I must see the tree
HC KF
1 10
_2 15
_3 25
but I see
HC KF
1 50
_2 15
_3 25
Can I set any right property for that?
Answer:
Try this:
1) open the properties of your key figure (within InfoObject components).
2) then click on "Aggregation" Panel and
3) choose "No Aggregation" instead of "SUM".
Answer:
It will be useless. A special aggregation can be used only with the particular characteristic. If I set "without aggregation", I would get "X" as result. Usual aggregation have to been set in MIN MAX SUM. Regret, but your advice is not matter in that case.
Answer:
to up
I cannont resolve my problem. What ideas you have also???