October, 2011

Posts
  • Cathy Dumas's Blog

    When to choose tabular models over PowerPivot models

    • 2 Comments
    Sometimes people ask me for the slide deck to my PASS presentation . I send out the deck, but there is only one slide in there that is worth anything. This post summarizes the only useful slide in the entire deck. Let’s think about this question – why...
  • Cathy Dumas's Blog

    Making tabular models more sensitive

    • 0 Comments
    Case sensitive, that is. Last year, Denny Lee posted about PowerPivot’s case insensitivity problem . Tabular models have the same insensitivity problem by default. As I mentioned in my previous post on language and collation settings , when creating a...
  • Cathy Dumas's Blog

    Collation and language settings in tabular models

    • 2 Comments
    Collation and language settings are tricky; so tricky that my two planned blog posts on this topic can only scratch the surface of what goes on under the covers here. This post is a simplified overview of collation and language settings for Denali. In...
  • Cathy Dumas's Blog

    The BI semantic model, MDX, DAX, and you

    • 3 Comments
    When I was at PASS I fielded a bunch of questions about the BI semantic model, multidimensional (OLAP), and tabular (VertiPaq) models. I think there is some confusion about what the BI semantic model, multidimensional, and tabular models actually are...
  • Cathy Dumas's Blog

    DAX Editor for SQL Server going to CodePlex

    • 6 Comments
    Hi, today at my PASS session I gave a demo of a DAX Editor. This is a sample written by three testers on the Analysis Services team - Nick Medveditskov, Karen Aleksanyan, and Sergey Volegov. We will making this sample available on CodePlex as soon as...
  • Cathy Dumas's Blog

    Heading to SQL PASS

    • 2 Comments
    I am spending the next couple of days getting ready for PASS Summit 2011 . I have a session on Thursday afternoon, 3 PM, on Developing and Managing a Business Intelligence Semantic Model (BISM) in SQL Server Code Name “Denali” Analysis Services . The...
  • Cathy Dumas's Blog

    Recovering your model when you can’t save the BIM file

    • 7 Comments
    It is possible for the tabular designer to get into an error state. If you try to save the model, you can get this error message: “Unable to save the file Model.bim. Reason: The file cannot be saved because it is marked as readonly.” Most of the time...
  • Cathy Dumas's Blog

    Configuring a workspace database server

    • 1 Comments
    Marco Russo has a nice post about the basics of configuring the workspace database server . You can use his post to learn how to set the tabular instance to use for the workspace database server for new and existing projects. However, there’s more to...
Page 1 of 1 (8 items)