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
0 answers

reading variables from text file in MaxL

SET USER=3092870062612032450309212768828033911960 SET PW= 11924680696448007706606097772500386367703037421296151222544191726011595198996750 FOR /f "eol=; tokens=1,2 delims=, " %%i in D:\Hyperion\Automation\MaxL\subvar.var do echo alter database…
ajay k
  • 59
  • 6
0
votes
1 answer

Clarifying Essbase @Relative and @Parentval

I am new to Essbase, it would be very kind of someone to help me understand this script that I see. I have the following outline: Outline: XXX Product A P1 xx1 xx2 …
user1612986
  • 1,373
  • 3
  • 22
  • 38
0
votes
0 answers

Implementing ESSBASE script in Excel smart view

I have a script which looks like this fix ("A",@relative("B",0),@relative("C",0)) "GP" = @Parentval(Product,"GP") * "V"; endfix I am trying to understand and analyze how this script is working in…
user1612986
  • 1,373
  • 3
  • 22
  • 38
0
votes
0 answers

ESSBASE @FIX statement

I am trying to learn essbase scripting on my own and came across the following parts in a big script. fix ("Stock Alloc %"); @idescendants("Company A"); endfix; I think this part is doing nothing because fix ("Stock Alloc %") is…
user1612986
  • 1,373
  • 3
  • 22
  • 38
0
votes
0 answers

JavaFX 8 Progress Bar Update from Calculation Script Class

I am having a hell of a time trying to get this progress bar in JavaFX 8 to work. I know I probably should be using a Task to Update Progress but I haven't been able to get it to work. I removed the server API specific code and just kept the GUI,…
Jonathan Smith
  • 13
  • 4
0
votes
1 answer

What kind of language is used to develop Oracle's Smart View

It is a very complex Excel add-on. I am wondering if all the functionalities are built using C#, C++, or Visual Basic? The typical interface is shown below:
lovechillcool
  • 762
  • 2
  • 10
  • 32
0
votes
1 answer

VBA code to disconnect from Essbase Connection

I tried writing the VBA to connect yo Hyperion Essbase to connect to multiple sheets and the connection is successful X = EssVConnect("[Macro.xls] Sheet1, sheet2,sheet3 ", "Uname", "Pwd", "Server", "Applicationname", "DB") If X = 0 Then …
Rajyalakshmi Gangisetty
  • 53
  • 5
  • 18
0
votes
1 answer

How to get Hyperion Smart View For Office Version add-in?

Can you get the version of Hyperion SmartView installed using visual basic code for excel ? I need to get a string output with the version number or something that looks like this -> 11.1.2.2.000 regards
messinese90
  • 11
  • 1
  • 5
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
  • 1
  • 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
  • 31
  • 7
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
  • 191
  • 1
  • 3
  • 13
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
  • 27,099
  • 5
  • 37
  • 72
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
1 2 3
…
8 9