Skip to main content

Posts Tagged ‘vbscript’

consumers

Design Patterns for Historical Translations in Oracle HFM Part 1

There is always very much confusion surrounding the topic of currency translation in Oracle Hyperion Financial Management (HFM). I will focus here on one of its more challenging aspects – translation of equity/capital accounts, aka historical translation. I will be arguing that: “Override accounts”, the traditional design for historical translations, is not the best fit […]

Use of VBScript with Selenium to connect to database

While most of the Automation scripts manipulate just the UI of an application, by making our scripts communicate with database we can accomplish more complicated tasks. Here is an example:- Suppose you have to automate an application which works on online voting system where in once the vote is casted using the application, it goes […]

PowerDesigner Tips – Deploying a Model

In its most basic form, deploying a data model means simply applying the model directly to a database via ODBC or a DDL script.  But that neglects much of that value in your model beyond the physical structure. Here are the steps in our model deployment process.  We’ve scripted these in the build tool, but […]

PowerDesigner Tips – Utility Scripts

Here’s a few utility scripts I’ve developed to aid in your XEM scripting: Scope Many functions, especially members of ExtensibleObject, require the “scope” or code of the XEM be included when referencing extended attributes, methods, collections, etc.  I’ve added these lines to the global script section as a helper: ‘ Extension navigation. All references to […]