Skip to Content
avatar image
Former Member

Populate Time using BPS Layout

Hi All,

In my requirement i need to populate Time which is a Key figure of type DEC in the cube. Its placed in the data coloumn.

I need to populate the time whenever there is any change in the corresponding amount Key figure.

Currently it is not getting populated.

Please Help.

Thanks & Regards,

Vidya.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 20, 2007 at 11:11 AM

    Hi Vidya,

    Not sure whether its the best way,

    but you could try creating an Exit function to populate time in the required Key figure. Call this function on Change in the Layout.

    Hope it helps

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Anurag,

      Thanks. I had thought about this but how do i recognise which records have been adjusted since in X_TH data all the records come in?

      Regards,

      Vidya.

  • avatar image
    Former Member
    Aug 20, 2007 at 11:43 AM

    Hi,

    Could you elaborate your scenario a little? When you say "time" is placed in the data columns, i suppose its a planning layout you are referring to? If "time" is the key figure in the data columns, how and where is amount key figure placed? How do you want the linking from amount to "time" to happen?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vidya,

      Best way to populate date, time and username would be using characteristic relationships. Include these characteristics in the cube but not in the level, so they get derived using characteristic relationship when records are written to the cube.

  • avatar image
    Former Member
    Sep 17, 2007 at 11:53 AM

    Hi All,

    I finally had date,time and username as char in the cube.

    And since we needed archive history and recent data both for reporting purposes.

    So we created 2 versions using ABAP on open and on save functions.

    One gives recent changed values and other maintains history records.

    eg: C1 01.2007 User1 100 F -- History records

    if user increments value to 150 cube should store 150 and not 50

    C1 01.2007 User2 150 F

    C1 01.2007 User2 150 C -- C is only recent changed values

    C1 01.2007 User2 -100 C

    Thanks all for your help.

    Vidya.

    Add comment
    10|10000 characters needed characters exceeded