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.

114 questions
0
votes
1 answer

SSRS Connection Properties for Hyperion Essbase

I use the Excel Add-Ins feature to do pulls from Essbase. Logging in through Excel I have my Server, Application and Database. When trying to set up a data source via SSRS I have to enter Server Name, Analytic Server to Use and Application Name. Is…
Nick
  • 1
  • 1
0
votes
3 answers

Essbase Java API export database MAXL

I've been having trouble running the MaxL "export database" command with the Java API. I've tried using code like this:( Referred to Essbase Java API Sample com.essbase.test.ExecuteMaxl.java) IEssMaxlSession test =…
Chandan C
  • 138
  • 11
0
votes
1 answer

Can't get data from Essbase

I'm new at OLAP services. I want to get data from Essbase using olap4j. I'm sending this request: SELECT {[Year].[Jan]} on COLUMNS from [Demo.Basic] and get an error that database Basic does not exist: XMLA provider gave exception:…
vdj TAB
  • 21
  • 6
0
votes
2 answers

Essbase System Login

I'm new to the Hyperion Essbase and I'm using "Hyp 6.5". Whenever I login to the Excel it shows "Essbase System Login screen". So each time I've to enter Server Name User Name Password Application/Database Is it possible to set those values as…
user2782522
  • 139
  • 1
  • 3
  • 11
0
votes
0 answers

Tableau Forecast reports

How to process Forecast reports in tableau from Multidimensional Data Source(Oracle Essbase) ? I have a Time dimension consisting of Year,Month,Quarter and date. I am trying to build a forecast report using year and Sales amount,but the forecast…
Addy
  • 11
  • 1
  • 5
0
votes
2 answers

Excel VBA Essbase ZoomIn

I am using the EssVZoomIn Function to zoom in on a dataset in Essbase. The function works in the sense that it zooms in, but it also removes the account dimension row out of the dataset when I run the code. So When I zoom in manually on the same…
Scott Holtzman
  • 26,571
  • 5
  • 31
  • 62
0
votes
1 answer

Hyperion RDBMS Table

As we know details of every job are stored in rdbms in table Hsp_Job_Status. But unfortunately this table gets truncated each time we re-start services. As per business requirement we needed to keep a record of BR's launched by user and it's…
user3349587
  • 1
  • 1
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
  • 28,589
  • 6
  • 63
  • 64
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
  • 239
  • 4
  • 7
  • 16
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
  • 909
  • 6
  • 19
  • 28
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
  • 909
  • 6
  • 19
  • 28
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
  • 909
  • 6
  • 19
  • 28
1 2 3 4 5 6
7
8