Question:
Hello,
I have a trouble in some queries.
I want to obtain the equivalent funcionality of a standard SQL count-distinct.
I try to explain with this example :
I have 2 Purchase Order (PO) with 2 position for each order
The position of PO number 1 have different WBS Element.
Costcenter N.PO N. position PO
A 1 2
B 1 2
I drill down with another dimension
Costcenter WBS N. PO N. position PO
A A 1 1
A B 1 1
B A 1 2
How can I obtain this functionality.
thanks to all.
Fabio
Answer:
for PON, create a calculated KF on the infoprovider, and put an exception on PON with 'count occurrences"
For PONPOS, you should add a line counter to your cube, since it's combination of PON and PONPOS which has to be counted.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.