OBIEE – Refreshing GUIDs in Presentation Catalog

User identities are stored by a globally unique identifier (GUID) within Presentation Catalog. Sometimes, when migrating between environments the GUIDs become out of sync, resulting in an authentication error when trying to sign in to presentation services. Follow the steps below to refresh the GUIDs. To refresh the GUIDs, two core configuration files need to…

Read More

How to Copy Supporting Detail From Batch in Hyperion Planning

Have you ever had a business requirement to automate copying of supporting detail across multiple Scenario/Version combinations? I have a requirement to not only be able to copy the comments along the Versions (Working, Official), but also the Scenarios (Annual, Current Estimate, Prior Estimate).  Some of this can be automated using Version copy, but anything other than…

Read More

Using the Paste Formatting Tool in Hyperion Financial Reporting Studio

Hyperion Financial Reporting Studio (FRS) contains a button to copy and paste formatting. This is a powerful tool, but it has some limitations that make it appear less useful than it really is. This post will explore what this tool can do (and show you how to work around its limitations). Basic Format Paste We…

Read More

Shared Workspace Pages in Hyperion

If you ever find yourself in the situation where the Shared Workspace Pages folder has deleted or missing, you’ll most likely receive an error message upon logging into Hyperion Workspace. The error message reads “The startup document specified does not exist in the repository. Select a new startup document on the General preferences tab.” [caption…

Read More

OBIEE – Opening an Image Using HTML Image Link

There are many use cases when and why a user would want to view an image in reference to a particular piece of data in OBIEE. The example below demonstrates how to create an HTML image link. The business users wanted to be able to review invoices that were assigned voucher numbers. If a voucher…

Read More