Skip to Content
avatar image
Former Member

Display report based on category context change

Hi All,

I have a requirement where records will be fetched and shown in report based on category selected from context which will be matched with some date. For example . If I choose Category= Plan then this will be matched with date i.e. 1/8/2015(dd/mm/yyyy).If I choose Category= Forecast1 then Date will be 1/4/2016. Assuming we are in August 2015 and Planning for 2016.

In my report in row axis two dimensions are there Employee and Cost Center and in column axis HR Account, There is two main field in HR Account is START DATE and END DATE. So when ever user select category plan from context only End date starting from August and August onwards will be only shown in report, if user select Forecast1 then report shown from April and April onwards.

Thanks

Mayur

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Apr 13, 2016 at 04:19 PM

    Hi Mayur,

    Is these moths are fixed or change on time basis?

    Thanks,

    Subbu.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 13, 2016 at 05:09 PM

    Sorry, but how category is related to start date for HR account? Absolutely not clear... Please provide some screenshots and explain all details...

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 14, 2016 at 12:25 AM

    Hi Mayur,

    you need to use EPMDimensionOverride for HR ACCOUNT

    determine the date from category, then use that in the override formula.

    Andy

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 14, 2016 at 04:59 AM

    Hi Mayur,

    You can create one property in Category Dimension, where you will fill the months details.

    While creating report, you can fetch the data of this property from EpmMemberProperty and then you can use EpmMemberOffset to get the required field in report.

    Regards,

    Rahul

    Add comment
    10|10000 characters needed characters exceeded