Hello Guru,
I have below scenario configured for BPC. Do please let me know your thoughts.
I have 0FIGL_C10 infocube configured in BW where i have data for Entity 1000, 2000& 3000. Data is available from the year Jan 2006 till Nov 2011. 0FIGL_C10 infocube gives data in 3 currencies (00, 10 & 20)
My requirement is below.
1. Entity 1000 is discontinued but data still comes in 0FIGL_C10 infocube. How should i restrict this entity in BPC ? Data manager package doesn't have any selection criteria option like Transformation file has..
2. I have 2 reports. P&L and Balance Sheet. for Balance Sheet , I want to select 100000 to 200000 G/L Account with Currency Type 30 & for P&L, I want to select 300000 to 400000 G/L Account with Currency Type 10. Do let me know how this can be done ?
3. I have data from Jan 2006 till Nov 2011 in my BI Infocube but i want to load only 2011 data into my BPC. So, with that said when i do initialization from BI to BPC, i should be able to extract data from Jan 2011 till Nov 2011 and from December onwards i should be able to extract data for December and then onwards month. How should i manage this because in BI i have data for last 4 years.
Do let me know your valuable thoughts.
Regards,
Komik Shah