@User_DQIAN Welcome to the Oracle Analytics Community!! I request you to post this idea in our

@sgeorge_otn Welcome to the Oracle Analytics Community!! Can you please share us the output of exportarchive.sh command?

@User_1WDE0 Welcome to Oracle Analytics Community! Please provide us the complete error message.

@Rajakumar Burra I am thinking loud here. Have you explored moving this logic to the ETL layer?

@Rajakumar Burra If we have a master list of employees and store it in a parameter and use the parameter in a formula to check if an employee exists in the list or not, will it suffice your requirement?

@Rajakumar Burra Let us say, we are considering Jan-25 and May-25 , can you tell me the expected output? This will help to understand the requirement better.

Hi @Priya Chary I would think of data level security. Please check if you are able to see the data in EPM cloud directly by logging in as the same user.

@Priya Chary Welcome to Oracle Analytics Community!! You can use the EPM connectors available in NSAW to fetch the data from EPM and build reports on top of it. Please refer to You mentioned that you tried creating a dataset based on EPM cubes but the data doesn't seem to be available. This could be because of data level…

@Robin Wu Can you please define "Limits Values By" and verify? Please refer

@Robin Wu Can you please upload screenshots showing your requirement?

Please add /dv/ui/**

Yes, it is correct.

@User_AOKHO Can you try setting the redirection rule for the below URIs also at OHS and verify? /dv/ui /dv* /dv/** /dv/ui* dv/ui/**

@User_27SWQ Can you please check the application roles that are assigned to the Weblogic user? You can go to My Account > Application Roles tab.

@Timothy Dickinson Can you please compare the patch level between these two instance?

@Kirk Li We may have to generate browser and analyze the issue further. It will be better you log a SR for this issue.

@User_27DEY We can set the query limits in the Semantic model. Please refer We can also set the query limit at the system level. Please check the section "My analysis or workbook times out" in the document

@Kirk Li The functionality of VALUEOF() is different. It is used to reference BI Server variables. Please check the below: Use the VALUEOF function in a filter to reference the value of an Oracle BI repository variable. VALUEOF(expr) expr Variables should be used as arguments of the VALUEOF function. Refer to static…

@Saroj Kumar Behera I would suggest you to log a SR so that we can analyze the log and check why the variable is not getting populated.

@Saroj Kumar Behera I would suggest you to run the init block query directly against the database after substituting VALUEOF(NQ_SESSION.USER) with an appropriate value and check if it works fine. Also, make sure that the query does not return any NULL values.