Not all rows are coming to BEx report output

[Former Member]

Hi Experts,

We have got a Bex report in which all the rows are not coming for a specific filter. Equipment Type 0EQUIPMENT in this case.

Report is based on master data infoobject 0EQUIPMENT.

Infoprovider is having all the data for single equipment type but when we execute report in BEx we are not getting all the related data.

If i add one KF to the report column then we are getting all the records and upon removing that again only 2 records.

Have anyone faced this kind of issue?

Note:Query does not have any filter related to that equipment.

Regards,

Shashank

[Former Member]

HI,

Issue is resolved now.

What was the actual issue?:- Infoobject was having BWA index which was causing the problem, we have delete the index and now we are getting the desired output.

Thanks all for your help..

Regards,

Shashank

[Former Member]

Hi Shashank,

Please remove suppress zero option from query property. It might happen that for Filter A1, you might have Age w/ Mfg Date has only 2 records for which 0ACQ has 0 value.

Thanks,

Shailesh.

[Former Member]

Hi Shailesh,

There is no suppress zero property set for the query.

Regards,

Shashank

[Former Member]

Hi,

your report is on top of equipment number infoobject alone ? or ino object and an infoprovider ?

please share some sample data and query layout .

[Former Member]

Hi Jyothi,

My report is on infoobject(Infoprovider) only.

With Equipment Type Filter A1, getting only 2 records
Equipment Type	Assignment	Equipment	Age w/ Mfg Date (KF)
A1	AA1	A1-1	10
		A1-2	10
Here no specific KF is added
Equipment Type	Assignment	Equipment	Age w/ Mfg Date (KF)	0ACQ_VALUE
A1	AA1	A1-1	10	$100
		A1-2	10	$100
		A1-3	10	$100
		A1-4	10	$100
After adding 0ACQ_VALUE KF I am getting all the records for that equipment type

[Former Member]

Hi,

so there is a filter on equipment type as "A1" ? was it a static filter? or optimal filter? how is the kefigure age w/mfg date defined? also, this kefigure is there in two scenarios which you mentioned, where is 0acq_value kf ?

can you share query designer layout of this report ?

[Former Member]

Hi Jyothi,

so there is a filter on equipment type as "A1" ? -- Yes,

was it a static filter? or optimal filter? -- This is a dynamic filter can apply once report is executed.

how is the kefigure age w/mfg date defined? -- This is standard filed coming from 0EQUIPMENT DS.

also, this kefigure is there in two scenarios which you mentioned, where is 0acq_value kf ? -- its as shown below aditional column.

With Equipment Type Filter A1, getting only 2 records
Equipment Type	Assignment	Equipment	Age w/ Mfg Date (KF)
A1	AA1	A1-1	10
		A1-2	10
Here no specific KF is added
Equipment Type	Assignment	Equipment	Age w/ Mfg Date (KF)	0ACQ_VALUE (KF)
A1	AA1	A1-1	10	$100
		A1-2	10	$100
		A1-3	10	$100
		A1-4	10	$100
After adding 0ACQ_VALUE KF I am getting all the records for that equipment type

[Former Member]

try to run  the same query in RSRT without adding 0acq_value  and see the reuslts

[Former Member]

Hi Jyothi,

I have tried that in RSRT, from there only I get to know the issue.

Our base query does not have 0ACQ_VALUE KF added originally.

Suddenly we get this issue and seeing only 2 records.

Then after analyzing we tried to add 0ACQ_VALUE and upon addition we are getting all the values.

We cant tell clients that if we add this KF it will work, because they need to know RCA for the same.

Because it was working earlier.

Regards,

Shashank