Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sql Svr 2005 start new Olap proj - not same as sql svr 2000?

0 views
Skip to first unread message

Rich

unread,
Nov 6, 2009, 4:56:13 PM11/6/09
to
With sql server 2000 Personal edition I was able to load the Olap server on
my workstation on practice some mdx queries on a cube with the sample app
that ships with personal edition. Now I have sql server 2005 developer
edition and I selected analysis services on the install, but the analysis
servervices tab doesn't bring up a project window - it just brings up a
deployment wizard.

How do I start an Olap project with sql server 2005? Do I have to install
sql server 2005 on a server computer or do I need addtional programs?

thanks
Rich

amish

unread,
Nov 9, 2009, 3:55:30 AM11/9/09
to

You can run MDX in Management studio . To create project and design
cubes you need BIDS(Business Inteligence development Studio)

Amish Shah
http://shahamishm.blogspot.com

Joe Sampino

unread,
Nov 9, 2009, 1:21:03 PM11/9/09
to
you can use Sql Management studio for overall maintenance, but use visual
studio for working on cubes.

it's under all programs--> sql server 2005 or 2008, --> sql server business
intelligence development studio (BIDS)

Rich

unread,
Nov 9, 2009, 4:31:01 PM11/9/09
to
Thanks. I do a lot of reporting services. I should have paid attention to
that. Now I have it. Thanks again.
0 new messages