Skip to Content
avatar image
Former Member

How to populate Fiscal Year Period in Infocube from FlatFile Datasource

Hi Guys,

I have a FlatFile Datasource which does not have Fiscal Year period but Fiscal Year and Posting Period.

How can I get Fiscal Year period values in the Infocube since in trsnaformations I dont have a filed to map in Datasource?

Please suggest something.

Regards

Ajoy

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    May 29, 2015 at 04:08 PM

    Hi Ajoy,

    1. Add 0FISCPER to cube.
    2. Write routine to concatenate Fiscal Year and Posting Period.
    3. For 0FISCPER write routine CONCATENATE Fiscal Year AND Posting Period INTO RESULT



    Thank you,

    Nanda

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 29, 2015 at 04:01 PM

    Hi,

    Look for work around based on look ups.

    Mean at bw side any cube/dso/master data have fiscalyear/ posting periods. then try to look for possible conditions(between flat file data source fields and cube/dso/master data obejcts) to load data into cube by lookup routines at transformations level.

    Based on possible condiitons, we can write look up code in start or end routiens to fill those obejcts(fiscyear/posting period)

    Thanks

    Add comment
    10|10000 characters needed characters exceeded