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
8
votes
2 answers

Hyperion Essbase Connection in SSIS

How can I get SSIS to connect to an Oracle Hyperion Essbase cube to use it as a data source? Googling this returned the following: A similar question was asked about a specific version with no real answer other than "a third party tool can do…
Registered User
  • 8,357
  • 8
  • 49
  • 65
4
votes
5 answers

What are ways to transfer tables from Oracle to SQL Server

I've been searching the internet for this question: What are ways to transfer data and tables on a daily basis from an Oracle's Hyperion to SQL Server 2000? I am an intern at a company and trying to figure out possible ways to do this. Any help or…
user955485
  • 53
  • 2
  • 10
4
votes
1 answer

Automatic smart view hyperion refresh with VBA

maybe someone could help me to understand, what I'm doing wrong, as I'm stuck.. In general, I have a process, where I have an .vbs file, that triggers macro file, which makes connection to Hyperion and refreshes sheets. For some reason, when I'm…
Yuriy T.
  • 195
  • 2
  • 4
  • 12
3
votes
3 answers

Enable COM addins in Excel through VBA

I need to enable COM addins through VBA. The addins already exists under COM addins, but become unchecked when Excel crashes. Sub hyp() Dim objAddIn As Object For i = 1 To Application.COMAddIns.Count Set objAddIn =…
PerlBatch
  • 200
  • 2
  • 2
  • 10
3
votes
1 answer

MDX filter problem

I'm pretty new to the whole MDX thing, but the following is just driving me batty. A FILTER statement I'm using is acting... strangely. Code sample, followed by description: SELECT { FILTER( MEMBERS([Time].[5-4-4 Week…
kyle
  • 1,460
  • 2
  • 15
  • 21
2
votes
1 answer

Oracle Hyperion planning function @Return not working as should

I am trying to use function @RETURN in the calculation script in Oracle planning. It should return error message "Please check this again" if "SGAseason" is 1, otherwise should give value 100 to "SGAseasonvalid". By now it returns error message in…
Jullis
  • 21
  • 1
2
votes
0 answers

How to connect to Oracle hyperion (HFM) using Python?

It is possible to connect to HFM (The Cube, not the database) using python instead of Oracle SmartView Plugin in Excel? How can I do it to do a retrieve/extraction? Regards,
Cristian Saavedra Desmoineaux
  • 358
  • 4
  • 7
2
votes
1 answer

Multiple Oracle Smartview Refresh Not Working in a Loop (Works When I Step Through Code)

I have the following the code that works like a charm when I step-through it line-by-line (or even when I only step through 1 or 2 loop iterations then fire the rest). When I run it from a button the code does not work in the sense that the Hyperion…
Scott Holtzman
  • 27,099
  • 5
  • 37
  • 72
2
votes
1 answer

Dim Leap Year, VBScript

I have a series of Ratios calculated in VBScript which incorporates the total days in the year. For 2016 we need to utilize "366" days instead of the normal "365." I created a Dim variable to populate based on the year, but it's clear the script…
Mike
  • 133
  • 1
  • 1
  • 13
2
votes
1 answer

using excel vba to open specific version of brio (hyperion reporting studio)

I was using Hyperion version 9.3.3 to process my queries and was recently upgraded to version 11. The problem I'm encountering is that version 11 doesn't have the same amount to computational space as 9.3.3, so until I create a solution to this I'd…
Slow Joe Crow
  • 21
  • 1
2
votes
6 answers

Creating a VBA Refresh Macro in Smart View for Oracle

Does anyone know the VBA Code that I need to use so that I can automatically “Refresh” and “Refresh All” using EPM (Hyperion) Smartiew? The “Refresh” function pulls the data into Excel on the active tab where the “Refresh” all function refreshes all…
user2674605
  • 93
  • 1
  • 3
  • 10
2
votes
3 answers

Javascript: Array name as string; Need it to reference the actual array

I have to "get at" an array, but all I have is a string that matches the array name. Obviously this kind of thing won't work, but it shows what I'm trying to do: var arrayname = new Array(1, 2, 3); var array = 'arrayname'; Alert(array[0]); Of…
undrline - Reinstate Monica
  • 526
  • 1
  • 7
  • 18
1
vote
3 answers

Brio save file without column headings

How can I prevent the column headings from appearing in a .txt save file in Hyperion ?
C J
  • 21
  • 3
1
vote
1 answer

Oracle Hyperion MDM Web Service API and .NET interop

We have Oracle Hyperion Master Data Management (aka Data Relationship Management) installed along with it's Web Service API, which is essentially an EAR file deployed on WebLogic. A built-in server side security policy has been attached to this web…
Ranga
  • 618
  • 1
  • 8
  • 14
1
vote
0 answers

Opening xlsm with xlwings causes external links to break

I am an accountant and very new to python... I am trying to write a python script that will open an xlsm file, refresh external data links (connection to HFM Smartview), then save and close the file. I have already written a draft of the code that…
Michael Daniels
  • 11
  • 2
1
2 3
…
8 9