OTBI: How can we use a generic month in a report
Summary
OTBI: How can we use a generic month in a reportContent
Hi,
Attached is an nquerylog for a report. We want that it should show # of Open opportunities from the creation date of the opportunity and # of Closed Opty from the Actual Close date.
As of now it is showing Enterprise Period by Actual Close Date.
Attached screenshots and logs for your reference.
Version
20D (11.13.20.10.0)Code Snippet
[2021-03-19T07:25:23.185-00:00] [OracleBIServerComponent] [TRACE:2] [] [] [ecid: 005jTuUVqr04Use5xbL6iW0007D_00010l,0:4:1:1:3] [tid: be312700] [messageid: USER-0] [requestid: 1cb70068] [sessionid: 1cb70000] [username: atifm] ############################################## [[
-------------------- SQL Request, logical request hash:
edbaa0f4
SET VARIABLE QUERY_SRC_CD='Report',SAW_SRC_PATH='/shared/Custom/SALES REPORTS/SLT Reports/EBU Individual (Without Activities)',PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Sales - CRM Pipeline"."Employee"."Employee Name" s_1,
"Sales - CRM Pipeline"."Opportunity"."Status Code" s_2,
"Sales - CRM Pipeline"."Sales Resource Hierarchy"."Current Level 1 Resource Organization Name" s_3,
"Sales - CRM Pipeline"."Time"."Enterprise Period" s_4,
SORTKEY("Sales - CRM Pipeline"."Time"."Enterprise Period") s_5,
CASE WHEN "Sales - CRM Pipeline"."Resource Quota Facts"."Resource Quota" >0 THEN "Sales - CRM
Tagged:
0