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
8
votes
2 answers

Hyperion Essbase Connection in SSIS

How can I get SSIS to connect to an Oracle Hyperion Essbase cube to use it as a data source? Googling this returned the following: A similar question was asked about a specific version with no real answer other than "a third party tool can do…
Registered User
  • 8,079
  • 8
  • 44
  • 62
3
votes
1 answer

MDX filter problem

I'm pretty new to the whole MDX thing, but the following is just driving me batty. A FILTER statement I'm using is acting... strangely. Code sample, followed by description: SELECT { FILTER( MEMBERS([Time].[5-4-4 Week…
kyle
  • 1,453
  • 2
  • 15
  • 21
2
votes
1 answer

Oracle Hyperion planning function @Return not working as should

I am trying to use function @RETURN in the calculation script in Oracle planning. It should return error message "Please check this again" if "SGAseason" is 1, otherwise should give value 100 to "SGAseasonvalid". By now it returns error message in…
Jullis
  • 21
  • 1
1
vote
2 answers

Alternatives to Essbase

I have Essbase as the BI solution (for Predictive Analytics and Data Mining) in my current workplace. It's a really clunky tool, hard to configure and slow to use. We're looking at alternatives. Any pointers as to where I can start at? Is Microsoft…
Joseph
  • 1,951
  • 6
  • 19
  • 30
1
vote
1 answer

Unable to Access Hyperion Workspace in web App

I have installed Hyperion EPM in Oracle Linux 6.10. Database used is Oracle db 11gR2. Foundation services, Essbase and planning are installed and configured successfully. I run start.sh script to start all the EPM services. But still can not access…
Shashank Meshram
  • 15
  • 5
1
vote
0 answers

Exporting data from essbase through FDMEE

The main objective is to extract data from essbase through FDMEE. i have written a script called extract_data.scr and placed it in the FDMEE server. extract_data.scr: spool on to "G:\\LOGFILE_$3.log"; set column_width 200; /* to make spool file…
Md Neyaz
  • 11
  • 1
1
vote
0 answers

Can Smart View VBA HypConnect be used to connect to the application but not activate it on the sheet?

When using HypConnect in Excel, it automatically activates the connection to the sheet it happens to be on when the macro is run. However, if you choose Connect from the Smart View Panel, it connects to the application/database but does not…
Rose Glazewski
  • 11
  • 2
1
vote
0 answers

OSError when reading 0x000000000000000C (Maxl DLL)

I'm trying to connect to Essbase using Maxl DLL but I'm getting an error. I think this error has to do with ctype, but I'm quite not sure how to find the root cause and fix this. Any guidance will be appreciated. Using Maxl DLL in…
Blue_Lion
  • 63
  • 7
1
vote
1 answer

Allocation among 3 dimensions

Allocation by using calculation manager in PBCS. Dimension: -Account -Person -Project Allocate from: Account001 -> No Person -> No Project = 100; To: Account001 -> Person A -> Project I = 20; Account001 -> Person B -> Project II = 80; By…
vistanick
  • 11
  • 1
1
vote
1 answer

Convert a single column to a table based on first characters

I've recently started helping with reporting using Essbase/SmartView in Excel. I'm trying to take the Essbase report; which combines all levels of my Project hierarchy into a single column - and instead convert it into a table. It doesn't appear…
Matty Money
  • 13
  • 3
1
vote
1 answer

How to Refresh Excel Smart View Essbase using Macro

I'm using below code to refresh Essbase feeds in my workbook and it is working nicely, however, the only downfall is that I need to enter password every time I refresh the essbase as our Essbase system is highly secured. My question is, is it…
Naresh Abburi
  • 129
  • 2
  • 8
1
vote
1 answer

How can I configure email alert to check if an Essbase Application is running or not?

I want to develop a script which will check the state (running or not) of an Essbase application (say, every 15 mins.). If the Essbase application is not running then it will send an alert via email to user or application admin .
Amit
  • 11
  • 1
1
vote
1 answer

Migrating cube from Microsoft SQL Server Analysis Services (SSAS) to Oracle Hyperion Essbase

I'm looking for a tool or at the very least a tutorial that would ease the conversion/migration of a SSAS cube to a Oracle Essbase cube. I have researched in multiple different places and I can't seems to find any information regarding migration…
hmanolov
  • 113
  • 7
1
vote
0 answers

Convert Unicode file to ANSI using Bat file

I need to convert a unicode text file (19,000K) to an ANSI text file for use with Essbase. I currently have this written to convert the file but only the first 7800 lines are copying. This is what I have in my .bat file cmd /a /c TYPE…
Mike
  • 133
  • 1
  • 1
  • 11
1
vote
0 answers

Essbase OCI (Windows v. Linux)

I am working with Essbase installed on a Linux box. I am trying to use SQL and OCI to direct load into my cube. It fails and says that it cannot find libociei.so. Someone suggested that I download and install the Oracle Instant Client on my…
John
  • 11
  • 2
1
2 3 4 5 6 7 8