There are multiple ways to create Essbase applications in Oracle Analytics Cloud Service(OACS)- Essbase.
1. Importing application workbook in OACS.
2. Creating Cube with Tabular data.
3. Create a cube with Cube Designer.
Importing application workbook in OACS.
1. Open the oracle Analytics cloud URL.
2. When we want to create one new application, we need to select import
option to create application in essbase.
3. We can select files either from file browser,
catalog or data source.
4. After importing file from any of above sources.
We will get one application called Demo_Sample.
5. In above excel file contains: Essbase cube, Cube
Settings, Cube generations and about each dimensions settings.
We can change storage properties of each
dimension like either it is Sparse/Dense from excel sheet.
6. In cube settings, we can change either it is
BSO/ASO and we can create alias tables and we can set Dynamic Time Series and
attribute dimensions to the cube.
This is the way to generate application workbook with
OACS.
Creating cube with Tabular Data.
Tabular data can be used as a data source to create cube by extracting
fact table from a relational database into excel files and we use cube designer
to create cube.
1. Open essbase page and click on files option.
2. After click on files option we need to select
Gallery -Technical -Table Format.
In
table format select any one file to download.
Here I
selected sample_table.xlsx file to create a cube.
3. After selecting that file, again we need to open
applications option, from there we need to import file from file browser.
Follow
the same process, whatever we created steps to create application workbook in
essbase.
Create cube with Cube
Designer
Cube Designer
is one type of add-on in excel.
We use cube designer ribbon
helps us to design, perform tasks like loading data, editing formulas and
viewing jobs.
These are the cube designer
ribbon consists of options to perform.
1. First we need to click
on designer panel to create one new application workbook.
2. We can see under smart view, there is an Essbase
cloud cube designer.
We have tabs like cube,settings,dimensions, data and calc.
We
can create a new application or modify already existing application workbook in
essbase.
3. In cube tab, we need to provide dimensions and
database name to the new application by click on To Sheet option to generate
application through cube designer.
4. After the completion of creating application, we
need to build cube and connect with cloud services by providing link in excel.
5. We will check whether it is created in cloud
services.
6. The application created successfully in cloud
services.
This the process to create a cube
with cube designer.
There are multiple ways to create Essbase applications in Oracle Analytics Cloud Service(OACS)- Essbase.
1. Importing application workbook in OACS.
2. Creating Cube with Tabular data.
3. Create a cube with Cube Designer.
Importing application workbook in OACS.
1. Open the oracle Analytics cloud URL.
2. When we want to create one new application, we need to select import
option to create application in essbase.
3. We can select files either from file browser,
catalog or data source.
4. After importing file from any of above sources.
We will get one application called Demo_Sample.
5. In above excel file contains: Essbase cube, Cube
Settings, Cube generations and about each dimensions settings.
We can change storage properties of each
dimension like either it is Sparse/Dense from excel sheet.
6. In cube settings, we can change either it is
BSO/ASO and we can create alias tables and we can set Dynamic Time Series and
attribute dimensions to the cube.
This is the way to generate application workbook with
OACS.
Creating cube with Tabular Data.
Tabular data can be used as a data source to create cube by extracting
fact table from a relational database into excel files and we use cube designer
to create cube.
1. Open essbase page and click on files option.
2. After click on files option we need to select
Gallery -Technical -Table Format.
In
table format select any one file to download.
Here I
selected sample_table.xlsx file to create a cube.
3. After selecting that file, again we need to open
applications option, from there we need to import file from file browser.
Follow
the same process, whatever we created steps to create application workbook in
essbase.
Create cube with Cube
Designer
Cube Designer
is one type of add-on in excel.
We use cube designer ribbon
helps us to design, perform tasks like loading data, editing formulas and
viewing jobs.
These are the cube designer
ribbon consists of options to perform.
1. First we need to click
on designer panel to create one new application workbook.
2. We can see under smart view, there is an Essbase
cloud cube designer.
We have tabs like cube,settings,dimensions, data and calc.
We
can create a new application or modify already existing application workbook in
essbase.
3. In cube tab, we need to provide dimensions and
database name to the new application by click on To Sheet option to generate
application through cube designer.
4. After the completion of creating application, we
need to build cube and connect with cloud services by providing link in excel.
5. We will check whether it is created in cloud
services.
6. The application created successfully in cloud
services.
This the process to create a cube
with cube designer.
1. Importing application workbook in OACS.
2. Creating Cube with Tabular data.
3. Create a cube with Cube Designer.
Importing application workbook in OACS.