BI Deployment Experiences

I'm trying to get some info on how other companies are handling BI
implementations. We have a data warehouse project that we expect will have
continuos changes. That is, new data sources coming in, more reports, etc.
That implies new Integration Services packages, new Reporting Services
reports, changes in tables, view, stored procedures, etc. We also have a 3
environment installation: Development, QA, Production.
I would appreciate any info on how other people are handling this. Can you
manage with only Visual Studio? Is there any third vendor tool anybody would
recommend? The issue is that we could potentially have the 3 environments
with different versions and we might want to move objects from development t
o
QA, for example, without just duplicating the 2 environments (we could have
different stages of development and only want to move finished objects).
Any help is appreciated,
Carmen.We have pretty much the exact same setup you do. We use Visual Studio and
Visual Source Safe to manage all our code. Using the new features for
managing environments within Visual Studio - makes promoting SSIS packages a
snap. Using DTS was more challenging when you for example moved from DEV to
TEST you had to change all your data sources to point to new places - but
SSIS makes that part easy.
If you tie your solutions into VSS and have your coders do all their work
inside of VSS - that will ensure it's managed correctly. Where I work won't
spring for the new Visual Studio Team Edition for DB Professionals - but
that def makes things easier in managing your DB code within the same
solution as your SSIS packages. You can still add the DB into your
solution, but not have ALL the cool features Team Edition offers.
So our developers, by using the VSS integration inside VS, it auto checks
out all the code, whether it be packages or stored procedures. Your
promoting to new environments from Visual Source Safe will endure you are
promoting the right stuff.
It's not that hard - once you get it sorted out and documented and follow
the process - you will be good.
"Carmen" <Carmen@.discussions.microsoft.com> wrote in message
news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
> I'm trying to get some info on how other companies are handling BI
> implementations. We have a data warehouse project that we expect will have
> continuos changes. That is, new data sources coming in, more reports, etc.
> That implies new Integration Services packages, new Reporting Services
> reports, changes in tables, view, stored procedures, etc. We also have a 3
> environment installation: Development, QA, Production.
> I would appreciate any info on how other people are handling this. Can you
> manage with only Visual Studio? Is there any third vendor tool anybody
> would
> recommend? The issue is that we could potentially have the 3 environments
> with different versions and we might want to move objects from development
> to
> QA, for example, without just duplicating the 2 environments (we could
> have
> different stages of development and only want to move finished objects).
> Any help is appreciated,
> Carmen.|||Our approach is to use XMLA scripts (using ascmd utility from SP1) and the
AS syncronize feature (again via XMLA scripts). Works fine - and no
Integration Services required.
Chris
www.activeinterface.com
"Carmen" <Carmen@.discussions.microsoft.com> wrote in message
news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
> I'm trying to get some info on how other companies are handling BI
> implementations. We have a data warehouse project that we expect will have
> continuos changes. That is, new data sources coming in, more reports, etc.
> That implies new Integration Services packages, new Reporting Services
> reports, changes in tables, view, stored procedures, etc. We also have a 3
> environment installation: Development, QA, Production.
> I would appreciate any info on how other people are handling this. Can you
> manage with only Visual Studio? Is there any third vendor tool anybody
> would
> recommend? The issue is that we could potentially have the 3 environments
> with different versions and we might want to move objects from development
> to
> QA, for example, without just duplicating the 2 environments (we could
> have
> different stages of development and only want to move finished objects).
> Any help is appreciated,
> Carmen.|||Chris,
Thanks for the info!
Carmen.
"ChrisHarrington" wrote:

> Our approach is to use XMLA scripts (using ascmd utility from SP1) and the
> AS syncronize feature (again via XMLA scripts). Works fine - and no
> Integration Services required.
> Chris
> www.activeinterface.com
> "Carmen" <Carmen@.discussions.microsoft.com> wrote in message
> news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
>
>|||Joe,
Thanks for the info. I'll definitely investigate the options you mentioned.
Carmen.
"Joe" wrote:

> We have pretty much the exact same setup you do. We use Visual Studio and
> Visual Source Safe to manage all our code. Using the new features for
> managing environments within Visual Studio - makes promoting SSIS packages
a
> snap. Using DTS was more challenging when you for example moved from DEV
to
> TEST you had to change all your data sources to point to new places - but
> SSIS makes that part easy.
> If you tie your solutions into VSS and have your coders do all their work
> inside of VSS - that will ensure it's managed correctly. Where I work won
't
> spring for the new Visual Studio Team Edition for DB Professionals - but
> that def makes things easier in managing your DB code within the same
> solution as your SSIS packages. You can still add the DB into your
> solution, but not have ALL the cool features Team Edition offers.
> So our developers, by using the VSS integration inside VS, it auto checks
> out all the code, whether it be packages or stored procedures. Your
> promoting to new environments from Visual Source Safe will endure you are
> promoting the right stuff.
> It's not that hard - once you get it sorted out and documented and follow
> the process - you will be good.
> "Carmen" <Carmen@.discussions.microsoft.com> wrote in message
> news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
>

BI Deployment Experiences

I'm trying to get some info on how other companies are handling BI
implementations. We have a data warehouse project that we expect will have
continuos changes. That is, new data sources coming in, more reports, etc.
That implies new Integration Services packages, new Reporting Services
reports, changes in tables, view, stored procedures, etc. We also have a 3
environment installation: Development, QA, Production.
I would appreciate any info on how other people are handling this. Can you
manage with only Visual Studio? Is there any third vendor tool anybody would
recommend? The issue is that we could potentially have the 3 environments
with different versions and we might want to move objects from development to
QA, for example, without just duplicating the 2 environments (we could have
different stages of development and only want to move finished objects).
Any help is appreciated,
Carmen.
We have pretty much the exact same setup you do. We use Visual Studio and
Visual Source Safe to manage all our code. Using the new features for
managing environments within Visual Studio - makes promoting SSIS packages a
snap. Using DTS was more challenging when you for example moved from DEV to
TEST you had to change all your data sources to point to new places - but
SSIS makes that part easy.
If you tie your solutions into VSS and have your coders do all their work
inside of VSS - that will ensure it's managed correctly. Where I work won't
spring for the new Visual Studio Team Edition for DB Professionals - but
that def makes things easier in managing your DB code within the same
solution as your SSIS packages. You can still add the DB into your
solution, but not have ALL the cool features Team Edition offers.
So our developers, by using the VSS integration inside VS, it auto checks
out all the code, whether it be packages or stored procedures. Your
promoting to new environments from Visual Source Safe will endure you are
promoting the right stuff.
It's not that hard - once you get it sorted out and documented and follow
the process - you will be good.
"Carmen" <Carmen@.discussions.microsoft.com> wrote in message
news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
> I'm trying to get some info on how other companies are handling BI
> implementations. We have a data warehouse project that we expect will have
> continuos changes. That is, new data sources coming in, more reports, etc.
> That implies new Integration Services packages, new Reporting Services
> reports, changes in tables, view, stored procedures, etc. We also have a 3
> environment installation: Development, QA, Production.
> I would appreciate any info on how other people are handling this. Can you
> manage with only Visual Studio? Is there any third vendor tool anybody
> would
> recommend? The issue is that we could potentially have the 3 environments
> with different versions and we might want to move objects from development
> to
> QA, for example, without just duplicating the 2 environments (we could
> have
> different stages of development and only want to move finished objects).
> Any help is appreciated,
> Carmen.
|||Our approach is to use XMLA scripts (using ascmd utility from SP1) and the
AS syncronize feature (again via XMLA scripts). Works fine - and no
Integration Services required.
Chris
www.activeinterface.com
"Carmen" <Carmen@.discussions.microsoft.com> wrote in message
news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
> I'm trying to get some info on how other companies are handling BI
> implementations. We have a data warehouse project that we expect will have
> continuos changes. That is, new data sources coming in, more reports, etc.
> That implies new Integration Services packages, new Reporting Services
> reports, changes in tables, view, stored procedures, etc. We also have a 3
> environment installation: Development, QA, Production.
> I would appreciate any info on how other people are handling this. Can you
> manage with only Visual Studio? Is there any third vendor tool anybody
> would
> recommend? The issue is that we could potentially have the 3 environments
> with different versions and we might want to move objects from development
> to
> QA, for example, without just duplicating the 2 environments (we could
> have
> different stages of development and only want to move finished objects).
> Any help is appreciated,
> Carmen.
|||Chris,
Thanks for the info!
Carmen.
"ChrisHarrington" wrote:

> Our approach is to use XMLA scripts (using ascmd utility from SP1) and the
> AS syncronize feature (again via XMLA scripts). Works fine - and no
> Integration Services required.
> Chris
> www.activeinterface.com
> "Carmen" <Carmen@.discussions.microsoft.com> wrote in message
> news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
>
>
|||Joe,
Thanks for the info. I'll definitely investigate the options you mentioned.
Carmen.
"Joe" wrote:

> We have pretty much the exact same setup you do. We use Visual Studio and
> Visual Source Safe to manage all our code. Using the new features for
> managing environments within Visual Studio - makes promoting SSIS packages a
> snap. Using DTS was more challenging when you for example moved from DEV to
> TEST you had to change all your data sources to point to new places - but
> SSIS makes that part easy.
> If you tie your solutions into VSS and have your coders do all their work
> inside of VSS - that will ensure it's managed correctly. Where I work won't
> spring for the new Visual Studio Team Edition for DB Professionals - but
> that def makes things easier in managing your DB code within the same
> solution as your SSIS packages. You can still add the DB into your
> solution, but not have ALL the cool features Team Edition offers.
> So our developers, by using the VSS integration inside VS, it auto checks
> out all the code, whether it be packages or stored procedures. Your
> promoting to new environments from Visual Source Safe will endure you are
> promoting the right stuff.
> It's not that hard - once you get it sorted out and documented and follow
> the process - you will be good.
> "Carmen" <Carmen@.discussions.microsoft.com> wrote in message
> news:B9EAA9CD-B73C-43D3-A314-5E99EE3DC694@.microsoft.com...
>

BI and shipping line companies

Hi all,

As u know the first step in a BI solution is determining the BI goals. I need some samples of shipping line companies which have a BI solution. I have read so many customer stories from many BI corporations but nearly all of them focus on generating integrated systems and reports. I need more info if you can help me!

Previous thanx

yes i have some sample if u want then send me mail.

mail id is that

wise_boy620@.hotmail.com

BI and Reporting Tools used with Reporting Services

What tools (companies) have you found to work well with your Data Warehouse,
easy to use by non-developers and also interface with MS Reporting Services?
JBH1
> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
*sigh* i have a thread wondering this same thing. i can't find anything. And
getting information from the actual companies is like pulling teeth.
|||> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
Oh, and btw, a guy sent me a link to a site where: if you're willing to pay,
he'll let you read his reviews of various data warehouse access tools.
That's how much of a secret this stuff is.
|||I have some links related to reporting services and 3rd party companies on
Reporting Services.
You might want to have a look at the SQL 2005 Report Builder as well.
Cizer.net has some nice tools too.
Links are provided on my website .
www.dandyman.net/sql
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
> --
> JBH1
|||This is sort of a broad question.
How isl the data being accessed by the end users stored?
"Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
> --
> JBH1
|||Ian,
I am not sure many of the major BI vendors are keen to work closely
with RS...after all MSFT has now announced it's intention of 'eating
their lunch'....remember how low key the first release of RS was? And
no MSFT is 'talking it up' as a real alternative to Crystal Reports now
owned by Business Objects.
I am certainly aware that Business Objects is training up staff to
compete with RS2005.
When an 800 pound gorilla like MSFT steps into the BI marketplace all
vendors are going to do whatever they can to maintain their
clients....
All those vendors (BO, COGN, MSTR etc) will all work with SQL Server
and position their tools as somehow 'better' than Report Services....
For the last 7-8 years people have talked about integration of the
development environment between vendors, usually via some form of
metadata hub (for example Ascentials MetaStage and the MetaData
Coalition etc.). However, this has been a pretty fruitless exercise.
The BI vendors are not interested in making it easier to share their
metadata with other BI vendors. Whoever owns 'what is presented on the
screen' owns the client and all of them are trying to protect their
position from MSFTs RS efforts.
Ufortunately IT shops and business users have remained subbornly
ignorant of the fact that 80% of the work is in database design and ETL
and 20% in the presentation layer...and people buy the presentation
layer and not the infrastructure/architecture. This make 'what is on
the screen' even more important to protect.
Best Regards
Peter Nolan
www.peternolan.com
|||What do you mean by interfacing with Reporting Services? Microsoft itself
provides some good BI front tend tools for 2005.
"Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
> --
> JBH1
|||In a data warehouse. In fact tables, surrounded by dimension tables.
"Jesse O" <jesperzz@.hotmail.com> wrote in message
news:ee5Z7SYuFHA.596@.TK2MSFTNGP12.phx.gbl...
> This is sort of a broad question.
> How isl the data being accessed by the end users stored?
>
>
> "Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
> news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
>
|||Hi JT,
which ones? I have read zip about any good tools that integrate RS into
them...we are doing this work for ourselves...
We have been surprised there is no good browser front end for RS and
that the answer we have gotten back so far is that we must build one
for ourselves...?
Thanks
Peter Nolan
www.peternolan.com
|||Depending on what you are looking for. Cizer has an interesting
web-based report builder environment. My favorite though is
SoftArtisans OfficeWriter -
http://officewriter.softartisans.com...riter-250.aspx
Because RS has a pretty complete array of rendering mechanisms, there
hasn't been a real need (at least ont he dozen or so projects I have
worked on) for a 3rd party add-on.
If you want to be a bit more specific about what problems you are
having, that you are looking for a solution too, I'll see if I can find
something.
Steve Muise
neudesic LLC

BI and Reporting Tools used with Reporting Services

What tools (companies) have you found to work well with your Data Warehouse,
easy to use by non-developers and also interface with MS Reporting Services?
--
JBH1> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
*sigh* i have a thread wondering this same thing. i can't find anything. And
getting information from the actual companies is like pulling teeth.|||> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
Oh, and btw, a guy sent me a link to a site where: if you're willing to pay,
he'll let you read his reviews of various data warehouse access tools.
That's how much of a secret this stuff is.|||I have some links related to reporting services and 3rd party companies on
Reporting Services.
You might want to have a look at the SQL 2005 Report Builder as well.
Cizer.net has some nice tools too.
Links are provided on my website .
www.dandyman.net/sql
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net
Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
> --
> JBH1|||This is sort of a broad question.
How isl the data being accessed by the end users stored?
"Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
> --
> JBH1|||Ian,
I am not sure many of the major BI vendors are keen to work closely
with RS...after all MSFT has now announced it's intention of 'eating
their lunch'....remember how low key the first release of RS was? And
no MSFT is 'talking it up' as a real alternative to Crystal Reports now
owned by Business Objects.
I am certainly aware that Business Objects is training up staff to
compete with RS2005.
When an 800 pound gorilla like MSFT steps into the BI marketplace all
vendors are going to do whatever they can to maintain their
clients....
All those vendors (BO, COGN, MSTR etc) will all work with SQL Server
and position their tools as somehow 'better' than Report Services....
For the last 7-8 years people have talked about integration of the
development environment between vendors, usually via some form of
metadata hub (for example Ascentials MetaStage and the MetaData
Coalition etc.). However, this has been a pretty fruitless exercise.
The BI vendors are not interested in making it easier to share their
metadata with other BI vendors. Whoever owns 'what is presented on the
screen' owns the client and all of them are trying to protect their
position from MSFTs RS efforts.
Ufortunately IT shops and business users have remained subbornly
ignorant of the fact that 80% of the work is in database design and ETL
and 20% in the presentation layer...and people buy the presentation
layer and not the infrastructure/architecture. This make 'what is on
the screen' even more important to protect.
Best Regards
Peter Nolan
www.peternolan.com|||What do you mean by interfacing with Reporting Services? Microsoft itself
provides some good BI front tend tools for 2005.
"Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
> What tools (companies) have you found to work well with your Data
> Warehouse,
> easy to use by non-developers and also interface with MS Reporting
> Services?
> --
> JBH1|||In a data warehouse. In fact tables, surrounded by dimension tables.
"Jesse O" <jesperzz@.hotmail.com> wrote in message
news:ee5Z7SYuFHA.596@.TK2MSFTNGP12.phx.gbl...
> This is sort of a broad question.
> How isl the data being accessed by the end users stored?
>
>
> "Jeff H." <JeffH@.discussions.microsoft.com> wrote in message
> news:E5BFF01A-13CF-494A-9D90-AED28D7EC64B@.microsoft.com...
>|||Hi JT,
which ones? I have read zip about any good tools that integrate RS into
them...we are doing this work for ourselves...
We have been surprised there is no good browser front end for RS and
that the answer we have gotten back so far is that we must build one
for ourselves...'
Thanks
Peter Nolan
www.peternolan.com|||Depending on what you are looking for. Cizer has an interesting
web-based report builder environment. My favorite though is
SoftArtisans OfficeWriter -
http://officewriter.softartisans.co...writer-250.aspx
Because RS has a pretty complete array of rendering mechanisms, there
hasn't been a real need (at least ont he dozen or so projects I have
worked on) for a 3rd party add-on.
If you want to be a bit more specific about what problems you are
having, that you are looking for a solution too, I'll see if I can find
something.
Steve Muise
neudesic LLC