Oracle Fusion Smart View
This course will teach you the steps to install, configure and build ad-hoc reports quickly. Once you have an understanding of the basic reporting capabilities we will build more complex reports. By building reports in Excel, you have the benefit of a familiar application complemented by the security of the database to enable you to quickly build reports.
Benefits to you…
After this course you will have the skills and knowledge to utilise Smart Query and Query Designer to build personalised reports with interactive components. Consultants with implementation and report design experience will teach you how best practice.
Introduction to Smart View
- Connecting to Data Sources
- Smart View Excel User Interface
- Smart View Architecture
Creating Ad Hoc Analysis Reports
- Associating Data Sources with Worksheets
- Creating Member Selections
- Working with the Essbase Ribbon
Setting Smart View Options
- Setting Number and Cell Formatting Options
- Setting Administrative Options
- Setting Data Navigation and Retrieval Options
Creating Advanced Reports
- Retrieving Data for Attribute Dimensions
- Working with Excel Formulas
- Creating Queries using Query Designer
- Creating a Smart Query
- Creating Reports with Smart Slices
- Using Query Designer and Smart Query
- Define the database outline hierarchy and multidimensional analysis
- Build advanced reports and ad hoc queries in Smart View
- Insert dynamic data points within Microsoft Office documents
- Set Smart View Options
- Build reports with smart slices
- End User
Get in touch
If you would like to find out how we can help you, please get in touch.
+44 (0)20 3900 1186
Book a meeting
We offer free consultation if you’re keen to find out what course fits the best for you. Use the link below to schedule a meeting with us.
Book a meeting
Convince your boss
Hear it first hand
What do our customers think of our training?
Fudgelearn focus on the quality of relationships with customers and look to work in Partnership to help achieve the desired outcomes. They’ve proven flexible in meeting our requirements and extremely responsive in managing the service they provide. For example, one of their Account Managers has come onsite on a regular basis to provide support and guidance for members of my department to ensure we’re getting the most from the service.
John Lewis Partnership
We have had the pleasure of working with Fudgelearn on a series of training webinars to support the global rollout of Oracle Fusion. Not only has Fudgelearn been professional, committed and a valued partner in supporting the educational rollout of our material to the business but their instructor has also gone above and beyond to help us resolve unforeseen issues.
Global Head of Talent Acquisition & Change Management Lead
UDG Healthcare PLC
I found the Fudgelearn Account Manager to be very knowledgeable and was able to offer the correct package to meet my needs and wider career goals.
I left my one-to-one feeling enthused to undertake my tailored training plan.
Without Fudgelearn’s direction, I feel I would still be wandering around in the darkness!
Videos and documentation was good, and helpful for future reference.
Very helpful training session lead by Melanie!
Good mix of demos and practical work - looking forward to the next session!
The trainer interacted and dealt with questions really well.
The course was very detailed and informative - thank you!
Enjoyed the guided learning & exercises after each section.
Dipping my toe into the new system was a great learning experience.
Michael is very knowledgeable, patient and friendly - he has had the answers to all the questions asked, so it is obvious he knows his stuff inside out.
Definetely an expert in his field, and very confident with his level of knowledge.
Michael was very knowledgeable, and will be a good resource to tap into when we start to write reports in earnest.
Did very well, with beginners to more experienced students attending.
Now I have a better knowledge of the workflow between the BANK and CASH MANAGEMENT which is great!
I can now navigate in Receivables, navigate in the schedule processes screen, create a receipt, apply a receipt, reverse a receipt, all great information!
Great to know how to create invoices, how AP works in Oscar and to manage payments and reporting.
I now have a further understanding of FA itself, how to navigate and perform FA required tasks.