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

Filter out zero (0) values in MDX

I am looking to filter out zero values (0) from my MDX retrieve. I am querying Oracle's Essbase using the MDX below. Could someone help me with my MDX? There are no examples online and from my experience, MDX syntax and functions between Oracle and…
SSASYMan
  • 1
0
votes
0 answers

Essbase cloud otl file process

Hi I am newbie at Essbase I want to know what are the steps to import otl file on essbase cloud I have my otl file present in local drive . I am trying to import file from essbase database is that correct way to do .
akshit khugshal
  • 1
0
votes
1 answer

MDX - Query Attribute in the CrossJoin - Essbase

I currently have a CrossJoin working for UDA. However we want to change to using Attribute value instead. Not sure how to get the Syntax correct to use Attribute in the CrossJoin in Essbase. I commented out the UDA part which works great. However…
ElwayIsGod
  • 1
0
votes
3 answers

What are the options for extracting data out of Hyperion 7.3 with SSIS?

We need to get data out of some Hyperion cubes (databases) using SSIS. Are there any connection managers available for this? Has anyone done this?
Joe
0
votes
0 answers

unable to connect essbase from obiee 12c

I'm using obiee 12.2.1.3.0(in one machine) and essbase 11.2.5.0(another machine) and I have open rpd in online and when I try access essbase I'm getting the error as below screen shot Essbase server - is server machine name where essbase got…
Saranraj K
  • 412
  • 1
  • 7
  • 19
0
votes
1 answer

how to connect ESSBase cube with OBIEE 12 c

I'm using OBIEE version 12.2.1.4.0 and ESSBase version 11.1.2, when I'm trying connect the OBIEE with ESSBase cube I'm getting error below The connection has failed essbase error 0, and sometime I'm getting other error code like 46 Please find…
saran k
  • 307
  • 2
  • 14
0
votes
0 answers

How to suppress alert when refreshing Essbase/SmartView Table?

I'm trying to get past this alert. Using DisplayAlerts=False does not work.
iLL-Army
  • 41
  • 1
  • 8
0
votes
1 answer

PBCS: Custom rules to aggregate Period members

I have an input account (never share) in which the user types a parameter for each month, I want that into aggregate members of Period dimension, for example on YearTotal, the value will be the weighted average between two other accounts…
Daniele
  • 1
  • 2
0
votes
1 answer

Essbase Hyperion Add data inside Rule Files Bulk more than 100 rows

I already have a rule file (ex. Rule MM01), and I need to add more data rows in rule MM01 to one dimension like below. For example I want to add more 100 rows of data in column "Replace" and column "With" Do I have to add 100 rows one by one? Input…
kucluk
  • 540
  • 2
  • 9
  • 29
0
votes
0 answers

DOS CMD - Wait for Parallel MAXL Shell Scripts to Complete

I'm testing loading data to an Essbase Cube via a Load_Buffer. The goal here is to load data through in parallel and then commit the data. Currently, the fastest approach I've found is running the SQL load rule on it's own via MAXL. I've also tried…
Mike
  • 133
  • 1
  • 1
  • 13
0
votes
0 answers

Macro Essbase Retrieval

I am trying to write a macro that will retrieve a selected range without having to press the "Retrieve" button under the Essbase Add-In tab. I am getting no where with all the VBA codes I have tried. My code is currently as follows: Declare Function…
MikeS1818
  • 1
  • 1
0
votes
1 answer

Hyperion Essbase Script Means

I have script essbase calc from hyperion like this "ACTUAL" = ("ACTUAL" + ("ACTUAL"->"Labor_Hours"->"NA_CE"->"NA_CC"->"NA_ENTITY" * "ACTUAL"->"NA_PRODUCT")); i have no idea what that code means, because my cube result alwasy zero 0
kucluk
  • 540
  • 2
  • 9
  • 29
0
votes
1 answer

Passing a Run-Time Prompt from a PBCS Groovy Business Rule to a Parameter of an Invoked Business Rule (non-Groovy)

I was able to write a simple PBCS Groovy Business Rule to launch a PBCS non-Groovy Business Rule that didn't require any parameters. Now I have a requirement to pass run-time prompt member values (a user in an action menu will define some key…
smomotiu
  • 39
  • 6
0
votes
0 answers

TypeError: a bytes-like object is required, not 'str' (trying to connect to Essbase)

Hi I'm trying to connect to Essbase, and I'm getting an error. Any help in resolving this is appreciated. class Essbase: def __init__(self): self.user = None self.sid = None self.ssnInit = None self.numRows = None self.numFlds =…
Blue_Lion
  • 73
  • 8
0
votes
0 answers

TypeError: 'module' object is not callable - Essbase

I'm trying to directly connect to Essbase using Python. I can import Essbase, but I'm getting an error File "", line 702, in esss = Essbase.Essbase() TypeError: 'module' object is not…
Blue_Lion
  • 73
  • 8
1 2
3
…
8 9