Are you having issues with the performance and usability of your solution’s dimensions? In this blog, Pragmatic Works' Senior Business Intelligence Consultant Dustin Ryan covers three best practices that for improving performance of SSAS dimensions as well as common mistakes in dimension design. Additionally, he's discussing some common mistakes he sees users making with dimension design.
Category: Ssas11 Results
Welcome back to our informative series on Excel by Steve Hughes! In his first post, he conquered the Quick Explore feature. In this post, Steve will delve into the Show Explore feature. Join Steve as he shows you how you can drill into details using the Show Explore feature once you've connected your SSAS cube to Excel.
Excel is a powerful tool that is used by almost everyone is the business world. Because of its numerous capabilities, Excel has many functions that can often be confusing to users. In this new blog series Our resident expert, Steve Hughes, will cover a wide variety of Excel topics ranging from easy to complex. Steve will provide you tips and tricks he has discovered in his journey through Excel.
So, you have connected Excel to your SSAS cube. You really wish you could cross drill easily in the product. If you have used PerformancePoint Services you know the process. Right click on the bar or cell and then choose the dimension to drill to using the information you clicked on as a starting point. You can now do this in Excel 2013 using Quick Explore. Here’s how to do it:
In Part I of the SSAS Tabular vs. SSAS Multidimensional – Which One Do I Choose? series, we began to set the stage for looking at 5 high level considerations to answer this question. In Part II, we explored the Scalability and Performance considerations between the two technologies. In Part III, we explored the characteristics of the data and the model required to deliver the analytics and reporting required. In this installment, we will cover how to extend the capabilities and characteristics of your data model through the use of business logic.
In Part I of the SSAS Tabular vs. SSAS Multidimensional series, we began to set the stage for looking at 5 high level considerations to help determine which you should choose to use. In Part II, we explored the Scalability and Performance considerations between the two technologies. In this post, we'll contemplate the Complex Business Problem aspects by comparing and contrasting SSAS Tabular and SSAS Multidimensional in terms of characteristics of the data, the model required to deliver the analytics and the reporting required.
In Part I of the SSAS Tabular vs. SSAS Multidimensional – Which One Do I Choose? series, we began to set the stage for looking at 5 high level considerations to answer this question. The considerations are:
- Time to Develop
- Complex Business Problems
- Learning Curve
In this post, we will contemplate the Scalability and Performance aspects by comparing and contrasting SSAS Tabular and SSAS Multidimensional in these areas.
Have you been or are you currently working on a project where you are trying to determine which flavor of Analysis Services (Tabular or Multidimensional) you should have used or should use? Recently, I was doing a presentation on SSAS Multidimensional best practices and following the presentation one of the attendees asked a very good question, “When it comes to SSAS Tabular versus SSAS Multidimensional how do I know which one to choose?” We discussed some of the various aspects of each one, but during the conversation I realized I needed to put a presentation and ultimately a blog post together on this topic.
Starting February 24th, Chris Albrektson & Devin Knight will be teaching an intro to SQL Server Analysis Services (SSAS) workshop. This two full day event it will be packed with both Multi-Dimensional and Tabular/PowerPivot demos and exercises.
It will be an in person workshop at the Microsoft office in Austin, Texas. The workshop is on February 24th & 25th and is available for only $399.
On Thursday we hosted the Tabular and Power Pivot Feature Limitations webinar with Brad Schacht. He took us through the various Tabular and Multidimensional differences, as well as a work around for features that are not supported in Tabular. This webinar is sure to assist you in making an informed decision as to which product you want to use based on your needs to get the best information in your PowerPivot.