I never really had a look at the Advanced Attributes of the Interactive Report, but I missed out on some really cool features. It shows that just like Tom Kyte, I learn a new thing every day...
Let's say I've an Interactive Report with amounts per department. The Report ID Item allows me to show a different saved view of the Interactive Report based on who's logged in and in which department they are. You find the Report ID in the APEX_WORKSHEET_RPTS view.
I'm not talking about how APEX internally or within the database works, I'm talking about how to best manage it from an infrastructure point of view.
I recently raised the issue with my client about how they were using APEX. I'm not here as an APEX consultant, but they didn't have a lot of experience in-house and the DBA who got it implemented had been trying for years. So I wrote up my thoughts and passed them along to my supervisor who then shared them with others.
The PL/SQL Challenge website has just gone live!
If you haven’t heard about it yet, it’s a website where you can pit your wits against a daily question by none other than Steven Feuerstein (yes that Steven Feuerstein!) and Finn Ellebaek Nielsen. Wait it’s even cooler than that, you can win cash (and other!) prizes [...]
I've been busy helping to get an environment set up for an Exadata POC. w00t.
What this means, is getting all of these disparate data structures into a single Oracle database. OBIEE is run on Windows and thankfully, 11gR2 was released for 64bit and 32bit this week. I downloaded it, installed the software (4 minutes) then used the DBCA to install the database (3 minutes). I really need to get a better computer because these activities take too long on my itty bitty laptop.