Please review the below document and see if this helps: https://docs.oracle.com/en/cloud/saas/human-resources/24d/falzi/vets-4212-establishment-electronic-report.html#Before-You-Begin

Could you please double check the query you have shared, as the "/*********vendor******************/" related part seems to be incomplete? That part is ending up with "AND vst1.language = 'E') "Vendedor"," and there are no more columns after this. Please check and let us know.

Please open a new SR, by choosing reporting as your issue and OTBI custom report when further questioned (while filing the SR). Please share the SR number here, so that I can pull it into my queue for further analysis.

Do you have OTBI admin role assigned to your username? What about the other user?

Based on what you have described, you should ideally create an Analytics Publisher (formerly BI Publisher report for this. OTBI analysis is not meant to handle this kind of volume. With Analytics Publisher report, you can schedule the report multiple times with different parameter values, and if needed merge the outputs…

Please try the following: * Save your analysis with a different name (so that you do not overwrite your existing analysis as a precaution) * Click on the advanced tab of the respective analysis * Under Advanced SQL Clauses section, you would see a check box for "Distinct" * Check that check box and click on results If all…

Please check the below document: Fusion OTBI: How To Use System Date & Auto Passing Of Dates In OTBI Report (Doc ID 2103487.1) This document describes how to run the analysis for the range of Monday-Friday, depending on the respective week when the analysis is run. You can use the same technique for the current month by…

The net book value column is available in SA: Fixed Assets - Asset Depreciation Real Time. Please check the below document to see which filters need to be applied for this: FA OTBI - Step To Follow While Creating Report With Fixed Assets - Asset Depreciation Real Time (Doc ID 2358382.1)

Please check whether there are any tuning opportunities that exist for this report. You can check this by clicking on the "Validate" button while editing the data model. Some times the system might retrieve the results for one user, but for the other users it may timeout. This is due to sub-optimal tuning. Over the time,…

You will have to figure this out from your end. Some of the points for you to consider: How much of average data is extracted on daily basis How many different PVOs are involved Can some of the PVO extraction (if it is multiple PVOs) be pushed to off-business hours Are all the PVOs being used are specifically recommended…

Please check "OTBI Usage Real Time" subject area. You have facts like Report Count, Report Execution Count and User Count. Also, Report name, path, subject area, custom report or not etc. details available in the above subject area. Please also check the time dimension for time related columns.

Please share the screen you are seeing, when you try to put a filter on "Legal Employer"."Name" in the second analysis

There is a way to play with the default "order by", but that option is not available from the front end. We need to tweak with ORDERBY_SUPPORTED flag through the RPD (OBIEE repository file in the back end with extension .RPD. This is just referred to as RPD in the common parlance). Please refer to section 14.6.8 of the…

Based on a demo/Vision pod I checked on, following logical query is working for me, and I am getting one row per person: SELECT 0 s_0, "Workforce Management - Person Real Time"."Worker"."Person Number" s_1, CASE "Workforce Management - Person Real Time"."Person Phones"."Phone Type Code" WHEN 'W1' THEN "Workforce Management…

Could you please share the logical SQL query from the "Advaned" tab of the respective analysis?

Try using CASE statement for each of the condition you need to code.

Try the following and let me know, if this works for you: First create an analysis with the below query. I saved this as LE_Filter: SELECT "Workforce Management - Worker Assignment Real Time"."Legal Employer"."Name", "Workforce Management - Worker Assignment Real Time"."Legal Employer"."Status", DESCRIPTOR_IDOF("Workforce…

Could you please provide the steps you are following, that is leading you to the Excel with column size issue (for prompts)?

Please go ahead and create an SR for this issue. Please mention this CCC URL in the SR and inform that this was already reviewed by Appstech-BI analyst. Please share the SR number (in this forum), once you create the same

Could you please try the first 3 steps of the solution part of the below document and see, if the upload meets your expectation or not? Https://egsy-test.fa.us2.oraclecloud.com/xmlpserver/services/v2/CatalogService Issue (Doc ID 2730113.1)