Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Export list of Hyperion users from Shared Services [EPM11.1.2.2]

kent_Oct 30 2013 — edited Nov 1 2013

Hi All,

I used to pull the list of users from Native directories using the query :

select * from CSS_USERS;

I looked at the remainder of the tables in Shared Services and couldn't find the "username" of the accounts stored in the external directory. All I could find are the corresponding AD users GUID. eg. msad://OBJECTGUID=\f7\70\aa\c1\fb\0f\61\4e\95\b9\e5\f8\1e\8b\23\43?USER

Is there an easier way to get a list of the users provisioned within Hyperion?

As a workaround, I manually pull the users details using LCM; is there a way I could automate this?

*** UPDATE ***

- EPM version: 11.1.2.2

Thanks,

Kent
This post has been answered by kent_ on Nov 1 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2013
Added on Oct 30 2013
#business-intelligence-applications, #epm-system-infrastructure, #performance-management-applications
3 comments
1,288 views