Categories
- All Categories
- 70 Oracle Analytics News
- 6 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
User Organization Hierarchy Based Login
Summary:
I am trying to fix a report and it looks like the Hierarchy is broken (Sales - CRM Resource subject area):
Content (required):
- when using User Organization Hierarchy Based Login is equal to / is in @{NQ_SESSION.USER_PARTY_ID}, the data for the user reporting to the manager is not coming back
- when adding Manager of Employee is equal to / is in Cyrille Saulnier, the data is showing
The report used to work so it looks like something got broken on the way. Can anybody help?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Can you please provide screenshots and the log file of the report
0 -
Hi,
Basically, the following query only returns the employee data not the users in the hierarchy
Employee Login is equal to / is in @{NQ_SESSION.USER_PARTY_ID}
OR User Organization Hierarchy Based Login is equal to / is in @{NQ_SESSION.USER_PARTY_ID}
If we have the below query then you see the team data:
Manager of Employee is equal to / is in Cyrille Saulnier
Thanks in advance
0