We got access to a production version of the EssCS last week and started our work. As promised by product management, the Essbase Java API is available in EssCS and, believe it or not, we did not need to change a single line of source code in order to support the Essbase Cloud. We did, however, have to update our build processes to use Java 8 instead of the decrepit Java 6 used in Essbase 11.x.
As far as configuration inside Dodeca itself, the only change we made was that we configured the APSUrl in the Essbase Connection object to point to the Essbase Cloud APS instance. Note that the URL format has changed in the cloud. The Java API was accessible in Essbase 9.3.1 through Essbase 18.104.22.168 using the format:
In the cloud, this has changed to:
The Essbase Connection configuration looks pretty much the same as the configuration for an on premise connection configuration:
Of course, the Dodeca views look identical when run against an on premise or a cloud server:
In summary, it was trivial to test Dodeca using EssCS. Every single Essbase functionality that we use in the product, from data grid operations to metadata operations and even report scripts, worked exactly the same as it does against an on premise Essbase cube. Based on our testing, we are certifying the Dodeca Spreadsheet Management System to work on the Oracle Analytics Cloud.
We have a number of innovations we plan to introduce in the near future aimed to improve the Essbase Cloud experience, so stay tuned. If you are planning to come to Kscope17 in San Antonio, plan to attend the Dodeca Symposium and you may just be the first to see of these cool new things!
Developing a training course or university curriculum for Oracle Application Express (APEX)? Start here!
This courseware, developed by our product manager Chaitanya Koratamaddi over the past year, includes 16 distinct lessons, complete with PowerPoint presentations, hands-on-labs, and all necessary SQL scripts and application export files. You can use all or a portion of these materials in your own curriculum.
This same courseware was provided to the Oracle Academy team, who now also offer an Oracle Application Express course. The Oracle Academy course is offered in a hosted interactive form, complete with quizzes, and it also includes both educator and student curriculum. There are many other benefits to joining Oracle Academy. For more information about Oracle Academy, go here.
To access the publicly available Oracle Application Express curriculum, go to:
Mimer is a SQL based relational database management system (RDBMS.It provides small footprint, scalable and robust relational database solutions.
Are you using Mimer for your data marts or data-warehouse? If so, build your Free Mimer business intelligence dashboard software.
A Mimer dashboard visually summarizes all the important metrics you have selected to track, to give you a quick-and- easy overview of where everything stands. With real-time Mimer SQL reporting reporting, it's a live view of exactly how your marketing campaign is performing.
- Better Decision Making
- Gain Competitive Advantage
- Enhance Collaboration
- Spotting potential problems
- Merge with data from Excel Dashboards
- Live SQL against database
- No need for Data-warehouse or ETL
- Leverage the speed and stability of your powerful database.
After discussions at Collaborate2017 with several PeopleSoft architects we have revised our Guide to PeopleSoft Auditing. The key change is the recommendation NOT to use PeopleSoft’s native database auditing and to instead use Oracle Fine Grained Auditing (FGA). FGA comes free with the Enterprise Edition of the Oracle RDBMS and, not only is it easier to implement, FGA does not have the performance impact of PeopleSoft’s native auditing.
If you have questions, please contact us at firstname.lastname@example.org
-Michael Miller, CISSP-ISSMPReferences