Skip to Content
author's profile photo Former Member
Former Member

Urgent! FY Field change from CALMONTH

Hi All,

As our company changed the Fiscal Year from Calendar Year to V3 Apr-Mar.

Now when I create new reports for FY using the FY fields for Profit and Loss Report, when I use the filter with FY PER interval, I dont see the data for LAST YEAR COLUMN, whereas when I use FISCAL YEAR in filter selection, I can see the LAST YEAR COLUMN..

any idea why the last year column doesn't retrieve data using FY PERIOD.

Also, with FY fields like Fiscal year and Fiscal Year/Period, how to do YTD calculation based on FY filter it possible? I think unless we have FY period selection in Filter, we can atleast try to get YTD calculation based on NEW VARIANT APR-MAR..

For Example, Say I am now in Dec 2012, but I run the report for SEP 2012, my report shld fetch data only FOR APR- SEP 2012 for YTD columns..

Anyone can give me a suggestion how to retrieve? if only thru customer exit, can anyone provide CUSTOMER EXIT CODE to fetch based on input DATE??

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 05, 2012 at 01:22 AM

    Hi Experts ,

    can anyone help me regard to my issue? Looks like I see no one has ideas when there is a FISCAL YEAR CHANGE?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Geetanjali Deshpande

      Hi Geeta,

      Are you sure that your suggestions will work..? Look very different..Also this is the P&L report which has Row structure with Key Figures and column structure with MONTH DISPLAY.

      As per your suggestion, do I need to drag the key figure as well,?? that is not I have my structure differently..

      .Also I have my YTD column in my COLUMN STRUCTURE..Is it possible or not...??

      Forgot to tell you...actually i am following the same...but not as RESTRICTED KF but as a formula in my COLUMN STRUCTURE which is not working..not sure why. If I have FYPER selection ..then my LAST YEAR column doesn't confused...

      Also after i create as you said,then I create formula and use that RKF in it right?

      Expecting your favorable reply ASAP. THANKS FOR YOUR HELP...

  • Posted on Apr 05, 2012 at 03:44 PM


    Please check out the below blog it will give you insight on your requirement.

    Hope this helps.

    Regards, AL

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      I don't have the CALDAY field in COPA cube and as well if I use FiscalYear/Period, don't why my last year column is not working?? Any idea, why last year column not working? I tried many codes with FY/Per, but I face lot of issues..

      I clearly say what is my requirement..currently my reports runs based on 0CALMONTH and since APR 2012, We change our FISCALYEAR and I wanted to changes all 0calmonth to FISCAL fields...even if I can use the 0CALMONTH, can you let me know how to retrieve the first period of FISCAL YEAR in the CALMONTH field???suggest what I need to do?

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.