We have PBCS plus and have groovy enabled. Also, to move data from BSO to ASO there are following known options:
1. DataMap via exchange data - for admin
2. Smart push - via form (on save) - for normal user / planner (and other roles)
3. Smart Push - via groovy - for normal user / planner (and other roles)
4. Data Management (also using Rest API) - not yet explored but have read posts online using REST API
5. EPM AUtomate
a. executing Job of export from BSO and import for ASO
b. Call DataMap (admin)
6. Schedule DataMap periodically (every half an hour / hourly / etc) - NOT Preferred BUT LAST OPTION
We have a scenario where a normal user / planner performs following tasks:
1. updates certain driver(s) by Scenario, Version, etc - BSO
2. processes the data at higher level of entity - BSO
3. Once the calculation is performed expects data in ASO
We are using a ruleset on save of a form to perfom the calculation and then call datapush via groovy.
The problem is the limitation on Smart Push of 500K cells and 100 MB as you may all know.
When user executed for one entity it work fine and smart push (executed by groovy) completes successfully however when a user selects upper level entity member it fails.
Obviously, we have other filters like scenario, Version, etc coming from RTP.
What have been tried:
1. We have split the smart push (via groovy) into multiple years (especially for forecast), currencies and other dimension members but still it fails.
2. We cant use DataMap via groovy as it can only be executed by an admin
Has anyone faced such issue and what alternative have been used? Or please suggest based on your experience what could help to achieve this.
Also, what issues / challenges have been faced if large number of users are saving data at same time and that number of smartpush is initiated.
Will really appreciate your views / ideas / experience.