Question Re: Adding query in business objects in Technology Q&A

Adding query in business objects

former_member1005241 — Mon, 09 May 2022 20:17:00 GMT

Hi,

Could anyone help me with the business objects query panel please. I'm a total newbie with this system and i'm trying to edit a query search my prior boss unsed.

I am trying to add a VAT Value column to the query panel, but when i run, this column has not been added.

Am i doing anything incorrectly?

Thanks for your help

Re: Adding query in business objects

AlexGourdet — Mon, 09 May 2022 20:17:14 GMT

Thank you for visiting SAP Community to get answers to your questions.

Since you're asking a question here for the first time, I'd like to recommend you with the following steps so you can get the most out of your community membership:

Please see: https://community.sap.com/resources/questions-and-answers as this resource page provides tips for preparing questions that draw responses from our members
Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,
-Alex

Re: Adding query in business objects

ayman_salem — Tue, 10 May 2022 04:31:49 GMT

The newly added query object is not automatically added to an existing table in the report, you should manually add a column with the added object to the table after you run the query successfully.

Re: Adding query in business objects

Ashish_Farkya1 — Sat, 02 Jul 2022 10:35:00 GMT

This is by design. Whenever you add objects to query and refresh the query for the first time, only those objects would be added to the table. Any subsequent addition of objects to the WebI query, you won't find them getting automatically added to the WebI report display ( table). Instead, you would see those objects available in the list of "available objects" in the query.

You can now drag and drop the newly added field to the table.

Hope this helps.

Cheers,

Ashish