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

if else statements in excel to count blank spaces in a cell

Good afternoon, I was wondering if there is a way to count the number of blank spaces in a cell and return that value using a combination of vlookups, if else statements, and possible the len function? For example, the reports that are generated…
John
  • 1
  • 1
0
votes
1 answer

Oracle Hyperion Essbase

A customer has a cube with 13 dimensions and the performance was fine. Now they have added two more dimensions in the existing cube and the performance becomes very very slow. Customer said logically nothing wrong with the two new dimensions they…
Hem Chand
  • 1
0
votes
1 answer

What kind of language is used to develop Oracle's Smart View

It is a very complex Excel add-on. I am wondering if all the functionalities are built using C#, C++, or Visual Basic? The typical interface is shown below:
lovechillcool
  • 762
  • 2
  • 10
  • 32
0
votes
1 answer

VBA code to disconnect from Essbase Connection

I tried writing the VBA to connect yo Hyperion Essbase to connect to multiple sheets and the connection is successful X = EssVConnect("[Macro.xls] Sheet1, sheet2,sheet3 ", "Uname", "Pwd", "Server", "Applicationname", "DB") If X = 0 Then …
Rajyalakshmi Gangisetty
  • 53
  • 5
  • 18
0
votes
1 answer

Excel SmartView vb function HypConnect not working / error code 100000

In the code below, I am trying to automate SmartView retrievals in a number of worksheets. The code seems to work OK up to the point that I create a connection before I start the loop. Inside the loop, I want to use HypConnect to use the…
Don George
  • 1,328
  • 1
  • 11
  • 18
0
votes
3 answers

find the jar that contains a given java class

I am trying to find which .jar detected this error so I can figure out the issue. This is running on hyperion server. [2015-03-15T15:18:35.352+08:00] [Planning0] [WARNING] [] [oracle.EPMHSP.calcmgr_execution] [tid: 144] [userId: ] [ecid:…
user3475343
  • 21
  • 1
  • 3
0
votes
1 answer

How to get Hyperion Smart View For Office Version add-in?

Can you get the version of Hyperion SmartView installed using visual basic code for excel ? I need to get a string output with the version number or something that looks like this -> 11.1.2.2.000 regards
messinese90
  • 11
  • 1
  • 5
0
votes
1 answer

How do you execute Data Synchronizations between EPMA applications programmatically?

I would like to schedule a batch job in which a can execute a move of data between two workspace application in Hyperion Fusion Edition for Oracle. The tool provided is called 'Data Synchronization' This tool allows for this type if activity to…
Curtis Inderwiesche
  • 4,940
  • 19
  • 60
  • 82
0
votes
2 answers

Is it possible to return multiple member levels in multiple Excel columns using Hyperion Smart View?

Is it possible to return multiple member levels in multiple Excel columns? This would make it suitable for using as a pivot table data source. For example: Smart View returns data like this: Dec Nov Oct Q4 Sep Aug Jul Q3 I would like…
Loconinja
  • 1
  • 1
0
votes
1 answer

web_submit_data function passes the values in URL format instead of HTML format

I am working on Hyperion FR reports (version 11.1.2.3 ) using load runner 11.5. The issue I am facing is with respect to a dynamic value "sso_token" that needs to be correlated. This "sso_token" is being passed in HTML mode in some requests and URL…
ajazz
  • 71
  • 1
  • 1
  • 12
0
votes
2 answers

Essbase System Login

I'm new to the Hyperion Essbase and I'm using "Hyp 6.5". Whenever I login to the Excel it shows "Essbase System Login screen". So each time I've to enter Server Name User Name Password Application/Database Is it possible to set those values as…
user2782522
  • 191
  • 1
  • 3
  • 13
0
votes
1 answer

Hyperion RDBMS Table

As we know details of every job are stored in rdbms in table Hsp_Job_Status. But unfortunately this table gets truncated each time we re-start services. As per business requirement we needed to keep a record of BR's launched by user and it's…
user3349587
  • 1
  • 1
0
votes
1 answer

post timestamp in web_submit_data itemdata in loadrunner

In our hyperion application, we have a explore button. Here is its post: web_submit_data("explorer", //FIXME: id vlaue parameter "Action=https://{host_url}/raframework/browse/explorer", "Method=POST", "TargetFrame=", …
cnu
  • 3
  • 1
  • 2
0
votes
1 answer

Why does Hyperion's Trunc(date) return large number?

I am working with Hyperion and I have never used it before about two weeks ago. Someone else set up a .bqy file to get certain columns from a DB. He has one column with this formula in it: Trunc(date) where date included the date and time. What that…
HighHopes
  • 2,014
  • 3
  • 23
  • 33
0
votes
2 answers

Passing Parameters to a Batch File from Javascript Inside Hyperion Interactive Reporting Studio

Inside of Hyperion Reporting Studio I have a document level script where I wish to call a batch file and pass arguments to the batch file. Here is the code I have: var Path = "W:\\directory\\Reference_Files\\scripts\\vbs\\SendEmail.bat" var Email =…
Scott Holtzman
  • 27,099
  • 5
  • 37
  • 72
1 2 3
…
8 9