: BAQ with parameters

8.03.409C you can write BAQ reports that use options for dates as parameters – the user can pick the dates.  Or, you can set criteria in the BAQ for table.date

>= today – 30 and table.date <= today to get always one month for example…

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 30, 2014 2:07 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] : BAQ with parameters

 

 

We use Vantage 8.0.3.407A on SQL.. I am wondering does this lets us created BAQs with parameters 9start & end date) or in other words can we write dynamic BAQs?

 

Best regards

 

Sanjay Kukreja

<!-- #ygrps-yiv-1021137148 _filtered #ygrps-yiv-1021137148 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1021137148 {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #ygrps-yiv-1021137148 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-1021137148 {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-1021137148 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} _filtered #ygrps-yiv-1021137148 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-1021137148 #ygrps-yiv-1021137148 p.ygrps-yiv-1021137148MsoNormal, #ygrps-yiv-1021137148 li.ygrps-yiv-1021137148MsoNormal, #ygrps-yiv-1021137148 div.ygrps-yiv-1021137148MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-1021137148 a:link, #ygrps-yiv-1021137148 span.ygrps-yiv-1021137148MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-1021137148 a:visited, #ygrps-yiv-1021137148 span.ygrps-yiv-1021137148MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-1021137148 p {

margin-right:0cm;

margin-left:0cm;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1021137148 code
{
font-family:“Courier New”;}
#ygrps-yiv-1021137148 pre
{

margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-1021137148 tt
{
font-family:“Courier New”;}
#ygrps-yiv-1021137148 p.ygrps-yiv-1021137148MsoAcetate, #ygrps-yiv-1021137148 li.ygrps-yiv-1021137148MsoAcetate, #ygrps-yiv-1021137148 div.ygrps-yiv-1021137148MsoAcetate
{

margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:“Tahoma”, “sans-serif”;}
#ygrps-yiv-1021137148 span.ygrps-yiv-1021137148cat
{}
#ygrps-yiv-1021137148 span.ygrps-yiv-1021137148ct
{}
#ygrps-yiv-1021137148 span.ygrps-yiv-1021137148HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-1021137148 p.ygrps-yiv-1021137148attach, #ygrps-yiv-1021137148 li.ygrps-yiv-1021137148attach, #ygrps-yiv-1021137148 div.ygrps-yiv-1021137148attach
{

margin-right:0cm;

margin-left:0cm;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-1021137148 p.ygrps-yiv-1021137148bold, #ygrps-yiv-1021137148 li.ygrps-yiv-1021137148bold, #ygrps-yiv-1021137148 div.ygrps-yiv-1021137148bold
{

margin-right:0cm;

margin-left:0cm;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1021137148 p.ygrps-yiv-1021137148green, #ygrps-yiv-1021137148 li.ygrps-yiv-1021137148green, #ygrps-yiv-1021137148 div.ygrps-yiv-1021137148green
{

margin-right:0cm;

margin-left:0cm;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-1021137148 p.ygrps-yiv-1021137148replbq, #ygrps-yiv-1021137148 li.ygrps-yiv-1021137148replbq, #ygrps-yiv-1021137148 div.ygrps-yiv-1021137148replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1021137148 p.ygrps-yiv-1021137148ad, #ygrps-yiv-1021137148 li.ygrps-yiv-1021137148ad, #ygrps-yiv-1021137148 div.ygrps-yiv-1021137148ad
{

margin-right:0cm;

margin-left:0cm;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1021137148 p.ygrps-yiv-1021137148underline, #ygrps-yiv-1021137148 li.ygrps-yiv-1021137148underline, #ygrps-yiv-1021137148 div.ygrps-yiv-1021137148underline
{

margin-right:0cm;

margin-left:0cm;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1021137148 span.ygrps-yiv-1021137148yshortcuts
{}
#ygrps-yiv-1021137148 p.ygrps-yiv-1021137148ad1, #ygrps-yiv-1021137148 li.ygrps-yiv-1021137148ad1, #ygrps-yiv-1021137148 div.ygrps-yiv-1021137148ad1
{

margin-right:0cm;

margin-left:0cm;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1021137148 p.ygrps-yiv-1021137148ad2, #ygrps-yiv-1021137148 li.ygrps-yiv-1021137148ad2, #ygrps-yiv-1021137148 div.ygrps-yiv-1021137148ad2
{

margin-right:0cm;
margin-bottom:7.5pt;
margin-left:0cm;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1021137148 p.ygrps-yiv-1021137148underline1, #ygrps-yiv-1021137148 li.ygrps-yiv-1021137148underline1, #ygrps-yiv-1021137148 div.ygrps-yiv-1021137148underline1
{

margin-right:0cm;

margin-left:0cm;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-1021137148 span.ygrps-yiv-1021137148yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1021137148 span.ygrps-yiv-1021137148yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-1021137148 span.ygrps-yiv-1021137148BalloonTextChar
{

font-family:“Tahoma”, “sans-serif”;}
#ygrps-yiv-1021137148 span.ygrps-yiv-1021137148EmailStyle38
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-1021137148 .ygrps-yiv-1021137148MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-1021137148 {
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
#ygrps-yiv-1021137148 div.ygrps-yiv-1021137148WordSection1
{}
#ygrps-yiv-1021137148
_filtered #ygrps-yiv-1021137148 {
}
_filtered #ygrps-yiv-1021137148 {

font-family:Symbol;}
_filtered #ygrps-yiv-1021137148 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-1021137148 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1021137148 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1021137148 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1021137148 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1021137148 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1021137148 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1021137148 {

font-family:Wingdings;}
#ygrps-yiv-1021137148 ol
{margin-bottom:0cm;}
#ygrps-yiv-1021137148 ul
{margin-bottom:0cm;}
–>

We use Vantage 8.0.3.407A on SQL… I am wondering does this lets us created BAQs with parameters 9start & end date) or in other words can we write dynamic BAQs?

 

Best regards

 

Sanjay Kukreja