Oracle Hyperion essbase server installation problem

I had a problem while installing hyperion essbase. In the essbase server, I entered a username and while doing administrative configuration utility, I was asked to enter these details and when I entered it says that the information was incorrect. I tried several times but it was locked I guess. So, ...

Oracle Hyperion essbase server installation problem

I had a problem while installing hyperion essbase. In the essbase server, I entered a username and while doing administrative configuration utility, I was asked to enter these details and when I entered it says that the information was incorrect. I tried several times but it was locked I guess. So, ...

Oracle Not able to get Essbase Server list in Office with Smart View 11.1.2.1

Anybody tried Shared Connection in Smart View 11.1.2.1? I am able to connect to but it does not show any servers in the non editable drop-down box. I tried this with Office 2003 sp3, Office 2007 and office 2010 but none of them is working. Also i tried to find out the datasourse.xml file in LWS-aps ...

Oracle Essbase server not starting 11.1.2.1

I am trying to start Essbase from command prompt & it's not getting started it gives me following:D:\Oracle\Middleware\user_projects\epmsystem1\bin>startEssbaseSat 04/30/201110:38 PMStarting Essbase.propertiesA subdirectory or file D:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\log ...

Oracle Failed to Establish Connection With SQL Database Server in Essbase studio

I am using Essbase Studio Release 11.1.2.1.00 for developing XOLAP cubes and deploying them on to Essbase server .I am getting the below Error while deploying the cube onto Essbase server.error : Failed to deploy Essbase cube.Caused by: Failed to build Essbase cube dimension: (TimeHierarchy) .Caused ...

Oracle Essbase Analytic Service on Windows 2003 Server won't start

A sytstems admin pushed a lot of updates onto the production Essbase and Shared Services servers last night. This morning the Hyperion S9 BI+ Analytic Services 9.3.1 service on the Essbase Server will not start. Log error says:[Sat Sep 10 16:24:19 2011]Local/ESSBASE0///Info(1051286)License informati ...

OLAP integration server desktop error-Immediate help required

I've installed the OLAP Starter kit which I downloaded from IBM.When I start the OLAP integration server desktop,it gives me the following error[Wed Jul 09 10:59:16 2003]Local/Sample///Info(1002035)Starting Essbase Server - Application [Sample][Wed Jul 09 10:59:16 2003]Local/Sample///Info(1200478)Ca ...

Connecting EssBase in Cognos8.4

Currently we are connecting Hyperion Essbase using the Essbase client API which is not allowing us to connect to the provider services.Is there a way to connect essbase perovider services instead of connecting essbase server? ...

error occurs when launching Hyperion Essbase

I encounter the following error message when launching Hyperion Essbase on AIX 4.3: Failed to set global locale in EssGCSetLocale() This happened after I execute "shutdown -Fr" as root user without stopping the essbase server then the AIX server didn't work yet. ...

ESSBASE 6.5 Client Installation

Need some guidance on steps to be followed for installing Essbase6.5 client on Solaris(5.8). I would also like to know which file is to be executed in order to get to the Essbase prompt after installation, and what is the command to connect to the Essbase server. Any additional attachments of releva ...

Can't migrate an Essbase application - different locales?

I've worked with Essbase for a while now but never had to actually migrate a complete application from one physical server box to another one. I'm using the migrate wizard and I get the following error after clicking FINISH. Do I have to change the locale of one of the installs?Essbase server: pbgwa ...

ESSBASE 6.5 Client Installation

Need some guidance on steps to be followed for installing Essbase6.5 client on Solaris(5.8). I would also like to know which file is to be executed in order to get to the Essbase prompt after installation, and what is the command to connect to the Essbase server. Any additional attachments of releva ...

ESSBASE 6.5 Client Installation

Need some guidance on steps to be followed for installing Essbase6.5 client on Solaris(5.8). I would also like to know which file is to be executed in order to get to the Essbase prompt after installation, and what is the command to connect to the Essbase server. Any additional attachments of releva ...

Oracle Essbase system 9.x installation on UNIX

We are installing Essbase server, Admin services and shared services on the UNIX box, and our company requires using Single Sign-on for all applications. Apache Tomcat is not supported by CA SiteMinder client we use for SSO. any ideas? ...

Oracle Cannot connect to the Administration server?

I just installed Hyperion 11.1.2 in Windows 2008, and I'm sure the essbase server is started because I can connect by MaxL, and I can see the Administration server service is started because I can see it in the service list. But When I want to login ADM, error messageL "Cannot connect to the Adminis ...

Oracle Essbase 11.1.2 Connectivity issue

I successfully completed the installation of EPM 11.1.2 in a distributed environment: Server A: Foundation Services, Reporting and Analysis, Workspace.Server B: Essbase Server and Essbase Studio ServerI added the external MSAD authentication directory in Shared Services.I am able to login to EAS usi ...

Oracle Connecting from FR Studio or Web Analysis Studio to Essbase - Issues...

I have Hyperion System 9.3.1 installed. I wanted to connect to Essbase server from Financial Reporting Studio or Web Analysis Studio.I thought this would be straight forward but running into issues.I used the Server Name as "localhost" and also the actual name of the machine. But no luck.User ID and ...

Oracle Essbase Error 1051085

We have a situation where application admin users cannot open a FR report because of the error:5201:Unexpected error creating query to datasource in createCubeViews:Error: Error getting object[App\App_Name\Cube\Plan\SV\1051085 [1033]Native: 1051085 Unrecognized resource id 1024 [Cannot get variable. ...

Oracle Essbase Production and Test

we are going to plan a production and test environment for our essbase. The approximate user count is max 50 for production. The development and testing of cubes we would do on test machine. Then we would roll them out to a production. What is the best way to build them? I thought about 2 variants1) ...

Oracle EAS can't connect to Essbase after service restart

Hyperion 11.1.2.1. EAS on Windows trying to connect to Essbase on Linux. EAS is not able to connect to Essbase after service restart. The console just hangs when we try to expand the Essbase server.I can connect to Essbase via Smart View. We get the below errors in the EAS log :####<Nov 8, 2011 8 ...

Oracle Network error [10061]:unable to connect to [server qasrvr 1423]

I am trying to add server in essbase server under ESSBASE@ADMINISTRATION SERVICES 9.3.1 .I got following error Network error [10061]:unable to connect to [server qasrvr 1423]the client timed out waiting to connect to analytic services agent using TCP/IP check your connections also make sure that ser ...

Code page problem - DB2 and OLAP in AIX

I am using Essbase Integration Server 6.5.1. Normal "Member and data load" works with no problems. The "Member and data load finishes with no error". I can see the data from Exel.When I change the leaf members to "hibrid analysis" inside OLAP Integration services and ex ...

DWC07356E rc=7356 rc2=8410 udp programm

I know that this error has been displayed again but it was for another situation.This rc stands for many cases.Anyway my problem is this: DWC07356E An agent's processing of a command of type "runUDP" failed for edition "0" of step "Currency Dimension - Update CRM Cube". ...

db2-err-0028: unable to load the following db2 olap library: "c:/program files/cognos/c8\./bin\essapi

CheeMun Kuan said: Hi All: Appreciate if someone can help me out on this issue. I hits this error : db2-err-0028 unable to load the following db2 olap library: "c:/program files/cognos/c8\./bin\essapi when perform Essbase server connection in Framework Manager. I did try to install Hyperion 7.1.6 Cl ...

Oracle Error: 1051293: Login fails due to invalid login credentials

Need help!I searched all the threads for this but i still have not found one that works for my issue.I was trying to add a new essbase server using EAS and i been getting the following error admin July 7, 2010 12:40:32 AM CDT com.essbase.eas.admin.defs.AdminCommands.AddServerToUserList Succeededwins ...

Cognos TM1: How to create time dimension if quantity is semi-additive fact?

I would like to create Time dimension according to "Time Balance Last" of Stock Quantity.Time StockQuantityJan 100Feb 90Mar 110Qt1 110Apr 100May 80Jun 70Qt2 70Jul 110Aug 85Sep 60Qt3 60Oct 75Now 45Dec 100Qt4 100Year 100 StockQuantity_Qt1=StockQuantity_Mar (March is the last month of Quarter 1)StockQu ...

Oracle you must supply a valid User Name and Password to log onto the system

he installing Hyperion 9.3.1 on a server, I installed and tested successfully Shared Services, Essbase Administration Services, Essbase Server, Essbase Client ........ my problem is when installing Reporting and Analysis Services and installed without problems UIServices in confuguratio utility come ...

Oracle Install/Upgrade from 9.3.3 to 11.1.2.1

Gurus,We are upgrading from 9.3.3 to 11.1.2.1(Distributed environment) and have gone through the 11.1.2.1 start here , installation and configuration guides.Existing environment:Machine1(Windows 2003 R2): Hyperion Shared Services, EAS webapp,Essbase Provider Services(WebApp)Machine2(Windows 2003 R2) ...

Oracle Planning Question

I have planning application on version 11.1.1.3. We are still in development phase & we are plnning to use LCM for migration across different servers. If I am a planning admin & in shared services I am assigned adminstrator role to both Planning & essbase I will be able to run LCM from p ...

Oracle Critical Issue. Not able to find the root cause

Version Oracle EPM 11.1.2Web Logic App ServerEssbase Server Access = "Server Access"Planning Access = "Planner"We have few planning users defined as "planner"s to one of my planning app. They have been setup to access Essbase also using "Server Access" permission to Essbase. They can login to Planni ...

Java udf.policy - Unable to Grant Read,Write to Specific File

Essbase 9.3.1Using a Java Custom Defined Function (CDF) that reads and writes to a file in an Essbase calc script.I'm trying to grant permission to a specific file in the file system by granting permission in the udf.policy file.When I uncomment the line permission java.security.AllPermission; the C ...

Oracle udf.policy - Unable to Grant Read,Write to Specific File

Essbase 9.3.1Using a Java CDF that reads and writes to a fileI'm trying to grant permission to a specific file in the file system by granting permission in the udf.policy file.When I uncomment the line permission java.security.AllPermission; the CDF works fine and interacts with the file correctly. ...

Oracle Error reverse engineering Hyperion Planning 11.1.2.1 with ODI 11.1.1.5

I have the port set to 11333 Hyperion RMI service is running.. still getting this error.. By the way it looks like this 11.1.1.5 release of ODI has too many bugs when loading data and metadata to Hyperion.. It seems that I need ODI to be installed on Planning server.. I had it running on the other ( ...

Oracle Cannot drag from POV in 11.1.2.1.102

In the above version I cannot drag a dimension from the POV. It is just not possible. OS = Server 2008 R2, Office 2010/32 bit. The .102 kit ws installed properly (essbase server,provider services, smartview). Both connection types work.... the .102 functionality is there... its just the drag from th ...

Oracle SmartView POV issue

I have just had the SmartView add-in installed on my laptop running Windows 7 and Office 2010. Whenever I open a spreasheet linked to the Essbase server, the POV pop-up window keeps flashing constantly and I cannot get it to stop, which makes the spreadsheet almost impossible to use. What might be h ...

Oracle After Loading and Calc'ing the database error in data Preview

I am doing my Developer on my laptop and the transfering the object to the server I have loading and calc'd about 4 years of data on Bith My laptop and the Server when i try to Preview the data I get this error Duplicate Member names with data preview are not supported On my Laptop is the becasue i ...

Olap DB2 server from essbase storage

I'm thinking of moving my storage from essbase 6.5.3 to Olap DB2 server as my back end.I just wondered how easy and smooth the migration is likley to be and if any of my cubes will need re-engineering. ?appriciate your comments MD ...

ESSBASE exporting data to a different server

We are running ESSBASE 6.0 patch 1 on HP unix. What I would like to do is export the data from an application to a different server. Going through the application manager or using ESSCMD, ESSBASE wants to put the export file on the same server as the application.Any ideas?Dave Schaeffer ...

Essbase install on Ubuntu 9.10 AMD 64-bit server

Although I have "played" with Ubuntu for a couple of years, I am now learning how little I know. I am attempting to convince a company to support running Oracle's Essbase on Ubuntu 9.10. They have asked me to set up a pilot to demonstrate how it might work for them. My goal is to convince ...

Oracle essbase studio - drill thru query generated by server

Is it obvious that drill thru query generated by essbase studio server does not include group by clause.. below is the standard query.. i was trying to use the User Defined Query by including the group by clause but essbase studio is failing to validate this due to insufficient JVM. Please let me kn ...

Oracle Data loading from SQL server to Hyperion Essbase

I am trying to load data from sql server to hyperion essbase. I have created Physical andlogical schemas fro both the technology and also created a model and reverse successfully. I import the knowledge modules related to SQL and Essbase..My question is while creating a new Interface under projects ...

Essbase Olap Server

Anyone here who can help me optimize my Essbase Olap Cube? Its taking quite sometime to calculate...what seems to be the problem??? 4 hours of calculation and only loading 40,000 records. Need your help badly and A.S.A.P. ...

Dynamic Calc with DB2 Olap Server and Essbase

We use DB2 Olap server, release 8.1, on NT server. We have a cube with the following settings:- Two Pass Calculation- Database Access : None- Buffered I/O Access Mode- Bit-Map Encoding Data Compression- No Cache Memory Locking- 4 dense dimensions and 7 sparse dimensionsBy setting the "Dynamic C ...

Oracle Essbase database export to everywhere on the server ?

I'm faced with a problem that came up with a growing number of Users (thanks god they like Essbase) with Database Desingner privileges.From my point of view it is absolutely dangerous that every one of them can do an database export where ever they want , even to the "root" C:\ e,g, i_can_export_eve ...

Oracle Essbase Ver 11 Download

I noticed the OTN download does not have Essbase Admin 11.1.1.2.0, though it does have the Provider services, client & server downloads for Essbase. The Essbase V9.3.1 also has all the modules. Can anyone explain why the Admin is missing on V11.1.1.2.0 ? ...

Oracle Trouble Downloading Essbase System 9

I am having issues trying to download Hyperion Essbase - System 9 Release 9.3.1 Server Windows Installer. The link returns a 404 Error. Has anyone else had this issue? I real need to get my hands on this software to get ready for a job interview so any help would be great.Jim ...

Essbase rollup totals not accurate

This seems to be a 'once in a while' problem: I have a few members of various rollups that occasionally do not add up to the correct total in the parents' spot.e.g. Below, the rollup Total for A and C might be correct while B is not. Close inspection shows that all three have identical setups in the ...

Hyperion Essbase or MS OLAP

i'm wondering if anyone has any experience with both Hyperion Essbase and MS Analysis server. I'm working for a company which currently uses Essbase OLAP server 6.1, but they're not satisfied with it's performance. They're now considering MS Analysis server. What are your findings? Performance is mo ...

Restoring corrupted ASO Essbase Cube

We are using Essbase OLAP Server version 7.1.2 for building cubes for analysis. We face issue with an ASO Essbase Cube whose files got corrupted.We have uncorrupted data and outline files. But that doesnt allow us to restore the corrupted cube. Do anyone has any thoughts on how to restore a corrupte ...

Oracle How do I make Essbase auto calculate once updated?

I am running replication on a DB2 server which will take information from DB2 and export it to Essbase automatically. I want to completely automate the process so I am looking for a way for Essbase to clean the updated blocks once DB2 is finished updating the cube. Is it possible to do this automati ...