Smart Notes Datasource to Essbase

 3 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
WRB
Basic Member Send Private Message
Posts: 13
Basic Member

We are attempting to create Smart Notes using Hyperion Essbase.  SN version 9.0.2.2.127 Hyperion Essbase 7.1.3.0 Build2.  Our Lawson and LBI are both hosted by Siemens. 

When I go and set up the information in SN InfoSet,  I get a message that the Database can not be found. 

Does anyone have a SN using Hyperion Essbase working?  If so, any suggestion?

Matthew Nye
Veteran Member Send Private Message
Posts: 514
Veteran Member
Wendy,

Let me see if I can dig that up but you realize you are in-effect flattening the multidimensional datasource as SN is not an analytical tool. I do know you have to use the ESSbase API to create the connection.

What do your data source connection parameters look like?
If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
WRB
Basic Member Send Private Message
Posts: 13
Basic Member

I have attached the parm we are using to set up connection.  Thanks

Attachments
Matthew Nye
Veteran Member Send Private Message
Posts: 514
Veteran Member

Ok, I dont think I ever got this working but some what youll need to do is copy the java library over that includes the essbase implementation class. Copying it into %TOMCAT_HOME%/common lib and be sure to restart tomcat.  My lack of understand was what jar file the "implementation class"was in. hth matt

If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/