Topic: BIDS

SSAS Tabular as Analytical Engine
This article describes pros and cons of using SQL Server Analysis Services Tabular as the analytical engine in a service or application, based on the experience of companies who have adopted it. Read more
Community Events in Köln (October) and Copenhagen November #ssas #tabular #powerpivot
Short update about community events in Europe where I will speak. On October 11 I will present DAX in Action in Köln – all details in the PASS local chapter here: http://www.sqlpass.de/Regionen/Deutschland/K%C3%B6lnBonnD%C3%BCsseldorf.aspx I will be speaking Read more
SSAS Tabular Workshop online and other upcoming dates (and updates!) #ssas #tabular
After many conferences and travels, this summer I had some time to write and prepare new sessions for the next wave of conferences. In reality I am just doing that, even if I already restarted traveling for consulting and training. So expect new content Read more
Change default workspace and deployment server in #Tabular #SSAS #Denali #CTP3
When you install Analysis Services Denali, chances are that you create an instance for Tabular that is not the default instance for Analysis Services. When you try to create a Tabular project, you might get the following error: You cannot open the BIM Read more
Vote a bug and a missing feature in #powerpivot #denali #ctp3 on #connect
If you have 30 seconds available, please vote the following items on Connect: https://connect.microsoft.com/SQLServer/feedback/details/679618/import-attribute-key-from-ssas-in-powerpivot When you import data coming from an Analysis Services cube in PowerPivot, Read more
First steps with #ssas #Tabular in #Denali #CTP3
The Analysis Services team just posted a blog entry with a few useful links to jumpstart your experience with Tabular project in Analysis Services “Denali”. In these early days I read several messages asking for clarification about the names and acronyms Read more
The Microsoft BI Roadmap: BISM, UDM and Beyond
Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it Read more
DateTool dimension: an alternative Time Intelligence implementation
Year-To-Date and Difference-Over-Previos-Year (or Year-Over-Year Growth) are among the most required features of any user. Some OLAP client (like ProClarity) offers features that try to solve this problem client-side, but I don’t like this approach given Read more
DateTool dimension: an alternative Time Intelligence implementation
Year-To-Date and Difference-Over-Previos-Year (or Year-Over-Year Growth) are among the most required features of any user. Some OLAP client (like ProClarity) offers features that try to solve this problem client-side, but I don’t like this approach given that you might have… Read more
BIDS Helper beta 0.9
BIDS Helper is an addin for Visual Studio that really improves productivity developing solutions for Analysis Services. Today I tested it and looking for its feature I encountered a page describing the “Show Extra Properties” feature… and it links a Read more