Skip to Content
0
Sep 22, 2011 at 04:34 AM

BI to BPC data load automation

15 Views

Hi Experts,

I am new to BPC , I have an issue with loading the transaction data from BI from BPC envonment. I have a work around which is cumbersome , I have created a dimension called zkeyfig and have mapped this in the conversion and transformation. Now I have to map all time dimensions, I have mapped like 2010.jan to BW, here how will I write transformation for time like BI,

YYYYMMDD -2011.jan

YYYYMMDD- 2011.feb

....................................

Do we need to write the conversion like this or is there a way like what we write in BI , if I write like this I wil have to write for years together. Do we have a better way of writing this

thanks

Raj