Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE 12.2.1.2 how to retrieve HFM Entity CurrencyType and UserDefine info

Hi all,

I have my OBIEE 12c integrated with HFM 11.1.2.4 by using the oracle adm driver.

The HFM metadata were successfully imported to the RPD and able to built report in OBIEE.

We would like to retrieve the CurrencyType for each entity from HFM for our dashboard. I have tried to use the predefined column "CurrencyType" , but it keep display nothing, just like null.

May I ask how can I retrieve the CurrencyType info as well as the userdefine flag from HFM? Thanks!

Best regards,

Ivan

Find more posts tagged with

Accepted answers

All comments

Robert Angel

Hi Ivan,

I have used other EPM (Planning, HPCM, Essbase) solutions but not HFM with OBIEE, but if CurrencyType is a dimension in your underlying Essbase cube then this is not working, you should see Members when you (say) create a filter and use the value selector to pick what you are filtering.

If this is not happening for you then I would double check your set up.

Gianni Ceresa

Robert Angel wrote:if CurrencyType is a dimension in your underlying Essbase cube

If only ... HFM has no cube, just a fake "multi-dimensional" model fully in relational DB. So everything is on the ADM driver and HFM hands to make it looks like a cube...

@2900201 : my sample HFM VM crashed badly (right before I started taking screenshot for a presentation) and refuse to start since then, had no chance to look a bit more in details at things

[Deleted User]

Stupid Windows stuff, right?

Robert Angel

Thanks for the info - as I said my EPM experience has been on the Essbase side of the world, though I know that HPCM now also has the relational option to cater for Cartesian products that exceed Essbase's mighty 2 x (2^52) sparse permutations.

Surely it must come down to the initial set up, RDBMS in theory makes life easier - whatever it says on the Oracle 'gloss' - I would rather model against RDBMS databases 10 days out of 10.

[Deleted User]

Not if that "model" is a dynamic one with recursive self-joins where attributes definitions are stored as rows in a table and the values / members of that attribute in a other table

2900201

Thank you guys!

yup! the HFM has no cube. Is it mean that I cannot retrieve the Member attribute value in OBIEE? I checked the RPD and found no way to import the attribute information,,,and I just only want to retrieve the entity currency type from the HFM.

Regards,

Ivan

Robert Angel

That sounds performant, transparent and easy to use a crock

Seriously though, with the way it works is there any way to (non-intrusively) customise, what I had in mind was creating a lookup table and using the lookup so they can use it to get their currency information?

Gianni Ceresa

Hi Ivan,

I honestly don't remember if there is something you can change/add in the import the wizard gives you. I would say not much for sure as the ADM driver isn't really powerful (at least what I saw with Planning).

You can try to have a look at the webcast Oracle did few days/weeks ago as it was about integration of Hyperion tools in OBIEE, maybe they cover what you look for: https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?id=2333200.1

Robert: you can do things my hand in the HFM DB (not supported of course), as Christian says the model is recursive (if I don't remember wrongly), but still possible to get things out in a view and try to federate it back with the HFM source in the BMM layer. Could be an interesting workaround for Ivan in case there isn't a cleaner official solution to his need.

[Deleted User]

No that webcasts contains pretty much zero information apart from "click here, do this" for an initial setup of an integration.

Robert Angel

Yes - federation - a grand title for my nasty little look up table workaround, but it could be a workable option, though I guess my concern would be performance as the currencies would frequently become the obvious choice for filters...