new SSAS blog

Jeffrey Wang has started blogging - and the first entry looks very promising.

Impersonation

Vincent Rainardi wrote an interesting Q&A article on impersonation.

Implicit Recursion

Darren Gosbell advises not to use Implicit Recursion in MDX.

Currency Conversion

Boyan Penev writes in his Blog about Currency Conversion in SSAS. He provides a lot of interesting links and includes also practical examples. His Blog is absolutly worth reading (and is now included into the link section of this page).

Cube documentation with DMV data

The FrogBlog shows how to generate a SSRS documentation for a cube by using DMVs via LinkedServer access:

• http://www.purplefrogsystems.com/blog/index.php/2010/09/olap-cube-documentation-in-ssrs-part-1/
• http://www.purplefrogsystems.com/blog/index.php/2010/09/olap-cube-documentation-in-ssrs-part-2/
• http://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-3/ 

Linked Cubes

Again only a link ...
Chris Webb wrote in his Blog about the question:

whether, if you have multiple fact tables, you should create one big cube with multiple measure groups or multiple cubes each with a single measure group.

Wenn he says that "Linked measure groups are a pain to manage" I have to agree...

Dynamic Sets with SQL Server 2008 R2 and Excel 2010

Thomas Ivarsson shows in his Blog that the use of dynamic sets is much improved for the combination of SQL Server 2008 R2 and Excel 2010.