Badges

310 Points
Consultant
4 Years
Top 5
Leaderboard

User Activity

About 1 year ago
I would say the biggest difference is that ODI is a corporate class tool that can do anything no just in a matter of ETL but a process controls since you can have ODI managing your entire environment using java code to start processes, or calling web services and more. OIC…
About 2 years ago
That depends. If you are issuing one command (like a MAXL command) the error will be the same error that you'll see in a DOS windows (not too helpful hehehe). But, you can use a extended version of "OS Execution" that allow you to write a .log and a .err file (The extension…
About 2 years ago
Hi Gary how are you? I already used OWB and informatica. I would say that depends of the version you use! If you use ODI 11, it's different from everything else. It'ls more like a integration tool then a ETL tool because, out of the box, you will always have multiple…
Over 3 years ago
Feel free to ask about anything related with ODI as architecture, possible uses, ideas.... and also tell stories of success or failure using the tool! We can even discuss why it failure and if there're anything different that could change the situation!!
Over 3 years ago
Hi Moses how are you? I usually try to avoid XML as much as I can since XML is always a problem... The only case I end up using XML is when need to extracting metadata from huge essbase outlines (more than 500k members). Even so is a problematic operation since you need to…
Over 4 years ago
Hi how are you? I think the main difference between the older versions and the 12c is the GUI. Maybe for a new user the 12c is more friendly, but for me that works with odi since 10g, everything in the 12c takes 2 to 3 times more then in the older version. The 12c…
Over 4 years ago

Reviews

Oracle Planning and Budgeting Cloud Logo
Almost 4 years ago
Oracle Planning and Budgeting Cloud

Articles

Questions

Over 3 years ago
Data Integration Tools
Over 3 years ago
Data Integration Tools
About 1 year ago
Data Integration Tools

About me

Ricardo has been leading and developing EIS/EPM/BI/DSS applications for over 20 years including 10+ years of Hyperion-specific experience (the last 9 years in global projects to a fortune 100 client).
His core expertise is on design, development, and optimization of Business Intelligence systems using ODI to integrate, tuning and managing the entire environment, bringing the best of each EPM tools. He is certified in several EPM tools and is recognized for his expertise throughout the industry. In addition, he has personally executed several optimizations for his EPM clients: reducing the Hyperion cycle time in 95%. He has been involved in over 50 EPM/BI projects including big and complex implementation using multiple technologies like Planning, Essbase, ODI, OBIEE, PBCS, BICS and OWB.

Specialties: First Oracle ACE in BI track in Brazil, EPM/BI Trainer, regular EPM/BI instructor at Hyperion’s user conferences since 2013 on topics including optimization, integration, best practices, as well as several unclear technical topics. Strong technical background complimented by comprehensive practical knowledge of financial and accounting applications. Highly experienced in all phases of development including ETL, interface design, data analysis, data modeling, optimization, training, and project management in huge and complex environments (18 billion rows per month).

Known for develop innovative end-to-end solution because his deeply knowledge of all Oracle EPM/BI tools.

Interesting Projects and Accomplishments

Almost 5 years ago
Add new project
Earn 20 points