Variablizing the Left Side of the Equation with @XWRITE

A common need in an Essbase calc script is to map values from one dimension to another. For example, let’s say you have accounts that you want to map to entities. You load values into those accounts at ‘Main Entity’, and then need to assign each account to its own unique entity. Dimensions: Account  …

Read More

Passing Variables to Essbase Calc Scripts from FDMEE

Those of us that have extensive experience building FDQM integrations have long used either the event scripts or customization within the load action in the FDQM workbench in order to execute standard and/or variablized essbase calculation scripts. This almost always got the job done, but was not easy. Fast-forward to the current era of FDMEE,…

Read More

Easy Navigation Across Cloud Subscriptions – Part 2

In Part 1 of this series, we looked at how to set up easy access to all your Oracle Cloud services using the "My Connections" feature.  Now we'll look at further enhancing the user experience by tying these connections into Navigation Flows. After you have your "My Connections" set up, you can enable connections within…

Read More

Deploying Modern Business Intelligence: Why Enterprise Still Matters

By François Ross Business intelligence (or whatever we call it now) is a critical component in consuming information for decision-making. There is no doubt that the technology landscape, deployment strategy, and tool selection have become far more complicated in the last couple of years. The "one size fits all" and platform normalization have become challenging…

Read More

Report Caption Attribute from PA Member in CA

Planning Analytics and Cognos Analytics Integration Tip: Change PA member caption for CA reporting The combination of Planning Analytics and Cognos Analytics is more powerful than ever before.   Planning Analytics hierarchy structure is useful in traversing data within a Cognos Analytics interactive report.  As a result, users can drill into actionable details behind summary analytics. …

Read More