Hi Group!
I found the follwoing thread from last year. In my case the BAQ is working fine, it updates the Part and PartPlant tables, but the updatable dashboard is updating the Part table only. Both tables are checked in the "Update Processing" tree and all required fields are included.
Mike Tonoyan
Natel Engineering
mtonoyan@...
I found the follwoing thread from last year. In my case the BAQ is working fine, it updates the Part and PartPlant tables, but the updatable dashboard is updating the Part table only. Both tables are checked in the "Update Processing" tree and all required fields are included.
Mike Tonoyan
Natel Engineering
mtonoyan@...
--- In vantage@yahoogroups.com, "Hellings, Lauren" <lauren.hellings@...> wrote:
>
> I did get it working… It was that I needed to include the ttPart table to be updated in the update processing section. Once I included that table the values began saving.
>
> Thank you,
>
> Lauren Hellings
> Business Analyst
> Cell: 832-472-1736
> email: lauren.hellings@...<mailto:lauren.hellings@...>
> www.c-p-i.com<http://www.c-p-i.com/>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joshua Giese
> Sent: Thursday, May 10, 2012 8:27 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Updatable BAQ/Dashboards
>
>
>
> Usually the issue is that native parent tables fields are not included in the BAQ. At least this has always been my issue, when I can make changes without error, but the saves done 'take'
>
> Example. If you are changing the PartPlant table and there are other tables involved, assuming the Part table is involved, you have to include the Part table Key Indexes that match the PartPlant key indexes. Likely if you ensure the PartPlant.Company, PartPlant.PartNum, Part.PartNum, and Part.Company are added to the 'display' of the BAQ it will start working. When you sync the values for the Update BPM make sure both the Part and PartPlant tables are checked in the tree ( referring to the Update BO Method)
>
> reply Signature
>
> Joshua Giese
> CTO
> 920.437.6400 Ext. 337
>
> ----- Original Message -----
>
> From: "Rick Hagy" <rhagy@...<mailto:rhagy%40openplan.com>>
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Sent: Thursday, May 10, 2012 5:41:06 PM
> Subject: Re: [Vantage] Updatable BAQ/Dashboards
>
> Is it working in the BAQ?
>
> Sent from my Verizon Wireless Phone
>
> ----- Reply message -----
> From: "Hellings, Lauren" < lauren.hellings@...<mailto:lauren.hellings%40c-p-i.com> >
> To: " vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> " < vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> >
> Subject: [Vantage] Updatable BAQ/Dashboards
> Date: Thu, May 10, 2012 4:41 pm
>
> I have created an updatable BAQ/Dashboard for making changes to the min/max quantities on the PartPlant record. There are a variety of tables in the query, but I only want to update those fields. I have gotten to the point of creating the dashboard and I can open it and have the ability to change the value in these fields, but the changes don't save.
>
> Any suggestions on what I might be doing wrong?
>
> Thank you,
>
> Lauren Hellings
> Business Analyst
> Office: 281-207-4613
> Cell: 832-472-1736
> Fax: 281-207-0672
> email: lauren.hellings@...<mailto:lauren.hellings%40c-p-i.com> <mailto: lauren.hellings@...<mailto:lauren.hellings%40c-p-i.com> >
> www.c-p-i.com<<http://www.c-p-i.com%3c> http://www.c-p-i.com/ >
>
> ----------Legal Disclaimer----------
>
> The information contained in this message may be privileged and confidential, and is intended solely for the use of the named addressee. No other person is authorized to access, copy or re-use this message (or any information contained herein). If you are not the intended recipient, please notify us immediately by replying to this message and delete it from your computer.
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
> ----------Legal Disclaimer----------
>
> The information contained in this message may be privileged and confidential, and is intended solely for the use of the named addressee. No other person is authorized to access, copy or re-use this message (or any information contained herein). If you are not the intended recipient, please notify us immediately by replying to this message and delete it from your computer.
>
>
>
> [Non-text portions of this message have been removed]
>