on 11-30-2015 5:29 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.