on 08-22-2007 12:16 PM
Hello all,
How can I ensure that my key figure is cumulated only per fiscal year?
Thus, now I have:
January 2006 - 8.850.678
February 2006 - 17.449.955
March 2006 - 25.914.014
April 2006 - 32.849.374
May 2006 - 39.631.877
June 2006 - 46.682.151
July 2006 - 55.484.241
August 2006 - 64.676.416
September 2006 - 72.477.761
October 2006 - 80.969.174
November 2006 - 90.091.606
December 2006 - 98.864.938
<i><b>January 2007 - 107.441.106
February 2007 - 115.239.376</b></i>
And I would like to have:
January 2006 - 8.850.678
February 2006 - 17.449.955
March 2006 - 25.914.014
April 2006 - 32.849.374
May 2006 - 39.631.877
June 2006 - 46.682.151
July 2006 - 55.484.241
August 2006 - 64.676.416
September 2006 - 72.477.761
October 2006 - 80.969.174
November 2006 - 90.091.606
December 2006 - 98.864.938
<i><b>January 2007 - 8.576.168
February 2007 - 16.365.438</b></i>
Thanks in advance,
Ralph
points will be awarded
Hi,
drilldown both Fiscal Year (0FISCYEAR) and posting period (0FISCPER3) instead of the combination fiscal year/period (0FISCPER).
hope this helps...
Olivier.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Olivier,
I wish it was that simple ;-\
We are only using fiscal period in our Visual Composer cockpit and the user must be able to select for example a range between 001.2005 and 012.2007 to see the long term trend.
The values should then be cumulated for period 001.2005 till 012.2005, period 001.2006 till 012.2006 and period 001.2007 till 012.2007. The pattern looks just like a saw.
Hope anyone can help me further.
Ralph
Hi,
I have played in my system in order to see what can be done; unfortunately no success since the "cumulated" setting always depend on your navigational status, this is the characteriscs in the drilldown.
Unless you think about a sophisticated solution with virtual keyfig and/or changing the web item table data dynamically, I don't see a solution to your problem...
Since you are using the VisualComposer, can^t you manipulate the data in this environment? I don't have time to setup a test case unfortunately but in theory, that should be possible...
Last but no least, I guess you are working with a FI/CO cube and if you use GL, the datsources usually provide such xearly cumulated key figure... You can as well think about modelling this KeyFig directly in your cube using return table routines for example.
hope this helps...
Olivier.
User | Count |
---|---|
84 | |
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.