Hyperion & stuff

Stuff about Hyperion and stuff

Monthly Archives: September 2011

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.