Hi @Bhaskar Konar Just to confirm, the SELECT statement should be for the display name and the WHERE should be equated to a username or email address? Thank you

Hi @Bhaskar Konar "Projects - Cross Subject Area Analysis - Real Time"."Project"."Current Project Manager" returns a display name. Would the SELECT or WHERE need to be altered to be a column that returns a system username or email address? Thank you

Hey @Bhaskar Konar Thank you for that! I'm about to Test it out and for projects and wanting to be the only the project manager when they open it, I have it written as: SELECT "Projects - Cross Subject Area Analysis - Real Time"."Project"."Current Project Manager" s_1 FROM "Projects - Cross Subject Area Analysis - Real…

Hey @Bhaskar Konar Your solution works perfectly using: AND("Employee"."Employee Name" IN (:P_Name) OR (CASE WHEN ('null') in (:P_Name) THEN 1 END =1))AND("Labor Schedules Details"."Status" IN (:P_Status) OR (CASE WHEN ('null') in (:P_Status) THEN 1 END =1)) Thank you for all the help! Best, Sean

Hey @Bhaskar Konar Without the parameters it returns all data without any issues. I believe the issue is prompt. Thank you, Sean

Hey @Bhaskar Konar I applied the changes you made and have the parameters set as NULL Value Passed still do data being returned. I tried it with All values passed as well and its still cutting off at 600 rows when it should be in the 20,000s when running for all. Thank you, Sean

Hey @Bhaskar Konar I tried applying the query you sent. LEAST is not a defined function in my environment, I attempted replacing it with MIN but now its not returning any rows. Is there a way I can define the LEAST function or any other possible solutions you may have? Thank you for your help with this. Thank you, Sean

Hi @Bhaskar Konar, currently they are set as All Values Passed and I changed the number of values to display in List to 999 but still no luck. I would like for it to be NULL value passed so that the parameter isnt required and all values can be returned. I'll post screenshots and attach the catalog items below this…

Hi @Mallikarjuna Kuppauru-Oracle I followed this documentation for creating the HCM view all and HCM line manager: Those roles work great, when it comes to PPM within ERP we're able to create the view all role with no issues. If I wanted to create a project manager role somewhat similar to the HCM line manager where the…

Hey @Greg "G" Bushman My team and I are experiencing a similar issue, any luck with what was provided above or any resolution found? Thank you, Sean

@Ashish-Oracle I have not tried using the CAA functionality, I will test later today and see if that solves the issue! Thank you!

Hey @Kevin M-Oracle I'm using an RTF template, data shows for the field in the sample data for the model. I can export the sample data and attach it to the RTF template, would you suggest that as the workaround for my issue? Thanks, Sean

Hi @Mallikarjuna Kuppauru-Oracle , I can't find where to exaactly check my BIP version, I know it's 64 bit and was downloaded & installed on this computer in July 2024. My issue is that I took on this Data Model and report to make a small change for an end user, the field they would like to see in the report is already in…

The blue hyperlink ability so that you can click on a hyperlink the analysis will drill to show data for only that value that is clicked