select count(*) should equal the # of rows select * — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

select count(*) should equal the # of rows select *

Submitted
3
Views
0
Comments
gbacskai
gbacskai Rank 1 - Community Starter
edited May 8, 2025 10:22PM in Oracle Transactional Business Intelligence Idea Lab

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Deloitte Touche Tohmatsu (Deloitte Australia)

Description (Required):

When using OTBI the Following quieries should give back consitent results:

select count(*) from EXTERNAL('ADF', '"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'FscmTopModelAM.FinFunBusinessUnitsAM.BusinessUnitPVO' as t

Result: Count = 565


select * from EXTERNAL('ADF', '"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'FscmTopModelAM.FinFunBusinessUnitsAM.BusinessUnitPVO' as t

Result: 4 rows

Use Case and Business Need (Required):

  • Simple reconciliation
  • When I extracted rows via BICC should check it in the source system the extract is correct

Enhancement Request / Service Request:

OTBI

1
Up
1 votes

Submitted · Last Updated