OTBI Dashboard prompt default
Content
I have an OTBI dashboard prompt that I want to default to the current logged in user.
However, the session (server) DISPLAYNAME value is in a different format and does not match up with the "Matrix Manager"."Top Manager Name" field
I want the graph and table to default to the logged in user's direct/indirect reports and also give them the ability to look up other Top Managers (ie - narrow it down to one of their direct reports)
I've seen other posts about using the "Assignment Manager (Unsecured)"."Manager Name" instead, but that does not seem to work for me.