Yes you can do it by edit Report Links on the analysis properties on the page, or report links on the page properties, or report links in dashboard properties for all pages.

Hi, Yes you can use variable in your where clause in your filter to reference function CURRENT_DATE. select all 0 s_0 , "Time"."Report Start Date" s_day_date , timestampadd(sql_tsi_day,-7,CURRENT_DATE) s_from , timestampadd(sql_tsi_day,0,CURRENT_DATE) s_to from "OTBI Usage Real Time" where ("Time"."Report Start Date" >=…

Hi, Yes if the analysis is not prompted but has hard coded values in filters then assume the logical SQL is probably the same in both cases. So the only difference must be the user who runs it. You can check in the session logs to validate that the logical sql passed to the metadata repository database was the same but…

Hi, Try this SQL select all 0 s_0 , "Department"."Department Name" as department , "Department_GL Cost Center Information"."Department_ORG_INFORMATION_EFF_PER_GL_COST_CENTER_INFO__COST_CENTER_VALUESET" as costcenter_valueset_id , "Department_GL Cost Center…

Yes. Go to documents top task Analyze and Report Then "Review Data Lineage"

Regie, Is this business process? Materials Management and Logistics Ensure that material is effectively managed, from receipt through consumption, to meet customer demand. The process includes inbound logistics, inventory management, and outbound logistics activities. Successfully manage customer demand in a cost-effective…

Hi Regie, Your question is a bit vague. When you say "create at OTBI" assume you mean to create a query from the subject areas to view data in either an analysis in OTBI (blue) or in a data model for a report in OTBI (yellow). What do you mean by "using the review completed transactions function"? What is this function?…

Hi Melek, E12096 is the document for the very much older version 10 OBI. In OTBI you are using version 12 OBI. The functionality may not have changed all that much but better to use the correct documents otherwise you may miss out on some of the great features that were introduced in 11g and 12c. For example Oracle® Fusion…

Hi Abi, Your question is about marketing automation in Customer Experience in Oracle Fusion Cloud Applications. This community is Oracle Transactional Business Intelligence (OTBI) in Oracle Fusion Cloud Applications. OTBI is a read only tool for analytics and reporting. As a SaaS customer you cannot store anything in OTBI.…

Hi, Assume when you say ran the "report" manually you actually mean that you "ran the analysis manually" because this is an analysis in OTBI not a report in OTBI. So we need to debug 2 scenario; 1 analysis executed online in browser and 1 analysis scheduled as an intelligence robot "agent". Was it exactly the same query…

Hi Gamidi, No need to provide extra information. This is a frequently asked question. Yes if you build a data model which returns no data found when you execute the report in OTBI then yes the output format as CSV is empty without even a line 1 with the column headers. You do not even get a file if you are using bursting.…

Hi, This is I assume the correct forum for you to use for this question Fusion HCM Analytics. Please ask the admin to move it across out of OTBI.

Hi, This forum is NOT for Fusion Analytics Warehouse (FAW) recently rebranded Fusion Data Intelligence. This forum is for Oracle Transactional Business Intelligence (OTBI) inside Software as a Service (SaaS) suite Oracle Fusion Cloud Applications. Looks like your question is NOT a query from a subject area in OTBI. Subject…

Hi, This depends on your definition of a "working day". Weekends: In your legislative region your definition might be to simply exclude weekends. So that bit is easy. You just add a filter to your aggregate to count days only if the day of the week is Monday to Friday not Saturday, Sunday. Public Holidays: are more…

Hi Oriana, Which subject area are you using? What is Your query? Please post here from the advanced tab in your analysis the logical sql from the simplest query that demonstrate your problem statement. May I assume you are using Recruiting - Recruiting Real Time is it this query select all 0 s_0 , cast("Job Requisition -…

Hi Patrick, Well spotted. Yes that is right. It is not a solution. This only works I guess for Export if you then select Data CSV which is independent of format else you get nothing. So yes it is useless.

Hi, Good news! Yes this can be done. In the presentation tables in your subject areas as you say you have 2 types or presentation columns; blue ones "attributes" (known as a dimension) and "yellow rulers" "measures" (known as facts). It is true that in the view type a of Performance Tile you can only select measures not…

Hi, Ok I re read your original question. To rank supplier by invoice amount but only for invoices in a date range. I think first you need a query to get all the child payables transactions that make up the invoice amount on your purchase orders filter to select only invoices created in a date range from your prompt with a…

Hi VC You said you needed sum of invoice amount. But now you are counting volume of purchase orders. But assume you still want the aggregate for each supplier? Why did you add created date? Anyway the column in your BY clause is not a column hence your syntax error is expected. If you want 2+ columns in BY then they need…

Hi Rebecca, Maybe you can post a screen shot of the configuration you have done to update a "user on termination" in work area Setup and Maintenance. Which offering? Which functional area? Which task? Is it role deprovisioning? @John Hung-Oracle Hi John, I think this is perhaps the correct forum. Subject area User System…