ssas-musings.blogspot.com
SSAS Musings: Dezember 2010
http://ssas-musings.blogspot.com/2010_12_01_archive.html
MDX-Adventures from the Wildlife. Freitag, 31. Dezember 2010. Vincent Rainardi wrote an interesting Q&A article on impersonation. Eingestellt von Martin Preiss. Alberto Ferrari - Blog. Boyan Penev - Blog. Chris Webb - Blog. Darren Gosbell - Blog. Greg Galloway - Blog. Marco Russo - Blog. Mosha Pasumansky - Blog. MS SQL Server Development Customer Advisory Team. SQL Server News Blog. Vincent Rainardi - Blog.
ssas-musings.blogspot.com
SSAS Musings: November 2009
http://ssas-musings.blogspot.com/2009_11_01_archive.html
MDX-Adventures from the Wildlife. Montag, 30. November 2009. Hilmar Buchta explains in his Blog A duplicate attribute key has been found when processing…. Some common reasons for duplicate key. Errors in processing error messages. The most likely reasons are:. NULL values in the attribute key column. Data that violates the attribute relationships defined in the dimension. Eingestellt von Martin Preiss. Freitag, 20. November 2009. MDX Query Performance in SSAS. Discusses the troubleshooting tools integrat...
ssas-musings.blogspot.com
SSAS Musings: Februar 2010
http://ssas-musings.blogspot.com/2010_02_01_archive.html
MDX-Adventures from the Wildlife. Freitag, 19. Februar 2010. Jamie Thomson discusses in his Blog. A problem with different collations in SQL Server and SSAS that results in the following error:. Errors in the OLAP storage engine:. The attribute key cannot be found when processing. The problem is closely related to the problems we described here. Eingestellt von Martin Preiss. Donnerstag, 11. Februar 2010. Ella Maschiach provides a list of free Datasets, Data Warehouse and OLAP Databases in her Blog.
ssas-musings.blogspot.com
SSAS Musings: Oktober 2010
http://ssas-musings.blogspot.com/2010_10_01_archive.html
MDX-Adventures from the Wildlife. Mittwoch, 20. Oktober 2010. 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). Eingestellt von Martin Preiss. Alberto Ferrari - Blog. Boyan Penev - Blog. Chris Webb - Blog. Darren Gosbell - Blog. Greg Galloway - Blog. Marco Russo - Blog. Mosha Pasumansky - Blog. SQL Server News Blog.
ssas-musings.blogspot.com
SSAS Musings: April 2010
http://ssas-musings.blogspot.com/2010_04_01_archive.html
MDX-Adventures from the Wildlife. Mittwoch, 14. April 2010. Theo Lachev explains in his Blog. Why the SQL Profiler does not tell you the truth about I/O waits in SSAS: it's "because the. Started/Finished reading data from the partition. Events include also the time spent in aggregating. Data and this time may be significant". He suggests to use the Xperf tool from the Windows Performance Toolkit instead and provides links to some short introductions that show how to use the tool. To tell us this.").
ssas-musings.blogspot.com
SSAS Musings: Excel and MDX multiselect problems revisited
http://ssas-musings.blogspot.com/2010/01/excel-and-mdx-multiselect-problems.html
MDX-Adventures from the Wildlife. Dienstag, 5. Januar 2010. Excel and MDX multiselect problems revisited. Multiselect problems ins SSAS 2005 ff come in several forms. Today, I want to take a look at several forms of multiselect problems, how they interact with Excel as a MDX client and how they can be avoided. Let's first look a problem that can be easily detected. The current coordinate is a set. In his blog article. Multiselect friendly MDX for calculations looking at current coordinate. Product Catego...
ssas-musings.blogspot.com
SSAS Musings: Dynamic Sets with SQL Server 2008 R2 and Excel 2010
http://ssas-musings.blogspot.com/2010/06/dynamic-sets-with-sql-server-2008-r2.html
MDX-Adventures from the Wildlife. Freitag, 18. Juni 2010. 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. Eingestellt von Martin Preiss. Abonnieren Kommentare zum Post (Atom). Dynamic Sets with SQL Server 2008 R2 and Excel 201. Alberto Ferrari - Blog. Boyan Penev - Blog. Chris Webb - Blog. Darren Gosbell - Blog. Greg Galloway - Blog. Marco Russo - Blog.
ssas-musings.blogspot.com
SSAS Musings: Impersonation
http://ssas-musings.blogspot.com/2010/12/impersonation.html
MDX-Adventures from the Wildlife. Freitag, 31. Dezember 2010. Vincent Rainardi wrote an interesting Q&A article on impersonation. Eingestellt von Martin Preiss. Abonnieren Kommentare zum Post (Atom). Alberto Ferrari - Blog. Boyan Penev - Blog. Chris Webb - Blog. Darren Gosbell - Blog. Greg Galloway - Blog. Marco Russo - Blog. Mosha Pasumansky - Blog. MS SQL Server Development Customer Advisory Team. SQL Server News Blog. Vincent Rainardi - Blog.
ssas-musings.blogspot.com
SSAS Musings: Januar 2010
http://ssas-musings.blogspot.com/2010_01_01_archive.html
MDX-Adventures from the Wildlife. Freitag, 29. Januar 2010. The difference between Order By Name and Order By Key in trivial attributes. This is a straigthforward follow-up to the last post. Suppose you have a trivial attribute, i.e., its key is mapped to a single column of a relational data source. Its name and value has been ommitted, i.e., corresponds to a representation of the key. I´m sure you or the various books of your choices did know this already. But I didn´t. Dienstag, 26. Januar 2010. For ex...
ssas-musings.blogspot.com
SSAS Musings: November 2010
http://ssas-musings.blogspot.com/2010_11_01_archive.html
MDX-Adventures from the Wildlife. Freitag, 19. November 2010. Darren Gosbell advises not to use Implicit Recursion. Eingestellt von Martin Preiss. Alberto Ferrari - Blog. Boyan Penev - Blog. Chris Webb - Blog. Darren Gosbell - Blog. Greg Galloway - Blog. Marco Russo - Blog. Mosha Pasumansky - Blog. MS SQL Server Development Customer Advisory Team. SQL Server News Blog. Vincent Rainardi - Blog.