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

Extract data from oracle hyperion essbase

How can I extract data from oracle hyperion essbase with command via vpn client ?
Amal Koubaa
  • 1
  • 2
0
votes
0 answers

Excel VBA Smartview/Essbase Connection Issue

I use th efollowing 2 lines of code to create a connection to my Essbase Cube and then to connect to it. This works on my pc, but not on others. Any ideas as to what the issue is. x = HypCreateConnection(Empty, "Richard Scott", "Essbase2",…
user7646859
0
votes
1 answer

Substitution variable in Essbase script

I´m trying use a substitution variable for parametrize my private Key. I have created the substituion variable with the name 'privateKey'. RUNJAVA com.hyperion.calcmgr.common.cdf.MaxLScriptFunction "-D" "123456.1234567" /* Private key */ "" "login…
laggc
  • 1
  • 2
0
votes
0 answers

Essbase Location change using disk volume-Hyperion

I'm looking to change the application database backup from one volume(say /v02/) to vol4 using maxl command. i tried the below commands but i could the backup artifacts under the vol4. anyone please help me.. commands i tried: alter database…
s jobmail
  • 1
  • 1
0
votes
0 answers

Essbase dataload error

I'm on a Windows 10 box using Oracle Essbase Admin Services console 11.1.2.4. When I load data I get an error. My problem is that the dataload.err file will not write to my c:\ drive or any network drive to which I have access. If I manually create…
Joe B.
  • 11
  • 3
0
votes
1 answer

ESSEXCLN.XXL file not found

I am trying to create a macro that connects me to Essbase at the push of a button and am using the syntax found here https://docs.oracle.com/cd/E12825_01/epm.111/esb_client.pdf I keep getting the error message that Essexcln.xll is not found. Is…
TonyP
  • 333
  • 2
  • 4
  • 19
0
votes
1 answer

Load data from Essbase into SQL database

I'm currently using a mix of smart view and power query(sql) to load data into Excel models however my excel always crashes when smart view is used. I'm required to work in Excel but I'm know looking at finding a way to periodically load data from…
obabs
  • 8,671
  • 4
  • 12
  • 17
0
votes
2 answers

Separating data set by how many spaces are before first letter

I have a huge data set that I need to separate into a hierarchy. Currently the only way to tell which level the data point is in the hierarchy is how many spaces are before the first letter (It is from an Essbase pull). I need to separate it out…
TonyP
  • 333
  • 2
  • 4
  • 19
0
votes
1 answer

What is the difference between ESSBASE and ESSBASE server?

What is the difference between essbase and essbase server in layman,s term? I am not able to understand the difference, neither can i find it on internet. Help
saurav
  • 427
  • 4
  • 14
0
votes
1 answer

Copy a file using .mshs script

I am trying to copy a file, export.txt from one directory to another within a .mshs script. I currently have: shell copy 'E:\RPTG\Export.txt' 'E:\FCST\'; I'm getting an error that says "end of file breaks the statement." Is there a command to copy…
Andrew Zahn
  • 21
  • 6
0
votes
1 answer

delete data in aso cube

I have been trying to delete data from aso application using maxl script, user wants data to be reloaded in 2015 again so I have been trying to delete it for only December month to see whether it works or not alter database 'BFCVASOb'.'BFCVASOb'…
98745
  • 1
  • 2
0
votes
1 answer

Is it possible to create dynamic drop-down boxes in Hyperion Planning forms

I'm working on my first sandbox Hyperion planning application and I'm curious if its possible to create dynamic drop-down boxes in planning forms. For example, if a form requires the planner to select a Team/Cost Center, Company and Currency would…
Mutuelinvestor
  • 3,384
  • 10
  • 44
  • 75
0
votes
1 answer

Unable to obtain a connection to Hyperion Essbase

Problem: Whenever I do a database refresh in Hyperion Planning it hangs in the 21st step and produces the following error. Could anyone please say why this issue causes and the way to resolve it ? Great Help. Thanks.
Du-Lacoste
  • 11,530
  • 2
  • 71
  • 51
0
votes
1 answer

Trigering Essbase Macro with C#

I'm trying to automatize some Excel reports. Currently I need to retrieve some data from an Essbase Server, in order to achieve this I've created a macro to retrieve and set data in an Excel sheet, my VBA code is the following: Option…
user1998791
  • 58
  • 5
0
votes
1 answer

Report Script formatting in essbase

Iam in the process of creating a report script from ASO cube. I am able to get the necessary contents on the report and finding it difficult to get in the required format. //ESS_LOCALE…
ajay k
  • 59
  • 6
1 2 3
…
8 9