Hi,
We have a PBCS database / application that is operated on a 'batch' basis.
i.e. they load a massive amount of data, run a 'monster' script, smart push via a form save, review, repeat all of the prior steps until review is good.
My problem comes with 'smart push' - I know others, including me have posted on this.
The form based push is only so scaleable before you get errors due to the number of permutations.
I have tried to use based on form on selective dimensions, but this gives the end user a good five minutes of running a fairly brainless task.
You don't want to give end users admin rights for obvious reasons, but there is no other way to give them 'global' push abilities. (And I am not keen on the epmautomate alternative as it seems less than secure for a remotely bright user)
So other alternatives; -
1. Business rule to data export, clear subset of ASO cube and load via rules - but on the last point you run into the same admin rights problem - and you cannot script up a data load
2. Xref or equivalent in business rule to write data to ASO - this is going to be massively slower than the pushes
3. As form solution but create X number of forms that slice the data by (say) month, so saving through twelve forms with no other changes would at least be faster - not great
4. Smart View with some VB - maybe an option to iterate the query back, save etc - but not keen on desktop solutions with cloud becoming business critical
5. Timed job that runs (say) every hour - not a bad option potentially
Anyone feel they have a good solution for this, that wholly satisfies scale ability, speed and security and preferably without a desktop presence?
thanks for any input,
Robert.