Each night we need to copy data from our budgeting cubes to a custom reporting cube in a cloud-based environment. Our preference is to use a custom application engine (BI#) process to copy data to the reporting cubes. We have built and tested the process and are trying to determine the best way of scheduling the process. We have looked into using ION workflows, but have not been able to determine how to add our process to the API calls listed as part of the BI Application Manager product within the ION products. Is there a way of doing this, or is there another way to schedule the process? By the way, rules are not an option because it would create a performance issue when accessing the reporting cube.
