Query diplay performance issue

[Former Member]

Dear Guru's

We have a Query based on Master Data Info Object 'Eg:- Equipment', This has several Info Objects in the Query nearly 23 objects.

now when i give Equipment number in S.screen i am not able to see the complete data for 'Service Details' info obj, for some rows it shows 'Un Assigned'.(I think This is due to problem with memory). But if i remove some Info Objects from the Query and keep only 10 objects, i can see complete data for Info obj 'Service Details' in all rows.

Now how can i get complete data for 'Service Details' infoobject in all rows by keeping all the 23 info objects in the Query.

Hope you understand the issue.

Thanks in Adv,

Dev

[yogesh8984 · Accepted solution]

Hi,

The system is not able to cache the huge data to be displayed in the report output.

You have to restrict the output by giving little granular selections.

Regards,

Yogesh.

[Former Member · Accepted solution]

Hi

Thanks for the reply,

But is there any NOTE like thing to be applied to slove this issue.

Thanks in Adv

Dev

[former_member345199]

Hi,

Try these Notes.

Also with these notes you will find other related notes which may be helpful.

OSS notes to improve the query performence

557870 'FAQ BW Query Performance'

130696 - Performance trace in BW

567746 - Composite note BW 3.x performance: Query & Web applications

340246 - Techn. performance: Overview of statistics

1111470 Poor performance during filtering with many single

1039781 Input-ready query: Performance

1101143 Collective note: BEx Analyzer performance

Hope this helps.

Thanks,

JituK

[Former Member]

Dear All,

Thanks a lot dude's... i am also searching notes for this...if i find exact answer ...will post it back..

All i can greet is by assigned points for your kindly help...

Dev

[Former Member]

No idea mate...search SDN or NOTES.SAP.COM

[Former Member]

Yes, this is a memory issue. You need to talk to BASIS guy to increate the system parameter. Meanwhile, use a variable for 0Equipment. While running the query, run it for only few equipment no. This will display all the 23 objects.

Thanks..

Shambhu