Friday, July 12, 2019

Essbase Application types in OACS

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.



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.