|
0%
|
Let's Get StartedScenario: Your manager has sent you a large table of data from your relational BI system (20 columns and 36,000 rows), and asked you to make this data useful! You do this by quickly creating a new Essbase Cloud application to allow you to easily sift through the large data set to analyze trends and get a hold on the quarterly Profits and Loss.Setup Assumptions: You’ve installed the Smart View add-in for Excel with the new Cube Designer ribbon, and opened the provided worksheet from your manager.Objective 1: Design a custom cloud Essbase application directly from a table of dataObjective 2: Utilize your new cube to analyze financial data for Computer products in the Q1-Q4 rangeBegin Objective #1
Objective 1: Design a custom cloud Essbase application directly from a table of data
Great Job!Now that your new Cube has been created, let’s put it into action to create a useful analysis.Objective 1: Design a custom cloud Essbase application directly from a table of dataObjective 2: Utilize your new cube to analyze financial data for Computer products in the Q1-Q4 rangeBegin Objective #2
Objective 2: Utilize your new cube to analyze financial data for Computer products in the Q1-Q4 range
Nicely Done!Objective 1: Design a custom cloud Essbase application directly from a table of dataObjective 2: Utilize your new cube to analyze financial data for Computer products in the Q1-Q4 rangeNext Steps: Now that you’re a cube-building pro, get Oracle Essbase Cloud and Smart View to start wrangling your own data, or move on to the next episode of Essbase simulation: “’What If’ Scenario Modeling with Essbase Cloud.”Get Essbase for Excel
or
|
From this starting table of data, create a Cube with custom naming.
Click the "Cube Designer" ribbon
Click the "Cube Designer" ribbon
Create Cube with custom naming.
Click "Transform Data" button
Click "Transform Data" button
Create Cube with custom naming.
Click and type a custom Application Name (example: VisionScratch) and press Enter to finish
Click and type a custom Application Name (example: VisionScratch) and press Enter to finish
Create Cube with custom naming.
Click and type a custom Cube Name (example: Simple) and press Enter to finish
Click and type a custom Cube Name (example: Simple) and press Enter to finish
Create Cube with custom naming.
Click to uncheck 'Modifications' box to see the dimensions and hierarchies it will design
Click to uncheck 'Modifications' box to see the dimensions and hierarchies it will design
