Monday, 23 December 2013
Let me begin by defining a ReForm. A ReForm is an amalgum of Reports and Forms and has the DNA of both. This discussion not only presents a ReForm but also demonstrates the enormous benefits of using JQuery in APEX report development.
Monday, 16 December 2013
Data is often stored in sparse form and business often wants to see data in a more organized and explicit fashion. Report developers working across reporting technologies face a requirement to show a record with a '0' in the measures columns if no data exists for a particular combination of dimension values. For such a requirement, we will have to densify the data and this article presents a way to densify and aggregate on the fly.
I wish to state that this article is borrowed from my book on Oracle APEX 4.2 Reporting. You can check the table of contents and a brief description along with screenshots.
Let me explain the use case now
Thursday, 12 December 2013
This article is borrowed from one of the topics of my book (http://www.packtpub.com/oracle-apex-4-2-reporting/book) on Oracle APEX 4.2 reporting. Check the chapter by chapter description and the table of contents to know about the other discussions in my book. I wish to talk about the process to engineering breadcrumbs of varying lengths in this article. Let me explain the motive with an example.
Wednesday, 13 November 2013
I faced a rather strange but relatively simple requirement a few days back. The client had employed a resource to refresh the sessions page and capture the running queries from it and mail it to a team that dealt with performance tuning. This is certainly not the most efficient resource management.
It is strange that OBIEE has an elaborate mechanism of Usage Tracking but this system does not capture the running analysis. It captures the info only after the queries have fetched the desired results and not while they are still running.
This post talks about devising a programmatic way of capturing the info about running analysis/reports in OBIEE 11g.
Thursday, 3 October 2013
Wednesday, 25 September 2013
This article is in continuation of my previous work on Oracle Map Viewer/Map Builder and Oracle 12c database.
This article demonstrates the conversion of ESRI maps to datatype (SDO_GEOMETRY) that can then be used in Map Viewer. The article ends with an HTML code that can be put in APEX's HTML region to display the map with ESRI info on it.
Saturday, 14 September 2013
Map viewer is a kool technology and I wanted to write about it for a long time.
Let me first chalk the steps that we will follow. We will
1. Download Map Viewer and Map Builder.
2. Create a pluggable database (pdb), create a pdb user and grant the necessary privileges to it.
3. Configure Map viewer.
4. Insert spatial data.
5. Use Map Builder to create styles and themes.
6. Get a key from google and then use it to create a map tile layer using Map Viewer.
Friday, 30 August 2013
Oracle APEX 4.2 reporting is designed to bring the best of the reporting world for intermediate –advanced readers. The book is available at http://www.packtpub.com/oracle-apex-4-2-reporting/book. It is designed to expose APEX developers to other reporting solutions, inform them about the strengths of each of these and to enable them to use these technologies in APEX. The book also assists designers who wish to use APEX with their existing heterogeneous enterprise so that their existing code is reused and effort in building better business intelligence systems is minimized. The table of contents of the book can be found at http://obiee-oracledb.blogspot.in/2013/07/my-upcoming-book-oracle-apex-42.html. Let me briefly walk you through the contents of the book.
Posted by Vishal Pathak at 22:30:00
Thursday, 11 July 2013
I have finally finished writing my book on Oracle APEX reporting. The book