on 11-11-2010 3:27 PM
Hi All,
Iu2019m trying to get a counter working properly from the following scenario:
Plant Transaction Nº Plant+Transaction Articles
0600 02587985 060002587985 xxxxx
Eeeee
Tttttttt
0600 09721456 60009721456 iiiiii
Llllll
Ffffff
0600 01574125 60001574125 iiiiii
Llllll
Ffffff
I need to count the number of transactions based on u201CPlant+Transactionu201D. In this case, I would get a column in my query that will show, for this Plant 0600, the result as 3.
The idea is to have a smaller Cube, so in that way we are taking out of it the u201CTransaction Nºu201D, the u201CTransaction Nºu201D and u201CArticlesu201D.
I was trying different options playing with a KF that we have in the Cube, which was originally created to count the Transaction Nº in another cube, and it is defined as Number u2013 DEC, Aggregation: SUM and Exception aggregation as Summation. Iu2019m adding the reduced Cube after the original one.
So, my question is: is there a way that I can calculate just the number of transactions in my last Cube, even though I do not have there the u201CPlant+Transactionu201D which will indicate the result 3 that Iu2019m looking for?
I looked through the SDN, but nothing worked outu2026
Kind regards,
Miriam
I found a formula that it seems it works..., thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.