OTBI: Data is reducing when adding # of Activites fact

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,