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
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
  • 13
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
vote
1 answer

Macro for Essbase data retrieval

I am ultimately trying to automate/schedule a data retrieval from Essbase. I started with a macro that works perfectly. Sample code: Sheets("Sheet1").Select range("B1:b1").Select ActiveCell = j application.Run macro:="EssMenuVRetrieve" This macro…
Eddie O'Grady
  • 11
  • 1
  • 2
1
vote
1 answer

access 2010 convert "Jan" into 1/1/2014

I am using Access 2010 to transform some data from an Essbase pull in Excel. I want to be able to just copy and paste the raw data, then have Access change the date from a text of "Jan" to actual date format of 1/1/2014. Is there an easy way to do…
Lilac_Coder
  • 19
  • 5
1
vote
2 answers

Directly accessing data in Essbase

Is there any provision to access the physical data(in table format or something) from essbase directly?? We want to migrate data from Hyperion Essbase 9.3.1 to SAP SSM. Please help, if you have any idea about this. Regards, Sreenath
Sreenath Nair
  • 13
  • 5
1
vote
0 answers

Clear ASO region with dynamic members in Oracle Essbase

I have a problem in clearing a region in an Oracle ESSBASE ASO cube that returns in an error like: dynamic members are not allowed in data clear region specification when i try to execute this query alter database 'aso'.'db' clear data in region …
bidi
  • 150
  • 1
  • 14
1
vote
1 answer

what is the differnce between page file and index file in essbase?

what is the difference between .pag file and .ind file ? I know the page file contains actual data means data-blocks and cells and index file holds the pointer of data block i.e. available in page file. but is there any other difference ?regarding…
user1252398
  • 1,069
  • 7
  • 22
  • 29
0
votes
4 answers

what are the ASO and BSO , what is advantage to use these

what are ASO and BSO and difference between aggregated storage and block storage? when to use aggregated and when to use block storage technique.?
Aamir Zamir
  • 31
  • 1
  • 1
  • 6
0
votes
0 answers

Essbase Export Dimension Hierarchy into Column Format

In one of my Essbase cubes, I have a Dimension with a large hierarchy. It can go down to GEN 6 or 7. I need to have this hierarchy exported and converted into a table / column format. It should look like this: I have tried to export the dimension…
ste92
  • 434
  • 9
  • 23
0
votes
2 answers

Consuming Database Result Sets with Silverlight DataGrid

So I have a WCF Service that gets a result set from a database (not SQL) - I can get this data as a DataTable, string[][], etc. I can't use LINQ or ADO.NET Entity Framework very easily as it's not coming from an SQL DB. So my question is: What's…
Paul
0
votes
0 answers

I scheduled a task in task scheduler. How can I enable macro through windows command script/ cmd ? I already enabled macros in trustworthy

I have created a task in task scheduler which starts a program "xyz.cmd" in 'd' folder. This .cmd needs to start excel .Xlsm file. When I'm running it manually it is running fine. But through task scheduler it's not working.. there is no mistake…
Vinay Guruju
  • 1
0
votes
0 answers

Connection to Impala from Essbase via ODBC fail

I am trying to fetch data from a table in Impala and loading into an Essbase cube. A Cloudera ODBC driver is set up and successfully working (64 bit and Version 2.6.0) Kerberos is also installed and in usage. But when trying to fetch data via…
ste92
  • 434
  • 9
  • 23
0
votes
0 answers

Oracle Hyperion, Business Rule(Calc Manager) for copy data from BSO to BSO?

As I want to copy data from BSO(Custom Cube) to BSO(Module based cube) in ORACLE HYPERION. I know the logic but do not know the syntax to write that logic. What Level of Generation should be fix? Thanks in Advance. Previous approach was copying data…
Dhruv Shah
  • 1
  • 1
0
votes
0 answers

HFM Extract data to file is resulting in Parent Child error

I am trying to do a simple extract in HFM and I keep getting this error. "Parent-Child name must be specified for Entity dimension due to value: [Parent Total] Member found that requires parent name:" All the members in the extract are valid…
Ryan
  • 1
  • 1
0
votes
0 answers

VBA Macro to drill down into dimension member

I am trying to create a macro to simulate drilling down into a dimension member (Time), this is off of an excel plugin to assist with finance stuff. Currently, when you Highlight the Time Dimension (A12) and click Zoom In it will display all years…
A1367
  • 1
1
2
3
…
8 9