Stack Overflow
Stack Overflow

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
1 answer

Load data from Essbase into SQL database

I'm currently using a mix of smart view and power query(sql) to load data into Excel models however my excel always crashes when smart view is used. I'm required to work in Excel but I'm know looking at finding a way to periodically load data from…
obabs
  • 8,671
  • 4
  • 12
  • 17
0
votes
1 answer

Hyperion Reporting - Query for prior day (DB2 and Oracle)

I am using Hyperion Reporting Studio. I have a report where I want to calculate the turn around time for messages that come in to my department. I need to find a way, whether it's custom SQL or just a feature for the report to always pull the data…
user4816679
0
votes
2 answers

How To Trim Date from Date-Time Stamp - Hyperion

I am using Hyperion Reporting Studio with Oracle and DB2 databases. We have fields that have an open date and a close date on them, so naturally the format would be 6/02/16 06:18:05 PM for either the open or close date fields. Is there a way to trim…
Joe
  • 31
  • 1
  • 8
0
votes
1 answer

Configuring Hyperion Shared Services

We have configured Oracle Hyperion Essbase with OBIEE on 9704 port. Now , we need to implement security using shared services rather than using weblogic.How can we proceed?
manisha
  • 1
  • 1
0
votes
1 answer

Copy a file using .mshs script

I am trying to copy a file, export.txt from one directory to another within a .mshs script. I currently have: shell copy 'E:\RPTG\Export.txt' 'E:\FCST\'; I'm getting an error that says "end of file breaks the statement." Is there a command to copy…
Andrew Zahn
  • 21
  • 6
0
votes
1 answer

delete data in aso cube

I have been trying to delete data from aso application using maxl script, user wants data to be reloaded in 2015 again so I have been trying to delete it for only December month to see whether it works or not alter database 'BFCVASOb'.'BFCVASOb'…
98745
  • 1
  • 2
0
votes
2 answers

Updating an imported .csv in Hyperion v8.3

I have a csv imported into my Hyperion v8.3 bqy file. I have some custom columns and a pivot already created. I just want to refresh the data. In the past, I would hit Process Current and it would direct me to my computer and I could select the…
Eric
0
votes
1 answer

Is it possible to create dynamic drop-down boxes in Hyperion Planning forms

I'm working on my first sandbox Hyperion planning application and I'm curious if its possible to create dynamic drop-down boxes in planning forms. For example, if a form requires the planner to select a Team/Cost Center, Company and Currency would…
Mutuelinvestor
  • 3,384
  • 10
  • 44
  • 75
0
votes
1 answer

No rule to make a target (Hyperion)

So, I've been trying to compile Hyperion 1.2 program, but I always run into error: "No rule to make target "Src\Crypter\createoutput.ccp" needed for "createoutput.o" Even though it is there. CC = g++ SRC = Src\Crypter BIN = . OBJ = Obj CFLAGS =…
OrionHunt
  • 3
  • 3
0
votes
1 answer

Opening a Hyperion SQR Reporting

I have received some files with SQR extension. When I open it with Hyperion SQR Reporting tool, it shows only a script. How can we view the report layout using this script and how can we run this report. I'm not able to get a proper help doc on…
user1482807
  • 183
  • 2
  • 7
0
votes
1 answer

Unable to obtain a connection to Hyperion Essbase

Problem: Whenever I do a database refresh in Hyperion Planning it hangs in the 21st step and produces the following error. Could anyone please say why this issue causes and the way to resolve it ? Great Help. Thanks.
Du-Lacoste
  • 11,530
  • 2
  • 71
  • 51
0
votes
2 answers

How to monitor hyperion services on linux

So to monitor outages we have been asked to monitor some critical Hyperion services running on our Linux exalytics server. I was thinking of setting up Tivoli or Hp sitescope on the servers to do that. Or may be setup a linux script via control-M…
user2373210
  • 461
  • 2
  • 5
  • 16
0
votes
1 answer

Oracle Hyperion - Planning - Forms

I get this error when selecting already created forms in Hyperion Planning. Unable to obtain a connection to Hyperion Essbase. If this problem persists, please contact your administrator. I`m newbie to Hyperion. Please help to resolve this error.…
Du-Lacoste
  • 11,530
  • 2
  • 71
  • 51
0
votes
1 answer

Comparing 2 columns in Hyperion (Oracle)

I have two columns in a query. I have 2 fields (Field 1 and Field 2). What I want to do is: if Field 1 is blank then use Field 2, but if it is not blank then I want it to populate it with Field 1. I am sure it can be done in a computed column but…
Shelley
  • 11
  • 2
0
votes
1 answer

default virtualhost overlap on port 19000. Oracle OHS server failed to start

I am working on enable ssl for Oralce EPM11121 OHS server. While after configuration, want to restart the OHS server. Found it can not be start and got below error message from ohs_component.log [2015-08-26T11:13:51.3062+08:00] [OHS]…
Erica Zhang
  • 110
  • 1
  • 1
  • 6
1 2 3
…
8 9