Hello Skhan, You may want to check the log of the BI Extender job you ran. Look for errors like 'Edited' but not deployed or any other errors. Those have to be resolved first before the DFF attributes can start showing in OTBI. Thank you Hassan

Hello Christian, You need to explore the usage of Dashboards and build prompts that are dependent on other prompts. For example, you can have a header report with its own prompts. In a different section of the Dashboard, you can add a detailed report with prompts depending on the the header prompt. This way the detail…

Hello Udaya, Please share the sql query used in the custom report. thanks Hasan

Hello Ramani, Is the snippet you shared from the XML file or the output file when scheduling the report? Thank you Hassan

Hi Sheethal, Were you able to find the agent in question. If so, please mark this thread as answered. Otherwise, let us know. Thank you Hassan

Just FYI, The getAgents webservice call will give you all the agents in the system. From there you could locate the one you are interested in. Thank you Hassan

Hi Sheetal, It would be best if you pass a user that has the BI Admin role. It does not have to be the user who created the agent. Thank you Hassan

Hello Sheetal, You can locate and delete an agent using the /analytics-ws/saw.dll webservice Try to invoke the webservice End Point - https://<<your host name>>/analytics-ws/saw.dll?SoapImpl=ibotService Below screen shot shows all Service End Points in the https://<<your host name>>/analytics-ws/saw.dll/wsdl/v12 Note: All…

Hello there, Please refer to this KM Note on how to assign the data access to the user: https://fa-etmi-saasfaprod1.fa.ocs.oraclecloud.com/fscmUI/redwood/myknowledge/content/container/main/article?answerId=2313667 Thank you Hassan

Hello Ivony, If this is an OTBI analysis, you could set the column to HTML and it will display the content without the HTML tags. Here are the steps to do that. Edit the column in question by clicking on the gear icon and selecting Column Properties Click on the Data Format Tab Check the override default Data Format set…

Hello George, Please confirm the user data access assignment on business unit as follows : Go the setup and maintenance Search for the data access: "Manage Data Access for Users" for data security From the top change the button to User with Data Access and search for the user in question. Once found click on action…

Hi Nusrat, Are you running these processes immediately after you assign AOR to an employee: [Retrieve Latest LDAP Changes] [Send Pending LDAP Request] Thank you Hassan

Hello Marijana, The following is an example of converting a number to a char: CAST("Worker"."Work Terms Assignment ID" AS CHAR(40)) Thank you Hassan

You are very welcome. Hassan

Hello Nusrat, If you are referring to an OTBI analysis, you could force it to fetch directly from the database and bypass the caching mechanism. To do that, navigate to the analysis in question: 1. Edit the analysis 2. Click on Advanced Tab 3. In the Prefix input box, add the following and click Apply and Save the…

Hi Vaibhav, Could you elaborate more on what you meant by API. Thanks Hassan

Hello, Please post this in the ERP CCC. Thank you Hassan

Hi Nipun, Please refer to this KM Note: Data Lineage Document for DFFs and Their Associated VOs (Doc ID 2463485.1) Thank you Hassan

Hello Nipun, DFF exposure in BICC are handled differently than in OTBI Subject Areas. Some products would provide specific PVOs for DFFs. Incentive Compensation is a case in point. Refer to KM Note 2444493.1. Projects have an ER for the BICC DFFs. See KM Note 2990418.1 Which product are you referring to? Thank you Hassan

Hi Haritha, Please log an SR to address the issue. BI Admin user should have these buttons when you first open the FTP page: Thank you Hassan