Stack Overflow
Stack Overflow

Questions tagged [essbase]

Oracle (or Hyperion) Essbase is one of Oracle Corporation's Multidimensional database products. Data is stored and analyzed in OLAP cubes. It includes a calc script language as well as a data access/integration API.

Essbase stands for the "Extended Spreadsheet Database", and is often used for financial, accounting, and planning applications, going so far as including a MS Excel plug-in for data retrieval and writeback. It includes a "calc script" language allowing for complex formulas and allocations.

Essbase cubes fall into one of two categories - BSO (Block Storage), or ASO (Aggregate Storage). BSO cubes tend to be smaller and allow more writeback and custom calculation scripts, whereas ASO cubes are optimized for large amounts of data and somewhat simpler calculation possibilities.

The Essbase Database Administrator's Guide, is useful for developers integrating systems into Essbase and building cubes.

Essbase commonly is used closely with Oracle Hyperion Performance Management / Hyperion Planning, and a in-memory parallel version of the MDBMS is part of Oracle Exalytics.

122 questions
0
votes
1 answer

XML/A error response: what is the standard?

I maintain a library that provides XML/A access trhough javascript: https://github.com/rpbouman/xmla4js Mostly it works ok, but I would like to improve handling of error responses. As far as I understand the XML/A spec corectly, error responses take…
Roland Bouman
  • 31,125
  • 6
  • 66
  • 67
0
votes
1 answer

Recover Essbase data

User has accidentally deleted Essbase application from the EAS Console. An application with the same name was created. We then used Hyperion Planning to recreate the database of the new application. We have file system backup of all the directories…
user2602330
  • 3
  • 2
0
votes
1 answer

essbase: How can i export without double quotes in data files using dataexport commands in MaxL?

i am exporting data from Essbase cubes using MAXL SET DATAEXPORT commands. But data file consists of double quotes to members.! How can i export without double quotes in data files using dataexport commands in MaxL?
Esa Basha
  • 1
0
votes
1 answer

Can I update data in Essbase using Excel add-In/smart view

Can i insert new data/update the existing data into Essbase using Excel add-In/Smart view like I update the data into Palo Multidimentional database? regards, Sri.
Developer
  • 309
  • 5
  • 8
  • 19
0
votes
2 answers

What is the purpose of MaxL in Hyperion?

I am new to Essbase. Here I am creating an Application by using Essbase Administration Services (EAS), Planning and Workspace. If I am able to create and manage an application using the above services alone, then what are the additional features…
user1252398
  • 1,069
  • 7
  • 22
  • 29
0
votes
1 answer

where the exchange rate table is stored in essbase?

I am new in hyperion planning , doing some assignments with currency conversion and exchange rate table. I have created currency conversion application in planning and also create a exchange rate table in Planning.Both are stored in…
user1252398
  • 1,069
  • 7
  • 22
  • 29
0
votes
1 answer

Hyperion Essbase 11.1.2.2 Unable to connect to Essbase Administrator Server from the Essbase Admin Console

So I'm a newbie at Essbase - I've installed the EPM system - the Essbase admin services are up and running but for some reason, I'm not able to connect to the Admin Server through the EAS console. I get this error - "Could not connect to…
user1565887
  • 1
  • 1
  • 2
0
votes
2 answers

How to attached calculation script to data-form in hyperion planning

I am new to Hyperion going through small assignments. I have created the data form in Hyperion planning it's working fine. Now I have to attached calc script (calculation script) to my data form. Is it possible to attach the calc script to data form…
user1252398
  • 1,069
  • 7
  • 22
  • 29
0
votes
3 answers

sparse and dense in hyperion

I am new to Hyperion Essbase. What is the difference between a SPARSE and DENSE Dimension? Is there any documentation that could help me with this?
user1252398
  • 1,069
  • 7
  • 22
  • 29
0
votes
1 answer

How to supress zoom out behaviour from Essbase while retrieving data?

I have written some code to extract data from Essbase. Before retrieving the data I Zoom In on one of the cell and then run the code to retrieve data. However, after successfully retrieving the data it zoom out to show only top generation. How can I…
user1042327
  • 377
  • 1
  • 7
  • 17
0
votes
1 answer

Calculate database size in Oracle Essbase

Classical question at tests: I have 4 dimensions: Markets: Sparse, 10 stored members, 10 total members Products: Sparse, 5 stored members, 7 total members Accounts: Dense , 10 stored members, 11 total members Time : Dense, 5 stored, 12 total What is…
David Kakauridze
  • 305
  • 4
  • 11
  • 23
-1
votes
1 answer

Substring in Calc script Essbase

I am trying to get the First 3 characters from Accounts dimension in Essbase (BSO cube). When i try to execute the below query. I am getting an error "Invalid Object type" FIX( @substring(@NAME("Account"),0,3), "Jan" ) ENDFIX
Raghav
  • 53
  • 2
-1
votes
3 answers

Data Export in Essbase

I took data Export of a database and the export should be saved in the according app or essbase server. The problem here is I am unable to find the extracted data. Somewhere they must have been stored. Since I could execute those calculations but…
Sai Roja Gudla
  • 1
  • 1
-1
votes
1 answer

Essbase Error 1241109 Unable to Open file

I am automating the process to run a report script. The batch script is located on Windows and the Essbase server is on UNIX. Getting an error while executing the below statement export database App.DB using server_file 'Report1.rep' to data_file…
SQL_Rookie
  • 3
  • 3
-1
votes
1 answer

How do you set a requirement or rule over a set of rows where there is already data on excel?

I have an excel sheet that has data extracted from Hyperion Essbase. I'd like to put a sort of rounding rule on that data without removing the numbers generated from Essbase. For example, in a cell there's the value $13.5232, I'd like to set a rule…
Piper Ramirez
  • 373
  • 1
  • 3
  • 11
1 2 3
…
8
9