Yes I can see these details in Catalog Manger. But is there any way we can expose the "Modifier" field to users in OBI Analytics?

Even though my earlier_quarters analysis was returning correct data, my view had incorrect data in it. I fixed the view and then the analysis based on earlier_quarters also started working fine. So am not really sure how this was done but it works now. Below is the screenshot of the final filter used.

Does your Oracle Database have any table policies (VPD) applied on them? Something that can restrict data as per users. That might be one reason why no data is being shown in OBIEE as the user which send the SQL is different than you own user which sends the SQL from SQLPLUS.

Ok, so as you're saying its not possible to nest 2 PERIODROLLING functions. Yes it is always a better option to use one AGO instead of nested functions. These nested ones are being created by users and am new to OBIEE so I had to check if this was even possible. So that I can tell them how to proceed. Thanks for your reply.

Thanks for your reply. I will look into the design. But is it possible to nest PERIODROLLING?