Hi Ceresa, User will go in the catalog an navigate to the folder containing reports.I am not using any dashboards. Please let me know what to be done. Regards, Lak

FYI...I did not create any new role just I am assigning my group to existing role "BI Consumer" in em. I have tried to assign "Full Control" of report to "BI Consumer" role in Analytics application.but no luck. Regards, Lak

Hi, Please find my coments Is your security setup in a way to allow this app role to open reports where you saved them? Ans : Not done.what to be done for this.Please give me some inputs. What is the current security setup you have? Ans : I am using out-of-box application roles .I have created a group and few users only.…

When I click on open link of any report . I am getting an error "Access Denied".It is supposed to open and display the results.

Hi, Is there any way to limit the result to one row in 'MetricCalculated' column for each project. Cesar,I have tried your approach to eliminate the duplicates but didn't go well. Regards, Laxman

Cesar, Can we achieve the same result through LEAD/LAG functions along with TimestampDiff fucntion. Please advice. Regards, Lak

Thank you very much cesar. Basically ,I am from PLM background and bit new to this OBIEE. I will try all your inputs and let you know the results. Regards, Lak

Hi cesar, Thank you so much for your time. I will try your logic on my actual data and let you know the results. BTW, is there any way to remove the duplicates in 'MetricCalculated' column. Regards, Lak

Thanks for the prompt responce.I understood how to calucate the date difference using TimestampDiff but not exactly how to filter these columns. I am attaching the screenshot how the data appears Thanks in advance.