Questions tagged [hyperion]

Hyperion is a set of performance management applications purchased by Oracle in 2007.

Oracle Hyperion Enteprise Performance Management is a set of applications that was previously the product of Hyperion Solutions Corporation. It was acquired by Oracle in 2007 and it has been a part of the Oracle Business Intelligence products.

The list of applications is large (20 as per the Oracle page in 2013) and covers the following areas.

  • Strategy Management
  • Planning, Budgeting and Forecasting
  • Financial Close and Reporting
  • Profitability and Cost Management

Old products included, among several others:

  • Hyperion Intelligence and Intelligence Explorer
  • Hyperion Smart View
  • Hyperion Solutions Enterprise
  • Hyperion Reporting
130 questions
0
votes
0 answers

Hyperion-rt Python Package OSError

I need to use the hyperion package for python (http://docs.hyperion-rt.org/en/stable/index.html, the three-dimensional dust continuum Monte-Carlo radiative transfer code, not the hyperion by Oracle!). I installed it and already solved the known…
Keks
  • 37
  • 8
0
votes
0 answers

Oracle Hyperion Planning Data Testing - Automation

In our project we have a need to automate Oracle Hyperion Planning Data Testing. Currently it is functional and data-heavy testing on Excel (for Hyperion Planning Data). Team is looking for an automated way to achieve this testing , any suggestions.
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
1 answer

Data Visualization Extension: Hyperion Data Adaptor (Type Error: Cannot read properties of undefined (reading 'forEach'))

in process of Data Visualization Extension, I made my dataset for sensors and adapted it to my Revit model. Also I used (Setting Up a SQLite Data…
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…
0
votes
0 answers

Is it possible to build a script in Hyperion that autologs required credentials into the ODS(sql database) when the queries are run?

It will be painfully obvious I'm new to the space so apologies in advance for lack of code/maybe even understanding. I'm using Oracle Hyperion financial reporting software and connecting to the ODS regularly to get data updated and am tired of…
0
votes
3 answers

Getting the week number from a Timestamp in SQL

I have a field which displays a timestamp 'mm/dd/yyyy hh:mi:ss'. I am trying to extract the Isoweek number from this field unsuccessfully receiving a variant of error messages depending on the formula I have used. Hi, I hope someone can assist. I am…
MBrann
  • 223
  • 5
  • 23
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
1 answer

HypRetrieve not retrieving correct status code

Background I have two databases that I need to connect to. One is in Hyperion and the other one is in ESS. I have imported the smartview.bas as stated by the documentation and I am attempting to use the functions within it. I have dummy sheets…
Sgdva
  • 2,800
  • 3
  • 17
  • 28
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

GET request from NetSuite to Oracle EPM, but faced with "Authorization Required - You are not authorized to access the requested resource

Error: "Authorization Required - You are not authorized to access the requested resource. Check the supplied credentials (e.g., username and password)." Using the same exact headers and URL, I am successfully able to make the request get through via…
0
votes
1 answer

Using Pingfederate as an SP and Okta as IDP

So I'm tasked with enabling SSO for a client's Oracle Hyperion Application. The Approach I'm going with is Custom header Variable based SSO. PingFederate Currently exists as the SSO Authentication Server for many applications and the plan is to use…
0
votes
1 answer

Hyperion Error : EPMHFM-66024 - No Port is available from the port range configured by the user: 10001- 10020

Installed Hyperion 11.2, and after a few days started to get the following message: EPMHFM-66024 - No Port is available from the port range configured by the user: 10001- 10020. Is there a setting that I need to update / missed. Thanks
GrahamD
  • 1
  • 1
0
votes
1 answer

Oracle EPM Hyperion 11.2 - Java API Class LoadExtractOM Method loadData not working

I have developed 3 web services ( jax-rs) using the Hyperion Java API's in 11.1.2.4 i. Logon ii. Get Metadata iii. Load data into HFM All work in 11.1.2.4 environment. When testing them in the 11.2 environment I came across an issue with the the…
GrahamD
  • 1
  • 1
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
1 2
3
8 9