Hello BPC experts,
I would like to integrate the number of days overdue receivables information into BPC. I haven't seen any topic about that, if there is one, please send me the url.
To be more accurate, what data I need to obtain looks like the following :
Not past due
By less than 30 days
By between 30 and 60 days
By between 60 and 90 days
By between 90 and 180 days
By more than 180 days.
These number of days must always be calculated according to the last day of a fiscal year. In this case, that would always be according to calendar, so the 31st December.
I know that BEx does this with 0FIAR_C03_Q0005. However, the customer wants to consolidate these data as well and uses Input form for their non-SAP entities.
Therefore, I would need a new Dimension (we can call it "OVERDUE") with 6 members (referring to the example above : not past due, less than 30 days, etc.).
What can be done to retrieve these data into BPC ?
Thank you in advance for your help,