You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI: How can we use a generic month in a report

Received Response
7
Views
1
Comments
edited Mar 19, 2021 11:10AM in Sales 1 comment

Summary

OTBI: How can we use a generic month in a report

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!