Dear BPC Experts,
I am working on moving transactional data from BW multiprovider to BPC using package ‘Load Transaction Data From InfoProvider’ . The data transformation validation failed and as accepted the loading of data in BPC cube failed.
The main reason for this is that there is lot of old data in BW and in BPC we only want data for last 2 years. So is there any way in data manager or in data transformation file that I can limit the flow of data from BW to BPC.
For example suppose that the total fields in my account BW database are 4000 and I only need 1000 fields ( i.e for last 2 year, say from 3000 to 4000), so how can I restrict the flow this data.
Also, is it possible to create multiple restrictions i.e. 1) based on above data, and 2) based on year? For example data from year 2010 should come to BPC.
Lastly I am working on BPC 7.5 NW