Derive month from Sign data

[former_member229754]

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

[former_member229754]

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!

[former_member186338]

For sure all calculations can be done in Excel formulas/VBA with results stored in BPC cube. But it's another story 🙂

[Former Member]

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.

[former_member229754]

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

[former_member186338]

There are no samples, you have to do it yourself!

When you read start/end date as signeddata you have to convert the value assuming:

01/01/1900 = 1

[former_member229754]

Hi Vadim,

If I manage to derive the Month and year from the signdata having like: account start_month and end_month start_year and end_year (from input templatE), it would be possible to work with script logic?

CHeers

[former_member186338]

No, script logic is VERY limited with conditions on signed data. You can only use ternary operator in the single REC line. Write custom logic badi.

[former_member186338]

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.

[former_member186338]

"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!