Wednesday, 17 June 2015

Essbasse File Types for Applications and Databases and File Extensions



File Extension       Description


bak
Backup of Security file. Essbase automatically creates a backup of the  security file before and after migration. 
 cfg
 Essbase Server Configuration file
 exe
 .exe is a file extension for an executable file format. 
 sec
 Security file. The Essbase security file is located in Arborpath/bin directory. The  content of essbase.sec is encrypted
 app
 Application file, defining the name and location of the application and other application settings. .app, .apb and application log file will be created once we create a new application.
 apb
 Back up of application file. .app, .apb and application log file will be created once we create a new application.
 arc
 Archive file
 csc
 Essbase Calculation Script. Scripts that define how to calculate data. 
 db
 Database file. .db, .dbb, .esm, .tct and .ind files are created once we create the database.
 dbb
 Back up of database file. .db, .dbb, .esm, .tct and .ind files are created once we create the database.
 esm
 Essbase kernel file that manages pointers to data blocks and contains control information used for database recovery. .db, .dbb, .esm, .tct and .ind files are created once we create the database.
 ind
 Essbase Index file.This file holds the pointers to the data available in Page files and this will be only one. .db, .dbb, .esm, .tct and .ind files are created once we create the database.
 log
 Server or application log
 lro
 LRO's are linked to a data cell - not to the data contained in the cell. 
 lst
 List of files to back up
 Mxl
 MaxL script file. MaxL is the scripting language for Essbase which is used to automate various tasks and functions. Some of the common actions that MaxL is used for are: Loading a database, Building dimension, Adding a user
 otg
 Ooutline change log
 otl
 Essbase Outline file. The structure in the outline determines how data is stored in the database. 
 pag
 Essbase database data (page) file. The  page file consists of data and each file size is 2GB. If the data file size is more than 2GB the system will creates another page file with capacity of 2GB and this process continue till the system able to accommodate the entire data. page file is not readable as it is compiled code.
 rep
 Essbase report script.Scripts that generate reports on data
 rule
 Essbase rules file. A rules files defines which build method to use. 
 tct
 Essbase database transaction control file that manages all commits of data and follows and maintains all transactions. .db, .dbb, .esm, .tct and .ind files are created once we create the database. 

  

Monday, 15 June 2015

Hyperion URL's - Worth noting


Thin Client:

http://servername:10080/easconsole/console.html 


Workspace:
http://servername:19000/workspace/index.jsp

Shared services:
http://SERVERNAME:19000/interop/
http://SERVERNAME:28080/interop

Planning:
http://servername:8300/HyperionPlanning/

The Essbase Agent manages Essbase Server. The Agent process starts and stops all applications and act as  the traffic coordinator for Essbase Server. 

Essbase Agent - 1423