Skip to Content
avatar image
Former Member

LO enhancement

Hello

I am loading a cube from the LO datasource for sales order item 2lis_11_vaitm.

I need some extra fields like fiscal year, fiscal quarter, etc. Do I have to enhance the datasource with these fields or can I just add it to the cube in BW?

Thanks

Adi.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 16, 2008 at 05:56 PM

    there should be a way to get the data for those fields in the cube.

    so even if you add in the cube you still need to have it in the underlying source which in your case is the datasource.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 17, 2008 at 05:42 AM

    Hi,

    for calculating fiscal year, fiscal quarter etc. in Cube you can use some function modules:

    e.g. DATE_TO_PERIOD_CONVERT or FISCPER_FROM_CALMONTH_CALC

    /thread/364138 [original link is broken]

    If you cannot get your fields by calculation or formula in transformation you have to enhance the DataSource. Here are some useful links:

    LOGISTIC COCKPIT - WHEN YOU NEED MORE - First option: enhance it !

    LO Cockpit Enhancement

    Regards

    Andreas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 17, 2008 at 12:07 PM

    First you need to decide on a date on which your time charecteristics need to be based.

    This is generally done as per spec(after discussion with customer/end user who asked for the report)

    Besides this you will also need the field PERIV(Fiscal Year Variant) which is already present in the data-source 2lis_11_vaitm.

    Add all the time charecteristics in the cube.

    Next just connect the date and periv to the time charecteristic.

    This should work for you.

    If it doesnt you will need to write a routine and pass the date and fiscal year variant to an FM(check links on earlier post).

    Add comment
    10|10000 characters needed characters exceeded