Updateable BAQ - Parameter drop down

I don't have the details at my fingertips to give you a step by step example but if you link it to Plants table you should get only the plants in that table.  Also if you deploy the dashboard you can do more under the hood customization where you should be able to limit the plants to a subset of plants if there are more plants in plants then you want to show plants versus the total number of plants.  :)


Jim Kinneman

Encompass Solutions, Inc.

Is there a way to have a parameter drop down selection on an updateable BAQ?  We want to be able to select from an option of three plant locations (i.e. GA, WI, MN) from the jobhead.plant field.  If we can't select from the jobhead.plant field, is there a way to manually enter those selections into a drop down item to select from the jobhead.plant field?

If you put it into a dashboard you can customize it to use a combo.


Jim Kinneman

Encompass Solutions, Inc

You could add a parameter to the BAQ set as a dropdownlist type that can pull from another BAQ. Whenever the use hits refresh they will be presented with this dropdown to filter.



From: "Chang, Chia" <cchang@...>
To: vantage@yahoogroups.com
Sent: Thursday, December 5, 2013 12:04 PM
Subject: RE: [Vantage] RE: Updateable BAQ - Parameter drop down

#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 #ygrps-yiv-1405943749yiv4923743236 --

#ygrps-yiv-1405943749yiv4923743236 .ygrps-yiv-1405943749yiv4923743236ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236photo-title
a,
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236photo-title a:active,
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236photo-title a:hover,
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236attach-table div.ygrps-yiv-1405943749yiv4923743236attach-row {
clear:both;}

#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236attach-table div.ygrps-yiv-1405943749yiv4923743236attach-row div {
float:left;}

#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236ygrp-file {
width:30px;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236attach-table div.ygrps-yiv-1405943749yiv4923743236attach-row div div a {
text-decoration:none;}

#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236attach-table div.ygrps-yiv-1405943749yiv4923743236attach-row div div span {
font-weight:normal;}

#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 #ygrps-yiv-1405943749yiv4923743236

filtered #ygrps-yiv-1405943749yiv4923743236 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236
#ygrps-yiv-1405943749yiv4923743236 p.ygrps-yiv-1405943749yiv4923743236MsoNormal, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 li.ygrps-yiv-1405943749yiv4923743236MsoNormal, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 a:link, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 span.ygrps-yiv-1405943749yiv4923743236MsoHyperlink
{color:blue;text-decoration:underline;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 a:visited, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 span.ygrps-yiv-1405943749yiv4923743236MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 code
{}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 pre
{margin:0in;margin-bottom:.0001pt;font-size:10.0pt;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 tt
{}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 span.ygrps-yiv-1405943749yiv4923743236HTMLPreformattedChar
{}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 p.ygrps-yiv-1405943749yiv4923743236attach, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 li.ygrps-yiv-1405943749yiv4923743236attach, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236attach
{margin-right:0in;margin-left:0in;font-size:9.0pt;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 p.ygrps-yiv-1405943749yiv4923743236bold, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 li.ygrps-yiv-1405943749yiv4923743236bold, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236bold
{margin-right:0in;margin-left:0in;font-size:10.0pt;font-weight:bold;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 p.ygrps-yiv-1405943749yiv4923743236green, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 li.ygrps-yiv-1405943749yiv4923743236green, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236green
{margin-right:0in;margin-left:0in;font-size:12.0pt;color:#628C2A;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 p.ygrps-yiv-1405943749yiv4923743236replbq, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 li.ygrps-yiv-1405943749yiv4923743236replbq, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236replbq
{margin:3.0pt;font-size:12.0pt;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 p.ygrps-yiv-1405943749yiv4923743236ad, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 li.ygrps-yiv-1405943749yiv4923743236ad, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236ad
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 p.ygrps-yiv-1405943749yiv4923743236underline, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 li.ygrps-yiv-1405943749yiv4923743236underline, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236underline
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 span.ygrps-yiv-1405943749yiv4923743236yshortcuts
{}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 p.ygrps-yiv-1405943749yiv4923743236ad1, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 li.ygrps-yiv-1405943749yiv4923743236ad1, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236ad1
{margin-right:0in;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 p.ygrps-yiv-1405943749yiv4923743236ad2, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 li.ygrps-yiv-1405943749yiv4923743236ad2, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236ad2
{margin-right:0in;margin-bottom:7.5pt;margin-left:0in;font-size:12.0pt;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 p.ygrps-yiv-1405943749yiv4923743236underline1, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 li.ygrps-yiv-1405943749yiv4923743236underline1, #ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236underline1
{margin-right:0in;margin-left:0in;font-size:12.0pt;text-decoration:underline;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 span.ygrps-yiv-1405943749yiv4923743236yshortcuts1
{font-weight:bold;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 span.ygrps-yiv-1405943749yiv4923743236yshortcuts2
{font-weight:normal;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 span.ygrps-yiv-1405943749yiv4923743236EmailStyle34
{color:#1F497D;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 .ygrps-yiv-1405943749yiv4923743236MsoChpDefault
{font-size:10.0pt;}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 div.ygrps-yiv-1405943749yiv4923743236WordSection1
{}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236
filtered #ygrps-yiv-1405943749yiv4923743236 {}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {font-family:Symbol;}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {font-family:Wingdings;}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {font-family:Wingdings;}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {font-family:Wingdings;}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {font-family:Wingdings;}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {font-family:Wingdings;}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {font-family:Wingdings;}
#ygrps-yiv-1405943749 filtered #ygrps-yiv-1405943749yiv4923743236 {font-family:Wingdings;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 ol
{margin-bottom:0in;}
#ygrps-yiv-1405943749 #ygrps-yiv-1405943749yiv4923743236 ul
{margin-bottom:0in;}
#ygrps-yiv-1405943749



Is there a way to set it up as a parameter prompt instead of a tracker combo in the dashboard?  The reason for doing this is to limit the number of selections at the BAQ level through a parameter instead of a filter combo on the dashboard for performance.
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jckinneman@...
Sent: Wednesday, December 04, 2013 8:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Updateable BAQ - Parameter drop down
 
 
If you put it into a dashboard you can customize it to use a combo.
 
Jim Kinneman
Encompass Solutions, Inc




We tried this but can we pull from the same BAQ?  When we tried this, we were getting all the data in the drop down list even though we only have three plants.  We didn’t want to have to pull from a separate BAQ.  If this isn’t possible, can we manually create the drop down list selection to query off of the jobhead.plant field?

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
Sent: Thursday, December 05, 2013 12:54 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RE: Updateable BAQ - Parameter drop down

 

 

You could add a parameter to the BAQ set as a dropdownlist type that can pull from another BAQ. Whenever the use hits refresh they will be presented with this dropdown to filter.

 

 


From: "Chang, Chia" <cchang@...>
To: vantage@yahoogroups.com
Sent: Thursday, December 5, 2013 12:04 PM
Subjec t: RE: [Vantage] RE: Updateable BAQ - Parameter drop down

 

 

Is there a way to set it up as a parameter prompt instead of a tracker combo in the dashboard?  The reason for doing this is to limit the number of selections at the BAQ level through a parameter instead of a filter combo on the dashboard for performance.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jckinneman@...
Sent: Wednesday, December 04, 2013 8:25 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Updateable BAQ - Param eter drop down

 

 

If you put it into a dashboard you can customize it to use a combo.

 

Jim Kinneman

Encompass Solutions, Inc