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

Data Analysis Using SQL, Python and BigQuery

Recently Google’s BigQuery came across my radar, so I decided get hands on it to see what all the buzz was about. The US traffic fatality records database looked interesting because it contains information on all traffic accidents in the US where at least 1 person died. No doubt a sad topic, but one that…

Read More

Easy Navigation Across Cloud Subscriptions – Part 1

As a planner and avid PBCS user, it is possible you have subscriptions to numerous Oracle cloud offerings, or may leverage multiple planning applications. In the past, you had to log in and log out of each of your environments one by one, or open multiple web browsers to use all of them at once.…

Read More

Oracle Analytics Cloud(OAC) – BI Snapshots

A snapshot is an archive or backup file that enables you to restore your cloud environment. You can take a snapshot of the system at any time. I often use snapshots to move content between OBIEE instances. Below are the steps to take a snapshot in BI OAC: Creating Snapshot From the Homepage of your…

Read More

Referencing ASO Summary Data in BSO Calculations

The Short of It Using the @XREF function, we can leverage consolidated data from an Aggregate Storage database to drive Block Storage (Essbase/Planning) calculations in a fast, dynamic process. Example Your company (Pop Inc.) sells snacks and drinks from kiosks. You calculate driver-based revenue metrics for an array of FP&A exercises based on Year-Over-Year impact.…

Read More