<div>
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...<br />
<br />

</div>


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...



<div>
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?
</div>


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?

<div>
Thanks - great fast response<br />

</div>


<div>
<div class="content wysiwyg-content">
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. <br />
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) <br />
<br />
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?<br />
<br />
I would appreciate any help on this. If you need any more info I'd be very happy to oblige.
</div>
</div>


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.

SQL 2008 EXPRESS ANALYSIS SERVICES

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors - Multidimensional and Tabular.