OBIEE 11g skills, both in terms of new functionality (mapping, analyses, KPIs and Scorecards etc) and new infrastructure (WebLogic, EM, OPSS etc)
A smattering of Essbase skills, focused mainly on the integration with OBIEE and Essbase (and the many workarounds and gotchas)
Good ODI skills, both in terms of the basics, but also being able to write knowledge modules, integrate with OBIEE, deployment and migration
Solid database skills – OBIEE gave the illusion through aggregates etc that database tuning was redundant, but time has shown it’s by far the biggest success factor in a project – get the database design and optimisation wrong, and your project is toast. You need to know partitioning, materialized views, index types, and increasingly, you need to get yourself on an Exadata project as customers are buying the technology but you can’t teach it to yourself at home
BI Apps skills, but watch out for everything changing when BI Apps 11g comes out, and be prepared to learn the Fusion Apps and JDeveloper if you want to stay in the game
Looking to the future, keep an eye on technologies such as in-memory (TimesTen), mid-tier caching (Coherence), plus technologies such as Business Activity Monitoring (BAM), “big data” (Hadoop, large data sets, NoSQL), complex event processing and maybe products such as Qlikview, just in case Oracle buys them, or at least to know what the competition are up to, or more importantly pitching to your boss
cezarovidiu on 15 Mar 13SELECT ev1.INVENTORY_ITEM_ID, ev1.ITEM_CODE ITEM, XXRG_HR_PKG.get_org_name(:ORG_ID) ORGANIZATION, ev1.DESCRIPTION, SUM(Buk11) buk11, SUM(Buk21) buk21 , SUM(Buk31) buk31 , SUM(Buk41) buk41, SUM(Buk51) buk51 FROM (SELECT ev1.INVENTORY_ITEM_ID, ITEM_CODE, DESCRIPTION, ( CASE WHEN age BETWEEN :BUK1_DAYS_FROM AND :BUK1_DAYS_TO THEN SUM(aqty) ELSE NULL END) Buk11, ( CASE WHEN age BETWEEN :BUK2_DAYS_FROM AND :BUK2_DAYS_TO THEN SUM(aqty) ELSE NULL END) Buk21, ( CASE WHEN age BETWEEN :BUK3_DAYS_FROM AND :BUK3_DAYS_TO THEN SUM(aqty) ELSE NULL END) Buk31, ( CASE WHEN age BETWEEN :BUK4_DAYS_FROM AND :BUK4_DAYS_TO THEN SUM(aqty) ELSE NULL END) Buk41, ( CASE WHEN age >= :BUK5_DAYS_FROM THEN SUM(aqty) ELSE NULL END) Buk51 FROM (SELECT ITEM_CODE, DESCRIPTION, TRANSACTION_DATE, TRANSACTION_QUANTITY, SUM(TRANSACTION_QUANTITY) OVER(PARTITION BY INVENTORY_ITEM_ID ORDER BY TRANSACTION_ID,TRANSACTION_DATE)+ NVL(NQTY,0) BFF , ( CASE WHEN TRANSACTION_QUANTITY > SUM(TRANSACTION_QUANTITY) OVER(PARTITION BY INVENTORY_ITEM_ID ORDER BY TRANSACTION_ID,TRANSACTION_DATE)+ NVL(NQTY,0) THEN SUM(TRANSACTION_QUANTITY) OVER(PARTITION BY INVENTORY_ITEM_ID ORDER BY TRANSACTION_ID,TRANSACTION_DATE) +NVL(NQTY,0) ELSE TRANSACTION_QUANTITY END) AQTY --,TCOST , NVL(fnd_conc_date.string_to_date(:TILL_DATE),SYSDATE)-fnd_conc_date.string_to_date(TRANSACTION_DATE) AGE, inventory_item_id FROM (SELECT V1.TRANSACTION_ID, V1.ITEM_CODE, V1.DESCRIPTION, TRUNC( CASE WHEN V1.TRANSACTION_TYPE_ID = 4