It is not possible. Anyway users will see only the folders they have access to. Thanks Arijit

986359 wrote:SELECT distinct "Calendar"."Month Num" FROM "Test" where "Calendar"."Month " = '@{m1}' Try this for desc order... SELECT distinct "Calendar"."Month Num" saw_0 FROM "Test" where "Calendar"."Month " = '@{m1}' ORDER BY saw_0 DESC

986359 wrote: "But in this case when a value is selected in Prompt1 it will not reflect in Prompt2 unless clicked on Apply button " You can avoid by removing apply and remove button.

You have to set that in RPD also....Do that in Identity manager. for the connection to be used as direct database connection you need to allow that user role to run direct db connection.

On the connection pool, you can add a physical query to update application context with user id(:USER). Then use dbms_rls package to apply policy on the database table. https://docs.oracle.com/cd/B28359_01/network.111/b28531/app_context.htm#DBSEG011 Check if the documentation helps. Thanks Arijit

I took your query modified (added select after union) a bit and it is working... SELECT Case when '@{PV_A}' = 'A' THEN 'W' END FROM "SUBJECT AREA " UNION SELECT Case when '@{PV_A}' = 'A' THEN 'X' END FROM "SUBJECT AREA" UNION SELECT Case when '@{PV_A}' = 'B' THEN 'W' END FROM "SUBJECT AREA" UNION SELECT Case when '@{PV_A}'…

In 12c tree map measures are automatically identified and placed under size by column. You mean you don't see "Coverage" column in the size by drop down ? Thanks Arijit

I think I have seen this issue before. Can you try something and let us know if this works. On the condition analysis disable cache. put SET VARIABLE DISABLE_CACHE_HIT = 1; in the prefix section of condition analysis. Thanks Arijit

You should try OBIEE master detail reports. Example OBIEE 11g: Master-Detail Linking - Red Stack Tech If you like to explore more complex solution ...here is another food for thought... https://www.clearpeaks.com/pop-effect-in-obiee-using-jquery/

So, You have only one group set up in AD and everyone of them in that group gets consumer access? I guess better option is create different groups in AD. like say Then in EM add that group to specific application role.

One More thing please update your profile add a name to it. Replying to 13f24b9f-ed83-46e3-964c-fb39dcd56bcb feels like replying to robot Arijit

IF OBIEE is configured using Active Directory then how you can expect to add user using weblogic. Add users to active directory group and those users will show up in weblogic. Thanks Arijit

The answer that @Pedro F provided is correct and works with the filter. I think the issue is with html link from narrative view. So, instead of using that you can use dashboard action link. Use same column in both page 1 and 2 prompt. multiple values will be carried. for example below...I have page 2 as action…

In that case check the subject area and see what changed? Check the source of that subject area. Try to find the physical quires generated against the subject area in the log. That should give you a clue.

Did you try a different browser? Do you have any kind of flash in the report ? Do you have section wise security set up ? We need more information ....

What you have in that section of the dashboard ? Arijit

I guess you want to sort Jan to Dec ...so, instead of using all values use specific column values. Then select jan to Dec as sorted in the selected list. OBI will retain this order. Thanks ArijitC

In your question you said listbox but the screenshot shows Check Boxes. It is not possible to change height of either listbox or Check boxes unless you add some custom style. If you have scroll bar showing up that means you have too many values for Check box or listbox. In those cases , choice list is better option in my…

In dashboard properties or prompt page properties , if you hide apply and reset button ...it will not ask you to submit the report again. It will apply new prompt as soon as it is selected. Check if this is what you want ... Par your requirement you need to use dashboard prompt.

Print @{pDate} in the analysis header to check what date is getting passed. You need to make sure that it is presentation variable is really getting used to filter the analysis not column filter. You can test that by checking "protect filter' in the analysis. My guess is two analysis has two different column where you are…