atmyplace.co.uk

Essbase Toolbar for Office 2007

SiteAdmin — Fri, 13 Aug 2010 11:16:13 +0000

I’m sorry I haven’t created a post for a while as I’ve been tied up with other tasks. For now I wanted to share the Essbase toolbar for Excel 2007 with you. I haven’t had the opportunity to test this on Office 2010 yet but I’ll update when I get round to it.

http://www.in2hyperion.com/post/2010/03/21/Hyperion-Excel-Add-in-Ribbon.aspx

Essbase toolbar for Excel 2007

Installing a Loopback Adapter on Windows 2003

arfanmaz — Tue, 01 Dec 2009 17:54:36 +0000

Installing a Loopback Adapter on Windows 2003 or Windows XP

There are various pre-requisites to installing Oracel 11g but I’m sure you’ll have met most of them already. The one that you’re not likely to have is the installation of the Loopback adapter in Windows Server 2003. I wanted to save you the time of reading through the details and so have pasted below the instructions for this from the Oracle website. Full details can be found at: http://download.oracle.com/docs/cd/B19306_01/install.102/b14316/reqs.htm#CHDGIFBC

To install a loopback adapter on Windows 2003 or Windows XP:

Open the Windows Control Panel.

Double-click Add Hardware to start the Add Hardware wizard.

In the Welcome window, click Next.

In the Is the hardware connected? window, select Yes, I have already connected the hardware, and click Next.

In the The following hardware is already installed on your computer window, in the list of installed hardware, select Add a new hardware device, and click Next.

In the The wizard can help you install other hardware window, select Install the hardware that I manually select from a list, and click Next.

From the list of hardware types, select the type of hardware you are installing window, select Network adapters, and click Next.

In the Select Network Adapter window, make the following selections:

Manufacturer: Select Microsoft.

Network Adapter: Select Microsoft Loopback Adapter.

Click Next.

In the The wizard is ready to install your hardware window, click Next.

In the Completing the Add Hardware Wizard window, click Finish.

If you are using Windows 2003, restart your computer.

Right-click My Network Places on the desktop and choose Properties. This displays the Network Connections Control Panel.

Right-click the connection that was just created. This is usually named “Local Area Connection 2″. Choose Properties.

On the General tab, select Internet Protocol (TCP/IP), and click Properties.

In the Properties dialog box, click Use the following IP address and do the following:

IP Address: Enter a non-routable IP for the loopback adapter. Oracle recommends the following non-routable addresses:

192.168.x.x (x is any value between 0 and 255)

10.10.10.10

Subnet mask: Enter 255.255.255.0.

Record the values you entered, which you will need later in this procedure.

Leave all other fields empty.

Click OK.

Close Network Connections.

Restart the computer.

Add a line to the SYSTEM_DRIVE:\WINDOWS\system32\drivers\etc\hosts file with the following format, after the localhost line:

IP_address hostname.domainname hostname

where:

IP_address is the non-routable IP address you entered in step 16.

hostname is the name of the computer.

domainname is the name of the domain.

For example:

10.10.10.10 mycomputer.mydomain.com mycomputer

Check the network configuration:

Open System in the Control Panel, and select the Computer Name tab. In Full computer name, make sure you see the host name and the domain name, for example, sales.us.mycompany.com.

Click Change. In Computer name, you should see the hostname, and in Full computer name, you should see the host name and domain name. Using the previous example, the host name would be sales and the domain would be us.mycompany.com.

Click More. In Primary DNS suffix of this computer, you should see the domain name, for example, us.mycompany.com.

Creating Hyperion Planning Classic Applications

SiteAdmin — Fri, 31 Jul 2009 15:19:49 +0000

In my previous tutorials I have shown how to install and configure Hyperion System 9.3.1 and also which order to start the services. You now have the system running but where do you start? I was planning to provide a tutorial on how to create applications but then I stumbled upon one from Oracle that is totally ideal, so instead of reinventing the wheel I thought I’d just give you a link to some really nice tutorials to get you started.

http://www.oracle.com/technology/obe/hyp_fp/PLN_CreateSampApp/index.html

Let me know what you think.

Hyperion System 9.3.1 services startup order

arfanmaz — Thu, 30 Jul 2009 12:42:41 +0000

Ok so now we have installed Hyperion system 9.3.1 with Shared Services, Essbase, Planning, Workspace and Reporting. I’m hoping that by now you would be able to install the Hyperion Smartview by yourself. If you need help with this please leave a comment and I’ll be happy to assist.

The next step here is to start the Hyperion Services. Starting these in the correct order is crucial and affects the way the applications interact with each other. Below is the list in the order the services need to be started:

The following services are set to start automatically:

Hyperion S9 Shared Services
Hyperion S9 OpenLDAP
Hyperion S9 Apache 2.0
HyperionRMIRegistry

Once you have confirmed the above services are running, start the following services ensuring the each one has started before starting the next.

Hyperion S9 BI+ 9.3 Core Services 1
Hyperion S9 EPM Architect Process Manager
Hyperion S9 BI+ Analytic Services 9.3.1 – hypservice
Hyperion S9 Administration Services ATS5
Hyperion S9 Provider Services ATS5
Hyperion S9 BI+ 9.3 Financial Reporting Java RMI Registry
Hyperion S9 BI+ 9.3 Financial Reporting Print Server
Hyperion S9 BI+ 9.3 Financial Reporting Report Server
Hyperion S9 BI+ 9.3 Financial Reporting Scheduler Server
Hyperion S9 BI+ 9.3 Web Analysis
Hyperion S9 BI+ 9.3 Workspace
Hyperion S9 EPM Architect Data Synchronization ATS5
Hyperion S9 EPM Architect Web ATS5
Hyperion S9 BI+ 9.3 Financial Reporting Web application
Hyperion S9 Planning

This above services can also be scripted and ran from a batch file. If you’d like the startup and shutdown batch files then please leave a comment or email me: admin@atmyplace.co.uk

I was really pleasantly surprised when I saw the script already available in the new Hyperion System 11.1.1.2. In my opinion this should have been done way long time ago, but better late than never I guess.

Installing Oracle Hyperion system 11.1.1.2 aka EPM 11.1.1.2

arfanmaz — Thu, 30 Jul 2009 11:59:22 +0000

I’d heard from some of our consultants in California that the new system 11 was tricky to install and it had so many complications. For that reason I never really thought about installing it until I had some time on my hands. Unfortunately that time will never come so a couple of days ago I decided to give it a go on my old xp system. To my amazement it worked first time and it was the easiest install yet….

That was all good until I created a datasource and after the next reboot I couldn’t get some of the services to start up. No time to deal with that right away but it gave me an idea for the next exercise. I’d like to create a step by step guide on how to install, configure and troubleshoot for EPM 11.1.1.2, however I need to know which operating system you’d like to install it on. I’ve been blogging for nearly a month now and I know it’s early days but I’d like to receive some feedback and some comments from you guys, therefore I will begin the System 11.1.1.2 tutorial when I have received 30 comments on this site. You don’t need to register to leave a comment and it only takes a few seconds. Thanks

Installing Hyperion Planning – Part 6 Reporting and Analysis

arfanmaz — Tue, 28 Jul 2009 11:39:24 +0000

Now that we have Shared Services, Essbase and Planning working we can move onto installing Workspace and Hyperion Reporting and Anlaysis. Follow the below tutorial to install and configure Hyperion Reporting and Analysis:

How to Install Hyperion Planning / Workspace / Essbase Part 6 – Hyperion Reporting and Analysis

Installing Hyperion Planning – Part 5 Planning

SiteAdmin — Mon, 27 Jul 2009 22:22:50 +0000

: IIS Manager Screenshot

Now we come to the exciting bit, installing Hyperion Planning. Before we go any further, just one thing I would like to point out. Earlier on I mentioned that we need to have IIS and .Netframework 2 installed on the machine. Before installing planning I like to set ASP.NET to allow on the Web Service Extension within IIS Manager. The Hyperion Planning Install should take care of this automatically but I’ve had a couple of issues with this in the past and now I like to be cautious.

Moving onto the Planning install, please follow the instructions below:

How to Install Hyperion Planning / Workspace / Essbase Part 5 – Hyperion Planning

Installing Hyperion Planning – Part 4 Provider Services

SiteAdmin — Fri, 24 Jul 2009 14:03:52 +0000

Welcome back to this series of tutorials where I guide you through the installation of Hyperion Planning on System 9.3.1. So far we have installed and configured SQL Server as our database, then we installed and configured Shared Services. In the previous section I showed you how to install and configure Essbase. The next step in the process is to install the Provider Services. This is pretty straight forward and you can simply follow the instructions below:

How to Install Hyperion Planning / Workspace / Essbase Part 4 – Install Provider Services

Installing Hyperion Planning – Part 3 Essbase

SiteAdmin — Tue, 21 Jul 2009 21:57:49 +0000

I apologise as it’s been a week since the Shared Services install and I know some of you have been waiting for the next installation of this guide. Today we’ll be going through the installion and setup of Hyperion Essbase. Please find below:

How to Install Hyperion Planning / Workspace / Essbase Part 3 – Install Essbase

Net retry count error when running calcs via Hyperion SmartView

SiteAdmin — Tue, 21 Jul 2009 06:15:34 +0000

I’ve seen this error several times within our company and it seems to occur due to the short time-out feature for IE7 to return data. When compared to IE 5.x and IE 6.x which had a 30 minutes timeout and now IE 7 reduced to 30 seconds; As a result Internet Explorer doesn’t wait too long for data to come back if there’s a delay.

The good news is that there is a solution that’s worked wonders for me. In addition to this method below I would suggest updating SmartView to the latest version.

On the clients machine you need to find the following registry folder:

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]

Then create within the folder the following 3 keys:

“ReceiveTimeout”=dword:00dbba00

“KeepAliveTimeout”=dword:00180000

“ServerInfoTimeout”=dword:00180000

If you are still getting the timeout error your connection maybe slow and you could try increasing the KeepAliveTimout.