4 Replies Latest reply on Feb 17, 2011 4:13 PM by WPaffhausen

Connection to dimension failed in workbench

NathanG Feb 17, 2011 12:23 PM

Hi all,

v11.1.2, win server 2008

I am trying to configure FDM with essbase for the first time. I have got the read helpfully referenced in a previous post I searched for. I have added in the essbase 32 bit location for both the aborpath and essbase_path and rebooted the server. I have imported the adaptor and registered it. I am logged in as an admin user to the server.

I also referred to this post: unable to configure the FDM-Essbase

When I go to configure the adaptor I get connection failed on the target for the measures dim. I cannot understand why.

My knowledge of fdm is very limited at the moment but here is what I have done.

1. Added machine name as the server name of where fdm is installed. The target server is where essbase is.
2. Entered credentials for machine profile and essbase integration. User is an admin.

I am unsure what the source and target servers should be. I have tried the using the same server where fdm is for both but it makes no difference.

I would appreciate any assistance you would be kind enough to give.

Thanks,

Nathan

1. Re: Connection to dimension failed in workbench

NathanG Feb 17, 2011 12:25 PM (in response to NathanG)

Forgot to say I have created the app in essbase with dimensionaility. The logon method is unified for essbase integration setup.

Thanks
Like Show 0 Likes(0)

Actions
2. Re: Connection to dimension failed in workbench

WPaffhausen Feb 17, 2011 12:31 PM (in response to NathanG)

Nathan,

It might be benificial for you to gain some infrastructure knowledge or the skills of an infrastructure resource. The software is sometimes complex to install and has a lot of requirements. Also I would suggest you review the FDM Documentation as it clearly states what the values should be. Documentation can either be downloaded from eDelivery or viewed/downloaded from OTN. In there is also an FDM Configuration guide; which covers the adapters.

'Source Machine' is the FDM Application ServerName
'Target machine' is the Essbase ServerName

Also to speak more about your "error" you will need to provide the user error log.

Thank you,
Like Show 0 Likes(0)

Actions
3. Re: Connection to dimension failed in workbench

NathanG Feb 17, 2011 4:02 PM (in response to WPaffhausen)

Hi,

I spoke to Oracle who got me to copy the adaptor executable to the essbase client 32 bit folder and register it from there. This info is not in the read me files.

Nathan
Like Show 0 Likes(0)

Actions
4. Re: Connection to dimension failed in workbench

WPaffhausen Feb 17, 2011 4:13 PM (in response to NathanG)

Hello Nathan,

While I agree with Support on what they stated as a 'work-around' .... it is not something that should have to be done. Being an ex-Support engineer I can tell you that there is a root-cause to the issue and this is only a side-step.

But I am glad that it is working for you.

Thank you,
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.