We are on 188.8.131.52 of EPM. In our Prod EAS I have Signed in using my AD user ID and added the two(one prod, one dev) essbase servers to the list of essbase servers. I was able to successfully add the two essbase servers. Now when I preview data on cube in dev it gives me the error "Cannot connect to olap service. Cannot connect to Essbase Server. Error: Essbase Error(1051293): Login fails due to invalid login credentials". This cannot be true because I would not be able to expand the essbase servers list and drill down to the database in order to preview it if the credentials were wrong. Also I am able to see the outlines and Calc scripts just fine. I am able to preview data on the prod cube just fine.
Now, The same happens when I try to preview data in prod essbase cube when coming from Dev EAS. Which means am able to preview data only on dev essbase server cubes when coming from dev EAS and when I try to preview data on a prod cube when coming from Dev EAS i get the same invalid login credentials error.
Could someone please help me understand if this is a bug or if this is how they intended it to work? Because we just upgraded from 184.108.40.206 and we were able to preview data across any essbase server no matter which EAS service we used.
No SSL or Single Sign-on were used. Just active directory credentials. It happens only with an AD ID and not with a native directory ID. Please suggest on how this can be fixed.
Is the AD user having sufficient provisioning to view the data ?
Have you checked with SharedServices_Security.log & SharedServices_Audit_Client ?
Could be issue with the node name, should be EssbaseCluster-1(for e.g.) format, not servername:1423 for EPM 11.1.2.x.
Thanks for the reply TimG. I have tried all various combinations and nothing works. The same error no matter what servername(Servername.company.com:port) I use.
Thanks 959658. But my question relates to adding different essbase servers to one EAS.
Any other suggestions please.
There's a documentation update in 220.127.116.11 that says "After adding an Oracle Essbase server using a cluster name, Oracle Hyperion Provider Services must be running in order to execute a Data Preview on databases on that server." and there was an older bug relating to (I think) a similar problem. But it doesn't sound like you're using cluster names. A long shot, but is Provider Services running on both boxes?
I logged this with Oracle and the following is their response copy/pasted
The issue which you have reported in this SR is a desired behavior. This behavior has been seen in latest versions only 11.1.2.x.
In earlier version we can preview the data of any Essbase server added to any eas console.
But form 11.1.2.x environment this behaviour has been changed.
We did checked with development team on this earlier, and according to development team its a behavior by design.
As dev environment and Prod environment have different registries , the preview data would work if Dev Essbase server added to Dev EAS only. like same holds good for prod or test environments.
As same issue has been reported earlier , we form support has raised a bug with development team after reproducing the issue .
But development team did not accept this as bug as this behavior was by design .
So later we changed this bug to a enchantment request with development team to change this behavior.
Bug 14622693 - PREVIEW DATA ON REMOTE ESSBASE HOST FAIL WHEN CONNECTED FROM EAS
If this enhancement requested gets approved by development team ,Then it would be incorporated in future release.
My thanks also Ted, that is fascinating. I like that they've made it an (sic) "enchantment request".
Must have been a different issue that I encountered.
I'm surprised to hear that Development wouldn't accept this as a bug. I can run a report script against a different server, I can run MDX queries against a different server, I can do anything I like to administer the databases and Essbase instance on that server, but I can't preview data? If this was actually a conscious design choice (rather than an unintended consequence of a different design choice), why not add a comprehensible "Sorry, you can't do this" message in EAS?
With all due respect to Development, as the British say: "Pull the other one, it's got bells on".
Maybe this is related to an issue on reporting tools too. I remember replying another question where user was trying to create a WA report on DEV server and pointing towards Prod Essbase. He was getting the same error and if he manully enter the credentials (WA allows you to enter the credentials if the login fails), same time DEV report works fine.
I was telling him that only possible reason I can give was Essbase somehow treats the DEV user as another user (seems like I was correct )
Well Celvin in that case , More to life than this...: EAS - single sign-on to Essbase using separate Shared Services instances This will help i think ...
Please let me know your thoughts ...