John post a great blog about extracting data from Essbase using calculate script. Here, I want to give another example with report script.
1. create a report script in Essbase and test it.
2. Copy the .rep file from Essbase server to ODI server if they are installed on separate machine.
3. If you haven't create source/target schema yet, please refer John's previous blogs for detail. I changed the data type from blank to char for all Essbase output columns manually.
4. Set the properties of LKM Hyperion Essbase DATA to SQL
EXTRACTION_QUERY_TYPE := ReportScript (default)
EXTRACTION_QUERY_FILE :=E:\report.rep(ODI server's path)
5.Save the interface then execute it.
Sunday, September 13, 2009
Subscribe to:
Posts (Atom)