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.