1. Take the Oracle Training Course--this can be helpful in getting an initial idea of how things work, but if you don't use these skills then you will lose them.
2. Contextual Learning--Learn by doing. By working on a project with seasoned developers you can start to learn why they are doing things.
3. Take a business course if you're too technical--you will need to understand how businesses work, and specifically the business where you are working.
4. Buy the latest version of Edward Roske's book, now they are on version 11.
5. Build an experimental cube, and go through all the pieces that you will need to know. Data Loading, Outline building, Calc scripts, filters, Temporary Variables, etc.