cancel
Showing results for 
Search instead for 
Did you mean: 

Cumulative per year

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

drilldown both Fiscal Year (0FISCYEAR) and posting period (0FISCPER3) instead of the combination fiscal year/period (0FISCPER).

hope this helps...

Olivier.

Former Member
0 Kudos

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

Former Member
0 Kudos

hummm, tricky one but do you have the other two characteristics in your cube at least?

Message was edited by:

Olivier Cora

Former Member
0 Kudos

Hi Olivier,

we have posting period and fiscal year in our cube.

Posting period we cannot use, because if we select a time range containing multiple years the periods 001.2005 and 001.2006 are summed up together in posting period 1.

Best regards,

Ralph

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Olivier,

thanks for your respons !!!

I think we then have to solve this in the back end and add a YTD version of the key figure in our cube.

Best regards,

Ralph

Answers (0)