Hyperion Financial Reporting Products (MOSC)

MOSC Banner

How to get Financial Reporting Users Usernames or User IDs

edited Feb 13, 2018 7:35AM in Hyperion Financial Reporting Products (MOSC) 6 commentsAnswered

I am looking for Financial Reporting User IDs (like SAM Account Name). In the Planning Relational Databases this info is stored in HSP_USERS and HSP_OBJECT. Is there anything similiar to this for FR users? I am looking to extract a list of FR Users by ID and the Users authenticate using MSAD.

I have come close to this info in the CSS_IDENTITY table, but this table does not store the username/user id. If I were to resolve the MSAD GUID to a username, could I store it in CSS_IDENTITY.NAME column; I'm not sure if there are any other columns dependent on this. Is there a database setting that would 'auto update' the NAME column when a user authenticates?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center