Hi, Sorry I did not understand what you meant by "may I know in which column did you add it on?" You cannot cut paste SQL into the "Edit Formula" of a column in an analysis. I did not edit any column. This is the logical SQL that you generated on your advanced tab. So you can edit it there on your advanced tab. Or create a…

Hi, On page /analytics/saw.dll?IssueRawSQL this SQL execute with success. No error message. and if you add a sort NOTE This will tell you in anyone entered a timecard that day but all status of timecards whether they submitted for approval or just saved some time for later without submit for approval. Here is your user…

"Reported Time Cards"."Reported Hours"

Hi, Here is a pivot showing a month for which we have no timecards as "WO" and another that does have timecards. SQL with left outer join select t1.t , ifnull(t2.c,upper('wo')) as m from ( select all "Time"."Calendar Month" as t from "Workforce Management - Reported Time Cards Real Time" ) t1 left outer join ( select all…

But looking at your screen shot it is perhaps a "pivot table" in which case the "blank" as you call it is "no rows at all" for that day for that row in the pivot table so no matter what you do in your case statement it will not work because you have no row returned in the result set from your query. So if you did a left…

Hi "Reported Time Cards"."Reported Hours" = '' is not the same as "Reported Time Cards"."Reported Hours" is null Maybe try testing for null instead select all 0 s_0 , "Reported Time Cards"."Reported Hours" as n , (case when ("Reported Time Cards"."Reported Hours" is null) then upper('wo') else cast("Reported Time…

Hi, Yes that is already a SQL query in BI. So you can build your SQL query. Decide what columns you need. select all 0 s_0 #, … add cols here , "Facts - Approval Notification"."Count of Tasks" as s from "Human Capital Management - Approval Notification Archive Real Time" fetch first 7 rows only A query from a subject area…

Hi, Have a go at a query from "Human Capital Management - Approval Notification Archive Real Time"

Hi So your current query is "We need fact X by Product and Services Category". Assume you are query Supplier Registration - Supplier Real Time? In the screen shot we can only see the presentation table of your fact. This tables has 2 facts "Count of Registration Requests" and "Approval time in Days". You do not have…

Hi Menna, The cost center data may be empty either because you have not configured cost centres on the departments or your user does not have data access to view this data. If the issue is data access then even if you get no data found you can view log in manage sessions to get the physical sql on the application tables…

Hi, Much of the applicants in recruiting can NOT join to worker HR because nothing exists to join to. Do you mean only the candidates who accepted an offer on a job requisition in a job application who were automatically added by recruiting with a work relationship assignment as pending workers in Human Resources in HCM in…

Hi, The redwood links are there of the second page "Redwood Quick Actions" For example https:/../fscmUI/redwood/time/existing-timecards/view-summary

Hi , Try using the same method for both queries. Obviously you can build up your custom analysis using the user interface to select columns and add filters. I actually did these 2 queries as new analysis after selecting the subject area then looked at the sql in the advanced tab. Query 2 error is a syntax cut paste error…

Hi, To view the list of deep links available go to Select Navigator, select Show More. In Tools select work area Deep Links. For example, exist 2 deep links to view my "Exiting Time Cards" PERSON_TIME_WORKAREA PERSON_TIME_WORKAREA_RUI

Hi Financial Reporting Studio FRS is both in application Financials in ERP AND in application Enterprise Performance Management EPM in ERP. FRS in financials is used to build financial reports on cubes like general ledger balances cube. FRS in EPM is used to build reports on whatever cubes you setup in EPM. In both cases…

Hi Protyush, What is the problem to be solved. When you run the analysis using Open does it return no data ? In your session does this variable have no value? select all 0 s_0 , VALUEOF(NQ_SESSION.FLAG_Y_LOOKUP_MEANING) as s from "Procurement - Pending Change Orders Real Time" order by 1 ASC NULLS LAST, 2 ASC NULLS LAST…

Hi, You must extract each view object to CSV then join them post extract using whatever you are doing with the data outside of oracle. Or you need a custom view object in the first place to replace the 2 pre-defined view objects.

Ivony Ann, Did you click the Issue SQL button to get some results before you clicked View Log? Also make sure the log level was set to 2 and that the checkbox for presentation cache is ticked before you click Issue SQL.

Hi, In your analysis in OTBI you press this button here "Combine results based on …". The number and data type of columns in all query must match. Select the row in the result columns to edit each query. Remember to add filters on each query. Select Result Columns to manage the combined columns. For more information read…

Hi Harminder, OTBI is a read only tool for analytics and reporting. It has no functionality to purge data. You will need to post this question on the correct forum with the people who use HCM.