Hyperion & stuff

Stuff about Hyperion and stuff

Dimension does not contain any member or hierarchy items

When using interface tables to update EPMA (version 11.1.1.3) dimensions, I sometimes got the “Dimension does not contain any member or hierarchy items” warning.  A quick way to remedy this issue is to recreate the interface tables using the EPM System Configurator.

Select Hyperion Foundation -> Performance Management Architect -> Interface Datasource Configuration -> Edit an Existing Datasource Link.  Make sure Create Interface Tables is checked to recreate all the tables.  Config tool will give a warning that it will wipe out all the interface tables.  This method has worked for me 2 out of 2 times.  Give it a try.

Update: Turns out leaving the Load ID empty when using the UI also fixed the issue.

Advertisements

2 responses to “Dimension does not contain any member or hierarchy items

  1. jasmine December 26, 2014 at 6:59 pm

    “Update: Turns out leaving the Load ID empty when using the UI also fixed the issue.” this helps/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: