Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-06-02 05:36 AM

New datamodel Hyperion HFM as of 11.1.2.2

Dear community members,

At Schiphol we made a QlikView dashboard on the database of Hyperion Financial Management (IFACT HFMSYS schema). Somehow the datamodel was changed with the 11.1.2.2 update (we updated recently to 11.1.2.4). The IFACT_DCE_X_YYYY tables no longer contain LCUSTOM3 and LCUSTOM4. We were told the information of previous LCUSTOM1 and LCUSTOM2 is now in LCUSTOM1, and, LCUSTOM3 and LCUSTOM4 is now in LCUSTOM2. This has something to do with the new feature unlimited configurable dimensions.

Was anyone able to reconstruct the old LCUSTOM columns? Any details on the new datamodel are very welcome!

Kind regards,

Edwin Terink

998 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2017-05-31 02:37 AM
Author

Hi Edwin,

Did you manage to figure out how to handle the issue ? i am currently working on a project where i connect to the hfm database and i am kind of stuck as i am unable to relate the scenerio , custom3 and custom4 with the DCE subcube transactions. will u be able to share the data model (just a screen capture) ?

Thanks,

Punartha

545 Views
0 Likes