Hi Khaled.
You cannot do this in the query designer alone, because you want to display the key figure values of multiple ranks according to 1 characteristic (customer) and then break those values down by values of another characteristic (compcode). Thus, for each cell the selection for both characteristics changes (different compcode, different "set" of customers).
I would try to solve it by flagging records in a DSO before the cube, if your datamodel allows it. You would have to add "lookup" DSOs, where you stage the data for each rank, so you "just" have to check for each transaction datarecord, if it is part of any of the ranks, if yes, flag the appropriate infoobject (so you need one for each rank, 10%, 10-20%, etc).
Like this, you can build your report using the flags in each key figure selection in your columns and the comp code in the rows.
However, as more transactions come in, for each comp code the rank of customers can change, so already loaded records need to be changed, as customers go in and out of the ranks. Thus, you will have to reload either all data (because you can't know how far back in time the first record of all current incoming records is and maybe volume is low) or read the acc.doc.numbers from the last delta and use these as a selection in a full load to another DSO.
Also, you need to fix the time selection according to the business perspective (top 10% per which timebucket?), when you stage the data and hence, you cannot aggregate across this level of (time)detail, but you will be able to drill down on any other object and get a meaningful result.
At the end of the day, I would consider building a dataflow off the AR DSO I assume you have in place now. Handle all of the above in this dataflow, essentially one more dso and a cube on top with a number of lookup dso's on the side. You can provide ranks for different timebuckets like this, if you add a char to identify which timebucket it is and let users select or make separate reports.
At any rate, it can be done, but you need a separate dataflow-setup to handle it.
Br
Jacob
Edited by: Jacob Jansen on Jan 25, 2010 7:42 PM
P.S: Well, maybe you can make it work with multiple conditions on your key figure selections, but since you are not displaying the customers, I am not sure how/if you can make the condition work properly... maybe the "char assignment" when defining the condition will help, but I think you need to display the objects selected to make it take effect...
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.