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

Unable to Access Hyperion Workspace in web App

I have installed Hyperion EPM in Oracle Linux 6.10. Database used is Oracle db 11gR2. Foundation services, Essbase and planning are installed and configured successfully. I run start.sh script to start all the EPM services. But still can not access…
Shashank Meshram
  • 15
  • 5
1
vote
0 answers

Exporting data from essbase through FDMEE

The main objective is to extract data from essbase through FDMEE. i have written a script called extract_data.scr and placed it in the FDMEE server. extract_data.scr: spool on to "G:\\LOGFILE_$3.log"; set column_width 200; /* to make spool file…
Md Neyaz
  • 23
  • 3
1
vote
0 answers

Migrate HFM (Hyperion Financial Management) VB to Java new API

I am working in a migration from an old VB HFM API to the new Java API for the Oracle Financial HFM framework Consolidation. I have this piece of code in VB and I don't realize how is its equivalent: Public Sub Main() Dim lValue As Long 'The…
dani77
  • 199
  • 2
  • 5
  • 26
1
vote
1 answer

Convert a single column to a table based on first characters

I've recently started helping with reporting using Essbase/SmartView in Excel. I'm trying to take the Essbase report; which combines all levels of my Project hierarchy into a single column - and instead convert it into a table. It doesn't appear…
Matty Money
  • 13
  • 3
1
vote
2 answers

Inserting results of Hyperion Smart View VBA Function into list box and/or worksheet range

I've seen answers to questions similar to this one, but I haven't been able to find anything that addresses this exact situation. Goal: Populate a list box and/or a worksheet with the output of a HypQueryMembers function. For example, I would like…
Catmandoo
  • 11
  • 3
1
vote
1 answer

How can I configure email alert to check if an Essbase Application is running or not?

I want to develop a script which will check the state (running or not) of an Essbase application (say, every 15 mins.). If the Essbase application is not running then it will send an alert via email to user or application admin .
Amit
  • 11
  • 1
1
vote
1 answer

Migrating cube from Microsoft SQL Server Analysis Services (SSAS) to Oracle Hyperion Essbase

I'm looking for a tool or at the very least a tutorial that would ease the conversion/migration of a SSAS cube to a Oracle Essbase cube. I have researched in multiple different places and I can't seems to find any information regarding migration…
hmanolov
  • 113
  • 7
1
vote
0 answers

Read Hyperion Planning webform XML with VBScript

I exported all the webforms from our Hyperion Planning system and I'm trying to build a database, listing the key details of each webform. The webform is exported into XML, that looks like this:
Max Lamer
  • 11
  • 3
1
vote
1 answer

SQLServer Error: 18546 - SQLState 28000

I have a 3-level application running. WebServer IIS7.5 and SQLServer 2008 R2 Express Database and OS WinServer 2008 WebEdition. When I try to connect via ODBC from a PC on the network have this error. Remote connections with MSSM (Microsoft…
daniele3004
  • 13,072
  • 12
  • 67
  • 75
1
vote
0 answers

Can you add a URL to another server from Hyperion Workspace 9.3.1?

I'm new to the Hyperion Workspace world, so hopefully there's an obvious answer to this question. Basically, I want to be able to add a simple URL link to one of the folders within a Hyperion Workspace (v 9.3.1). I've found information on…
Steve Scheffler
  • 3,706
  • 2
  • 21
  • 22
1
vote
1 answer

what is the differnce between page file and index file in essbase?

what is the difference between .pag file and .ind file ? I know the page file contains actual data means data-blocks and cells and index file holds the pointer of data block i.e. available in page file. but is there any other difference ?regarding…
user1252398
  • 1,069
  • 7
  • 22
  • 29
0
votes
1 answer

An simple mdx error, unknown-member measures.unit_name used in query

We are using hyperion, but this simeple mdx caused the error:"unknown-member measures.unit_name used in query". why? Is "Measures" available in hyperion? Or do we need enable it? Please help. WITH MEMBER [Measures].[Unit_Name] AS…
Fan Yulong
  • 1
0
votes
1 answer

How to generate an identity column in hyperion interactive reporting?

I want to display an auto-incremented series (basically the row number) in a new column. How do I go about doing this in Hyperion Interactive Reporting ?
ashutosh raina
  • 9,228
  • 12
  • 44
  • 80
0
votes
1 answer

Blank File generating, while Converting EPMA generated “.ADS” files for their Planning, HFM, HPCM and Essbase outlines to a DRM import format

Blank File generating, while Converting EPMA generated “.ADS” files for their Planning, HFM, HPCM and Essbase outlines to a DRM import format. And .ads file contain some Arabic word's To run the converter, follow the ReadMe document and the…
Prags
  • 2,457
  • 2
  • 21
  • 38
0
votes
0 answers

Oracle Hyperion, Business Rule(Calc Manager) for copy data from BSO to BSO?

As I want to copy data from BSO(Custom Cube) to BSO(Module based cube) in ORACLE HYPERION. I know the logic but do not know the syntax to write that logic. What Level of Generation should be fix? Thanks in Advance. Previous approach was copying data…
Dhruv Shah
  • 1
  • 1
1
2
3
…
8 9