cancel
Showing results for 
Search instead for 
Did you mean: 

Planning Dates in BPC 10.1

Former Member
0 Kudos

Hi Friends:

We have simple requirement to be able to plan Date (Eg: Expected Shipment Date) using BPC 10.1 Embedded.

Looks like DSO and Infocube aggregates does not allow to have KF\CHAR with Date type in KF or Data field.

Is there is any other way to plan dates and be able to use these dates for any reference in calculation inside FOX.

Thanks

Venkatesh

Accepted Solutions (0)

Answers (1)

Answers (1)

jrg_finster3
Active Participant
0 Kudos

Hi Venkatesh

in General you can only store numeric values  as BPC Transaction data.

You have 2 possible ways to store Dates:

1. Use Comments

Comments are stored as Text, but a user can enter what ever he wants. So calculation on that text is not possible

2. Store Dates in format YYYMMDD (20151130)

in Inputshedules you can Display the date properly via formating

In Local Members you can calculate with this form of Date

In ABAP you can convert the date

But i didn't use Fox yet.

regards

Jörg