SQL 2008 EXPRESS ANALYSIS SERVICES

I am new to SQL analysis services. We are a small Company that's running a single SQL Std 2008 instance. I like the idea of a separate server that's used as a reporting/analysis server.
1. Can I design the analysis queries,cubes etc. in the STD version and have a transactional replica on a separate sever running SQL 2008 express (there are no issues with dB size or the memory limitations in Express)

2. Will Express be able to report using the analysis services or do I need to buy the Std edition, or is there another way round this?

I would appreciate any help on this. If you need any more info I'd be very happy to oblige.
STOCRICAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
RiteshShahConnect With a Mentor Commented:
sorry, that is not possible either. you can't transfer cubes to express at all.
0
 
stormymanuCommented:
It is possible to design your analysis queries and generate cubes using SSAS with the standard version of MS SQL 2008, but you will not be able to perform the same with the Express version...

0
 
STOCRICAuthor Commented:
Thanks Stormymanu, can the generated cubes be somehow transferred into Express so they can be read from Crystal Reports? so in effect Express is a holding area, and Std is the design and dev and cube creation area?
0
 
STOCRICAuthor Commented:
Thanks - great fast response
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.