Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
OTBI: Data is reducing when adding # of Activites fact — Cloud Customer Connect
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: Data is reducing when adding # of Activites fact

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

Summary

Data is reducing when adding # of Acitivites fact in Subject Area: Sales - CRM Pipeline

Content

Hi

We are using subject area: Sales - CRM Pipeline.
When adding the Fact: "Activity Facts"."# of Activities" , the data is reducing in "Opportunity Extension"."Extension Attribute Number 008"

We want that the data should remain same in"Opportunity Extension"."Extension Attribute Number 008" when we add "Activity Facts"."# of Activities" in a table.

Please refer attachements for logs and screenshots.

Regards,

Version

20D (11.13.20.10.0)

Code Snippet

[2021-03-19T07:13:10.699-00:00] [OracleBIServerComponent] [TRACE:2] [] [] [ecid: 005jTtmpts34Use5xbL6iW0007D_0000O5,0:2:1:9:3] [tid: bf584700] [messageid: USER-0] [requestid: 1cb7005c] [sessionid: 1cb70000] [username: atifm] ############################################## [[
-------------------- SQL Request, logical request hash:
306d8f7a
SET VARIABLE QUERY_SRC_CD='Report',PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
   0 s_0,
   "Sales - CRM Pipeline"."Activity Facts"."# of Activities" s_1,
   "Sales - CRM Pipeline"."Resource Quota Facts"."Resource Quota" s_2,
   SUM("Sales - CRM Pipeline"."Opportunity Extension"."Extension Attribute Number 008") s_3
FROM "Sales - CRM Pipeline"
WHERE
("Employee"."Employee Name" = 'Fahad Ali')
ORDER BY 1
FETCH FIRST 75001 ROWS ONLY


]]
[2021-03-19T07:13:10.700-00:00] [OracleBIServerComponent] [TRACE:2] [] [] [ecid: 005jTtmpts34Use5xbL6iW0007D_0000O5,0:2:1:9:3] [tid: bf584700] [messageid: USER-23] [requestid: 1cb7005c] [sessionid: 1cb70000] [username: atifm] -------------------- General Query Info: [[
Repository: Star,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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