Skip to Content
author's profile photo Former Member
Former Member

Convert DATS to DEC for BPS upload

Experts

I am using the 'How to' paper to load a flatfile into BPS.

One of my upload fields is a date that I want the user to enter in the format ddmmyyyy. The date BW infoobject is a Key Figure of the DEC type. ie the number of days from 01.01.0001.

How can I convert the data on the upload via BPS and in where in the configuration do I do the conversion ie INIT or FM.

A section of sample code would be greatly appreciated.

Many thanks for your help.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 11, 2007 at 08:44 PM

    Hi Nabanita,

    you could change it in the FM which would be earier to do. INIT is also ok but i would go with FM only. you could code it something like this.

    read the field for which the value is entered.

    read the values into a variable ,calculate the difference and put it back into the infoobject. i can send you a sample code .pls provide me some e-mail ID.

    regards

    Sai Vishnubhatla

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 12, 2007 at 08:38 AM

    Hi Sai et al

    Via manual entry in BPS 10.10.2006 is stored in the cube as 732,595

    10.10.2006 in internal format = 79939898

    01.01.0001 in internal format = 99989898

    If I subtract these I don't get the 732,595 that I'm searching for.

    How can I derive 732,595 from 10.10.2006?

    Please send any sample code to warwick.071077@hotmail.com

    Many thanks!

    Message was edited by:

    nabanita ghosh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.