Collation and language settings in tabular models

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 a future post I will show you an example of how…

2

The BI semantic model, MDX, DAX, and you

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, and when precisely you can use MDX and DAX with multidimensional and tabular models. Hopefully…

3

DAX Editor for SQL Server going to CodePlex

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 we figure out how to push a magic publishing…

6

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

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, you see this error if the tabular…

8

Configuring a workspace database server

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 picking a workspace database server than just picking an instance. You…

1

Working with the ACE provider in the tabular designer

The Office ACE provider is used to import from text files, Excel files, and Access files. Just like for any data provider, you need to install the provider on both the client side (machine with BIDS) and on the server side (both the machine running the workspace DB instance and the machine running the deployment…

3

Processing tabular models 101

With a new storage engine comes new processing options. Here are some fast facts about processing tabular models, in Q&A format. What are my processing options? The following table shows the available processing options for each object. Object Available Processing Options Database Process Clear, Process Default, Process Defrag*, Process Full, Process Recalc *See usage note…

4

Where does data come from when you open a BIM file?

By default, when you open the .bim file after closing it, the data comes back. Did you ever wonder where this data comes from? It depends on a number of factors. Let’s explore. Before we begin, I want you to keep a very important point in mind. The metadata in the BIM file is always…

0

Working with backups in the tabular designer

We have this Data Backup property on the .bim file that by default is turned off. You may wonder why this property exists. Let us explore what it is this property does, and why it (and backups in general) are useful in the tabular designer. The Data Backup property specifies whether or not an ABF…

0

Configuring multiple partitions in a DirectQuery with VertiPaq model, step by step

In my DirectQuery 101 post, I promised an example of configuring a model with DirectQuery only partitions. Here it is. Imagine for a moment that AdventureWorks has turned into a fast moving mega-conglomerate, with transactions written to FactInternetSales all day long for years and years. Your job is to implement a model that requires up…

0