One department in my company has 19 stand-alone MS Access databases residing on the LAN (and WAN) in each of 19 locations. We are planning on building a centralized data mart which would join them all, but this won’t happen for 9-12 months. In the meantime, we would like to give regional users access to their data and corporate management access to total company data.
Hooking each local user up to their database will be no problem, but for the corporate users I will need to create 19 Universes (b/c each one will have a different connection to each of the 19 databases).
Does anyone have any advice or, more importantly, know of any pitfalls I might encounter if we try to do this ?? Will I be able to get reports with a “total company” picture of the data once I create 19 Universes ? Should I create 19 stand-alone Universes or one “Master Universe” with the rest being Component Universes or something along those lines ?? Is there a better way to do this ?
(( BO version 4.1.5 ))
Thanks in Advance - DAN
Dan D Mahon
Enterprise Data Manager
ADVO, Inc.
860-285-6319 DDMAHON@ADVO.COM
You can set up custom connections in Supervisor - we do this for GL / AP / AR data across different countries… 1 universe, a dozen different connections defined via supervisor… you just need to put your users in the correct group, set the link to the universe in that group.
I can give you more detail, but you may want to look at that in the supervisor manual, maybe search here for more info / examples…
Hope this gives you some ideas- hate to think you have to keep 19 copies of a universe in synch,
Brent
HELLO ALL -
One department in my company has 19 stand-alone MS Access databases residing on the LAN (and WAN) in each of 19 locations. We are planning on building a centralized data mart which would join them all, but this won’t happen for 9-12 months. In the meantime, we would like to give regional users access to their data and corporate management access to total company data.
Hooking each local user up to their database will be no problem, but for the corporate users I will need to create 19 Universes (b/c each one will have a different connection to each of the 19 databases).
Does anyone have any advice or, more importantly, know of any pitfalls I might encounter if we try to do this ?? Will I be able to get reports with a “total company” picture of the data once I create 19 Universes ? Should I create 19 stand-alone Universes or one “Master Universe” with the rest being Component Universes or something along those lines ??
Is there a better way to do this ?
(( BO version 4.1.5 ))
Thanks in Advance - DAN
Dan D Mahon
Enterprise Data Manager
ADVO, Inc.
860-285-6319 DDMAHON@ADVO.COM