BPC Dates

[Former Member]

Hello Folks

I'm starting developing some HR Input Schedulles.

I've got a question:

Imagine I have

Employee START_DATE and END_DATE

JohnBarnes, 01.01.2015, 03.01.2015

MarkHughs, 01.01.2015, 31.12.9999

How can I store this information in BPC?

One of reasons I want to do is

if END_DATE - START Date is < 90 days, Active Value = 1

else Active Value is 2

Is there any guide for this? because I can store only in numbers and not in DD/mm/YYYY wise

Thanks.

Regards,

[former_member186338 · Accepted solution]

Actually dates in Excel are stored as integers:

And will be saved in the cube as Integers  for Accounts START_DATE and END_DATE (not properties!)

Then:

*XDIM_MEMBERSET ACCOUNT= START_DATE

*WHEN ACCOUNT

*IS *

*REC(EXPRESSION=(([ACCOUNT].[END_DATE]-%VALUE%)<90) ? 1 :  2,ACCOUNT=ACTIVE_VALUE)

*ENDWHEN

Vadim

[Former Member · Accepted solution]

Hi Thanks.

One question

I want to implement the following logic for example:

EMPLOYEE, START_DTE, END_DAT, VALUE

JohnBarnes, 01.01.2015, 03.01.2015 1000

MarkHughs, 01.01.2015, 31.12.2015 2000

I want put the logic like

EMPLOYEE, TIME, VALUE

JohnBarnes, 01.2015 1000

MarkHughs  01.2015 166.667

MarkHughs  02.2015 166.667

..

MarkHughs  12.2015 166.667

How can I implement this logic?

Thanks

Regards,

[former_member186338 · Accepted solution]

You have to create custom logic badi! There is no way to convert signeddata value into periods with script. But badi will be more or less simple!

Vadim