Database records are very less than transferred records

[srikanthbwbw]

Hi

I created report on 0TCT_MC01. AFter running the report, for 3 queries database records shows'0' and transferred records shows '4534'. How is it possible? There is no problem in mapping. there are 100 queries tat shows correctly. only 3 reports are showing 0 data base records.

thanks

SK

[former_member182470]

HI,

AFter running the report, for 3 queries database records shows'0'

Where did you confirm this? I doubt on this. If there is no data in the tables, then load does not bring 4534 records. This is not just possible.

Is your flow like this?

[srikanthbwbw]

Hi,

Guys I didnt say there is no data in the tables. I said i created a report on 0TCT_MC01 multiprovider and for all the query elements database records selected is more than transferred (This is expected) but for 3 queries database records shows 0 and transferred shows something like 4345 records.

Without having the technical content activated and without loading the data, how can I see the data in the report?

All my flow is fine and data loads are fine.

I will work on RSRT and give u all update.

Thanks

SK

[former_member182470]

OK. Now i have understood that you have seen the records count in RSRT-->Execute & Debug-->Display Statistics data.

Do not select cache data while debugging the query. I think it is picking data from the cache memory without hitting the database.

[KamalMehta]

Hi Sri , You mean to say that you have more data in the info providers beneath the MP but less in Query . If yes check the query definition ton verify are there are filters in the Query .

thanks

[Former Member]

Hi Sri,

Check that loaded request is available for reporting or not?

[KamalMehta]

Hi Sri ,

Have you activated the Technical content . Are the info providers gettting loaded there ?

Hvae you activated the statistics for relevant query and info provider suing RSDDSTAT?

Thanks

[RamanKorrapati]

Hi,

Its seems like issue with your query definition or passing input parameters. so check all the objects you kept at filter or conditions if any.

With the same selections you can check data at target level. try to generate query at RSRT and choose debug+ execute it.

Lets see what you get there.

Thanks

[anshu_lilhori]

Hi,

Start debugging from the query--Check for any restrictions or global filters .

With the same selection and restriction try to check the data on which that particularly query has been created.See if that displays the relevant data or not.

As you mentioned its displaying data for other which are made on top of that infoprovider then i guess it should be the issue with the query only.

Hope this helps.

Regards,

AL