This content has been marked as final. Show 4 replies
file types ?, there is no "automatic" connection to DRM from Essbase. DRM is a metadata management tool used to maintain hierarchies that are "exported" out to a receiving system. What this means is that in a typical installation where DRM is used to maintain Essbase/Planning/HFM data, the data is extracted and loaded into DRM initially. There are outline extractors for Essbase that will allow you to take the cube structure into a file and there you manipulate it and load it into DRM.
From that point the hierarchies are maintained in DRM and sent via an "Export" which is then loaded into the cubes via "load rules".
[guggi for oracle|http://www.softsea.com/review/Guggi-for-Oracle.html].
a) You can't get data from a source directly into DRM, I.E directly frm SQL to DRM, it doesnt work like that. It's txt files only. Unless you use ODI or Informatica or some sort of adapter then it's possible.
b) You definately can export directly to your Oracle tables, no problems in that regard.
c) Comes through training and expirience, wish I could help more.