Hi BWers,
Currently we have one infoprovider which holds the Actual data for Last and current years. And the data load frequency is daily. We have got an requirement like, From next month onwards CRM (source system) will providing targets values in a database table. As per the clinet requirement we have to upload both Actuals and Target values in the existing infocube only.
All the required information providing as follows:-
1) Existing infoprovider updates daily with CRM actuals. No version exsits for this data.
2) All the target values will be provided in CRM database table and the targets will be updated monthly (0FISCALPER).
3) We have one report to find delta and report execution frequency is Quarterly.
I hope we can achieve this by versioning concept say v01 for actuals v02 for Target values.
1) How to add version (0Version) to incoming actual data from CRM. I am not sure at what level we can add this infoobject (I mean to say Start routine, End routine / Update routine).
2) Currently we are using BI 7.0 system as the datasource for Actual / Target values are differ, Can I add one infoobject directly to existing Infocube and in the trasnformations I can maintain as constant (V01). But to how maintain Version (V02) for target values.
3) Pls let me know the effective method to maintain versions for actual and target values.
4) As the target values are based on Fiscal period, what the relavent info object in BW system.
All the relavent answers will be rewarded with Full Points.
Regards,
Suresh