BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Number of records the database returned for dataprovider


 
Search this topic... | Search Auditor... | Search Box
Register or Login to Post    Forum Index -> Other Products -> Auditor  Previous TopicPrint TopicNext Topic
Author Message
Katsiaryna
Forum Member
Forum Member



Joined: 21 Nov 2017

Posts: 3



PostPosted: Tue Nov 21, 2017 8:21 am 
Post subject: Number of records the database returned for dataprovider

I need to have this charachteristic after every Refresh event in SAP BO. In audit tables "Refresh" event has the event detail "Number of Rows" but it is for the whole report.
Is there any possibility to find this number for each dataprovider (in system tables, logs, etc)?
Thanks in advance.
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6232
Location: Connecticut, USA


flag
PostPosted: Tue Nov 21, 2017 1:07 pm 
Post subject: Re: Number of records the database returned for dataprovider

That Refresh event that you see is by data provider, not the whole document.
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 13816
Location: England


flag
PostPosted: Tue Nov 21, 2017 3:09 pm 
Post subject: Re: Number of records the database returned for dataprovider

Welcome to Bicon_mrgreen.gifB!

I'll move this to the Auditor forum for you....Good Luck icon_cool.gif

_________________
My latest idea....
Back to top
Katsiaryna
Forum Member
Forum Member



Joined: 21 Nov 2017

Posts: 3



PostPosted: Wed Nov 22, 2017 3:59 am 
Post subject: Re: Number of records the database returned for dataprovider

I've checked it, the detail Number of Rows (event_detail_type_id = 63) is unique for an event_id, which is generated for one Document, not Dataprovider. And if Document consists of several Dataproviders then Number of Rows is equal to sum of records' numbers of all dataproviders.
Maybe we should use any special settings in CMC or I should look at another fields?
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6232
Location: Connecticut, USA


flag
PostPosted: Wed Nov 22, 2017 7:55 am 
Post subject: Re: Number of records the database returned for dataprovider

Yes, you are right. There are multiple event detail records for each data provider, but the total row count and size is only for the document. I believe this was different in XI3, in which each event was associated with a single data provider refresh.

I think the only way to get the information you want is to use the REST API to open each report and get the row count from the data providers.

Joe
Back to top
Katsiaryna
Forum Member
Forum Member



Joined: 21 Nov 2017

Posts: 3



PostPosted: Thu Nov 23, 2017 10:43 am 
Post subject: Re: Number of records the database returned for dataprovider

Unfortunatelly it's only for saved documents and only for last action icon_sad.gif And my task is to get this number for all users' actions.
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6232
Location: Connecticut, USA


flag
PostPosted: Mon Nov 27, 2017 8:53 am 
Post subject: Re: Number of records the database returned for dataprovider

Then I think your only other possible option would be to mine the WebI system logs. That would be ugly, and I'm not even certain that the information is there.

This would be a good idea for the new influence site: https://influence.sap.com/sap/ino/#/campaign/891
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Other Products -> Auditor  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0110 seconds using 17 queries. (SQL 0.0029 Parse 0.0002 Other 0.0078)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo