Oracle APEX

Currently we use Oracle Application Express in only one department, but looking at how easy and fast is to add more small apps solving different tasks I believe it will be broadly adopted by a large audience very shortly.
I want to share my experience in one app we did. We are maintaining a relatively large data warehouse, design in star schema. This was used as a source for few BI tools and standard reports presenting some parts of Data Warehouse, but there was always a need for people with no SQL knowledge to get look in some part of data warehouse not presented in existing reports and tools to explore new possibilities or just to verify data. So we need some kind of simple presentation layer that quickly and easily can expose the data model and provide access to end user where they can review data in form of tables or charts. APEX look like is the perfect environment for that.

Missing bit in APEX is built in functionality to define data model but that was easily solved by simple web forms where power user can define relations between fact and dimensions and store that metadata to enable dynamically SQL generation later by end users. The end users can generate dataset automatically using simple graphical interface, without the need to know SQL. Data presentation is power by a dynamically populated APEX interactive data grid. It appears that the solution was adopted by users well and we enriched it quite easily with adding functionality to organize access to app by user, roles and different permissions enabling user to share report definitions between them. This is app working internally but I created an instance of it in OCI where you can see how it works presenting a sample oracle star schema model.
https://simplebimple.com

Login with :
user: demo
pass: demo

We use APEX for internal applications that provide services to users within the institution.

We used APEX to implement systems that would solve the problems, for example, lack of internal controls, lack of indicators that show the amount of work performed through informal requests by email or phone calls.

Due to the high level of requests, a web tool was chosen to allow the design, development, and deployment of applications quickly and agilely. Without incurring excessive licensing costs, we take advantage of the fact that APEX is a tool that is part of the internal Oracle database engine, so its use does not imply any extra cost than what we currently pay for support.