Skip to Content
avatar image
Former Member

Derive month from Sign data

Hi Guys,

I've got a situation, maybe you guys can give me a idea:

I have Dimension: Project (X-Axis) Account: start date, enddate, cost, Time : 2017.INP (Y-Axix),

Project, start_date, enddate, cost

project1, 01/01/2017, 30/09/2017, 9000

(we're planning in excel)

once we save. What I want is to create transaction like for time

project, time, cost

Project1, 2017.01: 1000

...

Project1, 2017.09: 1000

I know that the 01/01/2017..30/09/2017 are signdata.

how can I achieve this? any example?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Jan 23, 2017 at 12:48 PM

    "What I want is to create transaction like for time

    project, time, cost" Transaction??? BPC is not a transactonal system, please explain what do you want to achieve!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 23, 2017 at 01:03 PM

    Hi Vadim,

    I agree with you, this is not a transaction system.

    The idea is to generate those values so I can know now how much the cost of this project for those specific months (reporting).

    that's ok if it is not possible in script logic. I will try to write in BadI then, do you have an example of that? if not, I will do it myself from scratch (just for save time)

    Cheers

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23, 2017 at 12:58 PM

    If you want to generate records based on time interval stored as signeddata the only way is to write custom logic badi. Script logic will not help.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 24, 2017 at 05:18 AM

    Hi,

    One option might be to create the data in excel, only, by using some macro coding.

    The main sheet (visible sheet) will have the report in your format. Create a hidden EPM input form and use a macro to transform the data from the main sheet to the hidden sheet. Create save button on the main sheet, which should save the data from the input form in the hidden sheet.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 24, 2017 at 06:16 AM

    Ni Nilanjan, thanks a lot.

    But, i thought about this option, but, there might create several challenges...but, I will consider as last grit :)

    Cheers!

    Add comment
    10|10000 characters needed characters exceeded