|gerdpee on Dimension does not contain any…|
|jasmine on Dimension does not contain any…|
|gerdpee on Oracle WebLogic and Hyperion S…|
|OBIEEfan on Oracle WebLogic and Hyperion S…|
Stuff about Hyperion and stuff
Another undocumented feature that I learned today from Oracle support is the ability to move primary members in interface tables. However, this only works in the latest 220.127.116.11_04 patch of EPMA (I think). Without any changes, I don’t think it’s possible to move a primary member already in EPMA when loading using interface table. What happens is EPMA will add the member in question to a new parent as a SHARED member. Annoying isn’t it.
To remedy this, simply add a new column to the HS_XXX_HIERARCHY tables called ISPRIMARY. The value for this column is ‘Y’ when member is a primary member and ‘N’ when member is a shared member. Quite a nifty feature when using the interface tables and your dimensional hierarchies keep changing.
In 11.1.2, the ISPRIMARY column comes pre-build in the interface tables. So no need to do the above.
BTW, I’ve only tested this on moving PRIMARY members and not SHARED members. I don’t know whether it’s even possible to move SHARED members using this method.
Update: In 18.104.22.168 the workaround above only work if the load profile mode is set to “Replace” in EPMA and will NOT work with “Merge”.