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

Member deletion in essbase

I am not able to delete a dimension member in hyperion planning .The error is this Deletion of member "S104" failed (member might be referenced elsewhere in application).
Prafull Rajput
  • 1
  • 1
0
votes
1 answer

Incremental data load in ASO cube

I am using an ASO cube. We have two types of loads, Full Load and Incremental load. We are performing Full Load once in a day by clearing the cube and reload it. We need to run Incremental load in every 2 hours. I have aggregated data by running…
Rahul Jaiswal
  • 5
  • 1
0
votes
1 answer

Essbase MDX queries not matching

I am using a BI tool that auto-generates MDX code for an Essbase data source. I am running two queries that should bring back the same numbers, but I get different numbers. The first query brings back results by month for 12 months of the year and…
tha0685
  • 1
0
votes
1 answer

ODI Log and Error files are empty

Hi I am trying to load data using ODI where my source is flat files and target is Hyperion Essbase but it is getting failed and if I try to see the ODI Log and Error files they are empty. Can anyone help me regarding this issue. Thanks in advance.
Komal
  • 1
0
votes
1 answer

How to export multiple months into RDBMS from Essbase and not have it stored as separate columns

I'm currently working on a script to export a BSO essbase cube into a RDBMS and running into issues with the export. Whenever I select May and Jun together it comes in as 2 different columns instead of just 1 column called ESS_PERIOD. Does anyone…
js1229
  • 25
  • 4
0
votes
0 answers

Essbase Report Script - Issues with Calculated Column

I have written an Essbase Report Script to retrieve data from Essbase. The report script also contains a calculated column. The output of this Essbase Report Script only displays the calculated column's header and does not display any values in the…
Ashish Bhavnani
  • 1
0
votes
1 answer

Why are level 0 members tagged as never share

I am a fresher learning essbase and Hyperion, in one of project there was a outline in essbase where level 0 members were tagged as never share, I just don't understand why they are tagged as never share when they don't have children under them…
Manish Sakpal
  • 299
  • 1
  • 9
0
votes
1 answer

How to create and assign access to a user via Maxl?

Hyperion shared services is not working properly so how can I create and assign an LDAP user access to cubes?
user2373210
  • 461
  • 2
  • 5
  • 16
0
votes
1 answer

Smartview/Essbase VBA function not returning Member information

I am attempting to place the hyperion/Essbase parent name next to the child member using the GetHypParent() function but my code below places a 0 (meaning a succesful function?) in column K vs the parent name its self. How (or is there a way) that i…
Omar Castillo
  • 27
  • 1
  • 1
0
votes
1 answer

Essbase Error 1242021- while executing Maxl to run a report script

I am running a Maxl to export database using report script, below is the Maxl: spool stdout on to "$4Adhoc.mxl.log"; spool stderr on to "$9Adhoc.mxl.err"; alter system load application $5; alter application $5 load database $6 export database…
P.J
  • 29
  • 8
0
votes
0 answers

Adding Dummy/Blank Member to Report Script in Essbase

Right off the bat, I'll say I'm new to essbase and am far from an expert on report scripts so I'm sure I'm messing up the terminology here, so let me know and I can edit the post. I'm creating 2 simple report scripts that pull from separate…
Malcolm Carey
  • 23
  • 7
0
votes
0 answers

OBIEE advanced SQL filter

Good morning! What would be the best way to filter an analysis off of an Essbase subject area based on the value of a prompted presentation variable? For example, if the user selects the "Widgets" parent entity it would display its direct children…
Brett Moore
  • 23
  • 4
0
votes
1 answer

OBIEE time dimension against Essbase

Good morning! I'm connecting to an Essbase cube that has a Years dimension (FY16,FY17,etc) and a Period dimension (YearTotal, Quarters, Months). Is there any way to make a time dimension out of these two separate dimensions? I want to be able to use…
Brett Moore
  • 23
  • 4
0
votes
1 answer

Metadata filter in Essbase not working

I have a BSO cube and it's Org hierarchy is set like below: Org: totalUS US US retail Us non retail A1 B1 C1 D1 D_001 the user group should only see data for @IDescendants(US non…
P.J
  • 29
  • 8
0
votes
1 answer

Connect to Hyperion Essbase using REST Api

How can we connect to ESSBASE using REST? How can we retrieve data from cubes?
saurav
  • 427
  • 4
  • 14
1 2 3
…
8 9