Tuesday, March 27, 2012

Analysis Services

We have not used Analysis Services anywhere in our shop and want to get
started. (All our machines are 2000.) I'd like to start by putting it on a
dev/qa box but if I do, Analysis Services will be the only thing that is
significantly different between out dev/qa environment and our prod servers.
Is this an issue? Does Analysis Services mess with MDAC or any of the core
Sql Server dll's? Or did MS keep it completely separate kind of like the CLR
is completely separate?HI CLM,
Analysis services did not mess with sql services but it depend upon the
sqls services.
Analsis services uses OBDC to connect the database.
It creates its own database and only pull data from the server from sql
server
for more information
Read BOL Analsysis services
hope this help u.
from
killer

No comments:

Post a Comment