Allowing Users to Annotate Interactive Reports

At the last place I worked the company staff (especially managers) were keen on using spreadsheets for everything – almost to the point of obsession. Anything that looks like a list or any kind of table was put in a spreadsheet. Sound familiar? Many of these spreadsheets were actually just csv output from queries of the database and the only reason they were put into spreadsheet form was so that the user would be able to annotate each row with

Read more

Dynamic Region Source for Interactive Reports

Before Interactive Reports existed I used to use classic reports based on PL/SQL source to allow for a dynamic report source.  I now have an application where I want users to be able to select the source data of the report, but still have all the functionality of the Interactive Report. Luckily, in my case the data sources that the end user can choose from for each report all have the same structure.  Each report is based on a single

Read more

Automatically Generating Apex Pages – 2

My method involved the following steps : STEP 1 Create  an Apex report page as normal using the designer which would have all the features for all future report pages.  Here is an example report. NB.  There are additional regions that are implemented on a global page but which also use the metadata tables.           STEP 2 Export the page and examine the calls to wwv_flow_api – match them to the components on the page. STEP

Read more

Automatically Generating Apex Pages – 1

In 2016 I was asked to “do some stuff” with my company’s data.  I chose to use Oracle Apex because Its free (the company is already using Oracle database) its easy to use (the company staff had limited Oracle skills) Apart from that, Apex is what I do and so i had been employed specifically to introduce it into the company. The existing MI “suite” consisted of a jumble of overnight extracts of data, each output from a simple stored

Read more