Microsoft Access and Vantage

Well, as long as I understand the thread correctly...we use Access to
deliver our BI, that is our BI is done in Access. We use it ODBC to SQL.
There in we use a combination of VBA code and queries to pull and
manipulate our data, then add forms and/or reports with the native
charts and visuals it has and we have a solid BI solution. It does not
have the drag and drop object style of Business Objects universes, but
queries that have fields in them such as 'Gross Revenue', 'AllJobHours',
etc. can be used like universe objects and added to forms and reports
and then chart objects put on top of them to give visual meaning to the
data.

Security is managed via SQL; read/write, table and field access, etc.


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ken Taylor
Sent: Friday, April 04, 2008 10:06 AM
To: vantage@yahoogroups.com
Subject: Re: RE: [Vantage] Microsoft Access and Vantage



If it's not too much to ask, I'd like to also know. Thanks.

Ken

----- Original Message ----
From: Jasper Recto <jrecto@... <mailto:jrecto%40locper.com> >
To: "vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> "
<vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
Sent: Friday, April 4, 2008 5:12:38 AM
Subject: RE: RE: [Vantage] Microsoft Access and Vantage

Where did you start? How did you design it? What kind of information
does it give you?

I would like to do this but I don't know where to start.

Thanks,
Jasper

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com]On
Behalf Of Ian Hogan
Sent: Thursday, April 03, 2008 8:26 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Microsoft Access and Vantage

Absolutely, it works great!

____________ _________ _________ __

From: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>
[mailto: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>]
On Behalf
Of Jasper Recto
Sent: Thursday, April 03, 2008 12:28 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Microsoft Access and Vantage

Several users have mentioned that they use Access for their reporting.

Does anybody use Access as their Business Intelligence interface? Kind
of how VBI is used?

Thanks,
Jasper

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]


<!--

#ygrp-mkp{
border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px
14px;}
#ygrp-mkp hr{
border:1px solid #d8d8d8;}
#ygrp-mkp #hd{
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10p
x 0px;}
#ygrp-mkp #ads{
margin-bottom:10px;}
#ygrp-mkp .ad{
padding:0 0;}
#ygrp-mkp .ad a{
color:#0000ff;text-decoration:none;}
-->

<!--

#ygrp-sponsor #ygrp-lc{
font-family:Arial;}
#ygrp-sponsor #ygrp-lc #hd{
margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
#ygrp-sponsor #ygrp-lc .ad{
margin-bottom:10px;padding:0 0;}
-->

<!--

#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean,
sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean,
sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px
0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}

#ygrp-reco {
margin-bottom:20px;padding:0px;}
#ygrp-reco #reco-head {
font-weight:bold;color:#ff7900;}

#reco-grpname{
font-weight:bold;margin-top:10px;}
#reco-category{
font-size:77%;}
#reco-desc{
font-size:77%;}

#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-trans
form:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;pa
dding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a{
text-decoration:none;}

#ygrp-vital a:hover{
text-decoration:underline;}

#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc{
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-hei
ght:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o{font-size:0;}
.MsoNormal{
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq{margin:4;}
-->


__________________________________________________________
You rock. That's why Blockbuster's offering you one month of Blockbuster
Total Access, No Cost.
http://tc.deals.yahoo.com/tc/blockbuster/text5.com
<http://tc.deals.yahoo.com/tc/blockbuster/text5.com>

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
Several users have mentioned that they use Access for their reporting.

Does anybody use Access as their Business Intelligence interface? Kind of how VBI is used?

Thanks,
Jasper



[Non-text portions of this message have been removed]
Absolutely, it works great!



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Thursday, April 03, 2008 12:28 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Microsoft Access and Vantage



Several users have mentioned that they use Access for their reporting.

Does anybody use Access as their Business Intelligence interface? Kind
of how VBI is used?

Thanks,
Jasper

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
Where did you start? How did you design it? What kind of information does it give you?

I would like to do this but I don't know where to start.

Thanks,
Jasper

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Ian Hogan
Sent: Thursday, April 03, 2008 8:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Microsoft Access and Vantage



Absolutely, it works great!



________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Jasper Recto
Sent: Thursday, April 03, 2008 12:28 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Microsoft Access and Vantage

Several users have mentioned that they use Access for their reporting.

Does anybody use Access as their Business Intelligence interface? Kind
of how VBI is used?

Thanks,
Jasper

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
If it's not too much to ask, I'd like to also know. Thanks.


Ken



----- Original Message ----
From: Jasper Recto <jrecto@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Friday, April 4, 2008 5:12:38 AM
Subject: RE: RE: [Vantage] Microsoft Access and Vantage

Where did you start? How did you design it? What kind of information does it give you?

I would like to do this but I don't know where to start.

Thanks,
Jasper

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com]On Behalf Of Ian Hogan
Sent: Thursday, April 03, 2008 8:26 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Microsoft Access and Vantage

Absolutely, it works great!

____________ _________ _________ __

From: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com> [mailto: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>] On Behalf
Of Jasper Recto
Sent: Thursday, April 03, 2008 12:28 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Microsoft Access and Vantage

Several users have mentioned that they use Access for their reporting.

Does anybody use Access as their Business Intelligence interface? Kind
of how VBI is used?

Thanks,
Jasper

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]




<!--

#ygrp-mkp{
border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
#ygrp-mkp hr{
border:1px solid #d8d8d8;}
#ygrp-mkp #hd{
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
#ygrp-mkp #ads{
margin-bottom:10px;}
#ygrp-mkp .ad{
padding:0 0;}
#ygrp-mkp .ad a{
color:#0000ff;text-decoration:none;}
-->

<!--

#ygrp-sponsor #ygrp-lc{
font-family:Arial;}
#ygrp-sponsor #ygrp-lc #hd{
margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
#ygrp-sponsor #ygrp-lc .ad{
margin-bottom:10px;padding:0 0;}
-->

<!--

#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}

#ygrp-reco {
margin-bottom:20px;padding:0px;}
#ygrp-reco #reco-head {
font-weight:bold;color:#ff7900;}

#reco-grpname{
font-weight:bold;margin-top:10px;}
#reco-category{
font-size:77%;}
#reco-desc{
font-size:77%;}

#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a{
text-decoration:none;}

#ygrp-vital a:hover{
text-decoration:underline;}

#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc{
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o{font-size:0;}
.MsoNormal{
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq{margin:4;}
-->






____________________________________________________________________________________
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.
http://tc.deals.yahoo.com/tc/blockbuster/text5.com

[Non-text portions of this message have been removed]
That might work for me too, because our old system ran on access. We
are still using the sales quoting application that was built with access.

This would also be good for getting around the BAQ queries.

Thanks!

Lisa
--- In vantage@yahoogroups.com, Ken Taylor <ktaylorv@...> wrote:
>
> If it's not too much to ask, I'd like to also know. Thanks.
>
>
> Ken
>
>
>
> ----- Original Message ----
> From: Jasper Recto <jrecto@...>
> To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
> Sent: Friday, April 4, 2008 5:12:38 AM
> Subject: RE: RE: [Vantage] Microsoft Access and Vantage
>
> Where did you start? How did you design it? What
kind of information does it give you?
>
> I would like to do this but I don't know where to start.
>
> Thanks,
> Jasper
>
> -----Original Message-----
> From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com]On
Behalf Of Ian Hogan
> Sent: Thursday, April 03, 2008 8:26 PM
> To: vantage@yahoogroups .com
> Subject: RE: [Vantage] Microsoft Access and Vantage
>
> Absolutely, it works great!
>
> ____________ _________ _________ __
>
> From: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>
[mailto: vantage@yahoogroups .com<mailto:vantage% 40yahoogroups. com>]
On Behalf
> Of Jasper Recto
> Sent: Thursday, April 03, 2008 12:28 PM
> To: Vantage Groups (E-mail)
> Subject: [Vantage] Microsoft Access and Vantage
>
> Several users have mentioned that they use Access for their reporting.
>
> Does anybody use Access as their Business Intelligence interface? Kind
> of how VBI is used?
>
> Thanks,
> Jasper
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
> <!--
>
> #ygrp-mkp{
> border:1px solid #d8d8d8;font-family:Arial;margin:14px
0px;padding:0px 14px;}
> #ygrp-mkp hr{
> border:1px solid #d8d8d8;}
> #ygrp-mkp #hd{
>
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px
0px;}
> #ygrp-mkp #ads{
> margin-bottom:10px;}
> #ygrp-mkp .ad{
> padding:0 0;}
> #ygrp-mkp .ad a{
> color:#0000ff;text-decoration:none;}
> -->
>
> <!--
>
> #ygrp-sponsor #ygrp-lc{
> font-family:Arial;}
> #ygrp-sponsor #ygrp-lc #hd{
> margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
> #ygrp-sponsor #ygrp-lc .ad{
> margin-bottom:10px;padding:0 0;}
> -->
>
> <!--
>
> #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean,
sans-serif;}
> #ygrp-mlmsg table {font-size:inherit;font:100%;}
> #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica,
clean, sans-serif;}
> #ygrp-mlmsg pre, code {font:115% monospace;}
> #ygrp-mlmsg * {line-height:1.22em;}
> #ygrp-text{
> font-family:Georgia;
> }
> #ygrp-text p{
> margin:0 0 1em 0;}
> #ygrp-tpmsgs{
> font-family:Arial;
> clear:both;}
> #ygrp-vitnav{
> padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
> #ygrp-vitnav a{
> padding:0 1px;}
> #ygrp-actbar{
> clear:both;margin:25px
0;white-space:nowrap;color:#666;text-align:right;}
> #ygrp-actbar .left{
> float:left;white-space:nowrap;}
> .bld{font-weight:bold;}
> #ygrp-grft{
> font-family:Verdana;font-size:77%;padding:15px 0;}
> #ygrp-ft{
> font-family:verdana;font-size:77%;border-top:1px solid #666;
> padding:5px 0;
> }
> #ygrp-mlmsg #logo{
> padding-bottom:10px;}
>
> #ygrp-reco {
> margin-bottom:20px;padding:0px;}
> #ygrp-reco #reco-head {
> font-weight:bold;color:#ff7900;}
>
> #reco-grpname{
> font-weight:bold;margin-top:10px;}
> #reco-category{
> font-size:77%;}
> #reco-desc{
> font-size:77%;}
>
> #ygrp-vital{
> background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
> #ygrp-vital #vithd{
>
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
> #ygrp-vital ul{
> padding:0;margin:2px 0;}
> #ygrp-vital ul li{
> list-style-type:none;clear:both;border:1px solid #e0ecee;
> }
> #ygrp-vital ul li .ct{
>
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
> #ygrp-vital ul li .cat{
> font-weight:bold;}
> #ygrp-vital a{
> text-decoration:none;}
>
> #ygrp-vital a:hover{
> text-decoration:underline;}
>
> #ygrp-sponsor #hd{
> color:#999;font-size:77%;}
> #ygrp-sponsor #ov{
> padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
> #ygrp-sponsor #ov ul{
> padding:0 0 0 8px;margin:0;}
> #ygrp-sponsor #ov li{
> list-style-type:square;padding:6px 0;font-size:77%;}
> #ygrp-sponsor #ov li a{
> text-decoration:none;font-size:130%;}
> #ygrp-sponsor #nc{
> background-color:#eee;margin-bottom:20px;padding:0 8px;}
> #ygrp-sponsor .ad{
> padding:8px 0;}
> #ygrp-sponsor .ad #hd1{
>
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
> #ygrp-sponsor .ad a{
> text-decoration:none;}
> #ygrp-sponsor .ad a:hover{
> text-decoration:underline;}
> #ygrp-sponsor .ad p{
> margin:0;}
> o{font-size:0;}
> .MsoNormal{
> margin:0 0 0 0;}
> #ygrp-text tt{
> font-size:120%;}
> blockquote{margin:0 0 0 4px;}
> .replbq{margin:4;}
> -->
>
>
>
>
>
>
>
____________________________________________________________________________________
> You rock. That's why Blockbuster's offering you one month of
Blockbuster Total Access, No Cost.
> http://tc.deals.yahoo.com/tc/blockbuster/text5.com
>
> [Non-text portions of this message have been removed]
>