Skip to Content
0

Derive month from Sign data

Jan 23, 2017 at 12:32 PM

73

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Vadim Kalinin Jan 23, 2017 at 12:48 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Pheno BPC Jan 23, 2017 at 01:03 PM
0

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

Show 3 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

0

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.

0
Vadim Kalinin Jan 23, 2017 at 12:58 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Nilanjan Chatterjee Jan 24, 2017 at 05:18 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Pheno BPC Jan 24, 2017 at 06:16 AM
0

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!

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0