Update Knockout.js View Models in JavaFX WebViews from Nashorn
Learn about updating Knockout.js models from Nashorn / JavaFX which is a challenge because the Model and Controller code are not running within the browser.
Archive
Preview of Charting in SQLcl via Oracle JET, Nashorn and JavaFX
This is an example of connecting SQLcl and Oracle JET using the Nashorn scripting engine. Oracle JET application templates are deployed behind the scenes and data is loaded interactively from SQLcl sessions.
Bridge the SQL-Java-JavaScript Divide with Nashorn and Oracle SQLcl
Learn about writing Java classes and JavaScript programs for use with Oracle SQLcl and other Nashorn-based applications that run on the JVM.
Integrating Vue.js with Oracle JET
Learn how to integrate the Vue.js library into your Oracle JET applications for an alternative approach to front end HTML to JavaScript data model binding.
Using the new Oracle JET CLI
Follow along with an example using the new Oracle JET CLI including screenshots of the process and the resulting Oracle JET navdrawer web application.
Infrastructure is Dead, Long Live Infrastructure!
Some opinions on where an EPM infrastructure consultant might find hope in a dwindling on-prem market. You have some options to consider.
Learn to Build Oracle JET Native Apps with Electron and Node.js
Oracle JET can be combined with Electron to build native desktop applications using HTML, CSS and JavaScript. Follow along with this post to learn how.
JSON to SQLite on the Raspberry Pi with Node.js
Learn how to use Node.js on the Raspberry Pi 3 B to retrieve JSON data from RESTful web services and then insert that data into a SQLite relational database
Sending HTTP POST Requests to ORDS from Swift
Learn how to send HTTP POST requests to a web application server from iOS applications written in the Swift programming language.
Calculate SUMPRODUCT in Essbase ASO Using MDX
In this quick tip we take a look at how to calculate SUMPRODUCT (similar to Excel) but using the MDX scripting language in Essbase for ASO cubes.
Get Multiple Redis Hashes in Node.js With Your Own MHGETALL
Redis currently does not have a built-in MHGETALL command but you can implement one. Learn how to get multiple hashes using pipelining or multi in Node.js.
Business Rules to Launch Them All
Learn how to launch batch jobs from Business Rules with Hyperion Planning. VB, C, Java, Perl, MaxL Esscmd, ODI, and even .NET have paved the road to now.
Convert data to Base64 in Node.js
Using the Buffer class built-in to Node.js we look at how to convert data in a file to and from Base64.
Batch Scripts Can Not Suck
In this post I look at a few ways to improve your batch scripts so they are easier to maintain and hopefully suck less.
SSH Tunnels in SQL Developer
Follow the steps in this post to learn how to create SSH tunnels using the latest version of Oracle's SQL Developer.
Introduction to Version Control for Oracle EPM
Learn how to use Mercurial version control tools to track changes to source code. This is a beginners tutorial for version control with Oracle EPM.
Pragmatic Version Control for Oracle EPM
You can use time-tested software development tools and processes with Oracle EPM to keep track of source code changes and revisions.
Node.js Syntax Highlighter
Use highlight.js with Node.js to pre-generate syntax-highlighted HTML for code snippets. Note: my preferences have evolved since and I now lean on Prism.js in practice, but the highlight.js workflow below is still useful.
Dynamic Methods in VBScript
One challenge that comes up with VBScript is how to make your scripts modular so that you don't have to repeat code in multiple VBScript files. This post looks at dynamically dispatching methods in VBScript to help solve that problem.
Updated Guidance on Customizing the FDMEE Open Interface Adapter
The FDMEE Open Interface Adapter can be customized and Oracle has provided updated guidance on the process that you should follow.
Debugging Drill-Through With Node.js
You can debug HTTP drill-through requests from Oracle EPM products using Node.js. Follow this tutorial to setup an HTTP server in Node.js and debug away.
Using Windows 8.1 and Internet Explorer 11 with Oracle EPM
IE 11 is not supported with versions of Oracle EPM prior to 11.1.2.4. Check out this post for tips on getting IE11 to work with Oracle EPM.
Unconfirmed Bug in CREATEBLOCKONEQ
There may be an unconfirmed bug in CREATEBLOCKONEQ in Essbase where it creates blocks even when set to OFF. A possible workaround can be found here.
Planning Date Type to Unix Time
Use Essbase calculation script functions and 86,400 seconds per day to convert Planning Dates to Unix dates. This is useful for various Essbase date calcs.
Have You Seen Me? (Missing Block)
Essbase calculation scripts that don't produce any values are often the result of missing blocks. Take a look at this post to see how to create blocks.