ssasbysss.blogspot.com
SSAS/MDX Concepts & Tools: MDX behavior in SQL Server 2008 R2 & Earlier Versions
http://ssasbysss.blogspot.com/2011/05/mdx-behavior-in-sql-server-2008-r2.html
SSAS/MDX Concepts and Tools. Created this blog to share my experience and understanding on Analysis Services and MDX. Wednesday, May 18, 2011. MDX behavior in SQL Server 2008 R2 and Earlier Versions. I have been working on Sql Server Analysis Services and MDX for quite a long period. And interestingly on day to day basis I get to understand new concepts, bugs, and some interesting features. Few days back,. Http:/ connect.microsoft.com/. Select [Measures].[Internet Sales Amount] on 0,. May 7, 2004 $17,992...
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.").
ssasbysss.blogspot.com
SSAS/MDX Concepts & Tools: August 2011
http://ssasbysss.blogspot.com/2011_08_01_archive.html
SSAS/MDX Concepts and Tools. Created this blog to share my experience and understanding on Analysis Services and MDX. Tuesday, August 2, 2011. Remote Query (Linked Server) Connection Time-Out Issue and Solution. Today, I faced an issue while running a long MDX query in terms of execution time. I went through so many posts on this issue, but didn't get any answer. Below are the details:. Linked Server Connection: Query Timeout property under Server Options. None of them were successful attempt in my case.
ssasbysss.blogspot.com
SSAS/MDX Concepts & Tools: MDX
http://ssasbysss.blogspot.com/p/mdx.html
SSAS/MDX Concepts and Tools. Created this blog to share my experience and understanding on Analysis Services and MDX. Here are some useful MDX expressions for specific requirements which we generally come across while working with SQL Server Analysis Services. I have used sample "Adventure Works" olap database for all the expressions. 1 MDX: To return Product Subcategories which has sales 20000 for every year. Measures].[Internet Sales Amount]}. Product].[Subcategory].[Subcategory],.
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.
tomislav.piasevoli.com
MVP – Tomislav Piasevoli – BI Blog
http://tomislav.piasevoli.com/tag/mvp
Business Intelligence on Microsoft platform. Tomislav Piasevoli – BI Blog. My 3rd Microsoft MVP award. Here’s just a short info that I have received the Microsoft MVP Award. Again, my third in a row. Naturally, I’m very happy about it :-). As always, stay tuned for interesting presentations, blog posts and/or magazine articles in the upcoming period. And thank you for following and appreciating my work! Posted by Tomislav Piasevoli. Microsoft MVP Award, again! Posted by Tomislav Piasevoli.
ssas-musings.blogspot.com
SSAS Musings: Cube documentation with DMV data
http://ssas-musings.blogspot.com/2010/09/cube-documentation-with-dmv-data.html
MDX-Adventures from the Wildlife. Mittwoch, 29. September 2010. 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/. Alberto Ferrari - Blog.
ssas-musings.blogspot.com
SSAS Musings: März 2010
http://ssas-musings.blogspot.com/2010_03_01_archive.html
MDX-Adventures from the Wildlife. Donnerstag, 18. März 2010. Save your day with ProcessIncremental. Who claims not to have too long processing times in real-world analytic databases either is a lyer . In our current project, where we tried to setup a "ProcessUpdate" szenario, the complexity of dimension, partition changes and ProcessIndex calls had summed up to a period that was nearly as long as a full "Process" ( 2h for 5GB/2 years of business data). Dienstag, 16. März 2010. Montag, 8. März 2010. In SS...
SOCIAL ENGAGEMENT