Hi everyone,
I recently made a pitch to use APEX 4 for our business units daily reporting needs, ie prebuilt queries and Interactive Report pages in the apps. Our current 'supported' reporting platform is Hyperion (and Cognos to a lesser degree). However Hyperion is mainly used for more power user/ad-hoc reporting on the Warehouse. Ad-hoc is not a requirement for our Business unit to run daily reports on near real time OPS data.
I am impressed with how easy it is to create DB apps that are web based in APEX, and thought it a good solution to fulfill the reporting needs by simply creating new Tabs in an app for each report. The interactivity is more than sufficient for end-users, it's clean, etc. However I got a lot of pushback where it wasn't clear as to what gap APEX fills in this area as opposed to using Hyperion.
Does anyone have any input on this? It seems Hyperion is fine for the ad-hoc users but maybe not fo quickly creating and deploying dailt 'canned' reports.
Thanks!