Share via


Cathy Dumas's Blog

Hi, today is my last day at Microsoft. I am moving back home to Vancouver, BC. I won’t be allowed to...

Date: 12/22/2011

In my previous post about impersonation, I mentioned that DirectQuery impersonation was a bit...

Date: 12/12/2011

If you look at my previous post on the tabular project structure, you’ll see this teaser: “There are...

Date: 12/02/2011

If you look in the metadata of a BIM file, or if you look at the .dax file generated by the DAX...

Date: 11/29/2011

You’ve run the import wizard, and imported a bunch of tables into your tabular model. Now you want...

Date: 11/23/2011

Now that RC0 has arrived I can finally post about security for tabular models. I have put off...

Date: 11/21/2011

If you look carefully, you can see my roots showing. No, not my hair – you can see my old job...

Date: 11/17/2011

In PowerPivot, the Edit Table Properties dialog box is used for a few things. It is used to add...

Date: 11/10/2011

Here is a pop quiz on impersonation when connecting to a data source for tabular models. Question 1:...

Date: 11/07/2011

Sometimes people ask me for the slide deck to my PASS presentation. I send out the deck, but there...

Date: 10/27/2011

Case sensitive, that is. Last year, Denny Lee posted about PowerPivot’s case insensitivity problem....

Date: 10/24/2011

Collation and language settings are tricky; so tricky that my two planned blog posts on this topic...

Date: 10/21/2011

When I was at PASS I fielded a bunch of questions about the BI semantic model, multidimensional...

Date: 10/17/2011

Hi, today at my PASS session I gave a demo of a DAX Editor. This is a sample written by three...

Date: 10/13/2011

I am spending the next couple of days getting ready for PASS Summit 2011. I have a session on...

Date: 10/10/2011

Marco Russo has a nice post about the basics of configuring the workspace database server. You can...

Date: 10/03/2011

The Office ACE provider is used to import from text files, Excel files, and Access files. Just like...

Date: 09/29/2011

With a new storage engine comes new processing options. Here are some fast facts about processing...

Date: 09/26/2011

By default, when you open the .bim file after closing it, the data comes back. Did you ever wonder...

Date: 09/23/2011

In my DirectQuery 101 post, I promised an example of configuring a model with DirectQuery only...

Date: 09/15/2011

Managing tabular models is pretty much like managing multidimensional models. We have a full array...

Date: 09/12/2011

The astute user may notice that the Analysis Services tasks included with Integration Services in...

Date: 09/08/2011

DirectQuery is to tabular modeling what ROLAP is to multidimensional modeling. It’s a way to...

Date: 09/06/2011

This is a follow up to part 1 – dealing with large row sets in the tabular designer. In this post I...

Date: 09/01/2011

Amir Netz’s two billion and seven rows demo at last year’s BI conference was not just...

Date: 08/29/2011

As I mentioned in my previous post on deploying tabular models using msbuild, we now have AMO for...

Date: 08/25/2011

Sometimes people get an error message about “Access is Denied” when trying to import from a...

Date: 08/22/2011

After you import or restore from PowerPivot, you are left with a workbook with pivot tables and...

Date: 08/17/2011

We have two pieces of functionality in Denali that allow you to promote a self-service model in...

Date: 08/15/2011

I have received a few questions from customers about how to build and deploy Analysis Services...

Date: 08/10/2011

Tabular projects have a very simple structure. When you create a tabular project, you see two files...

Date: 08/08/2011

This blog is back. Some time ago, I left the Workflow Designer team and joined the SQL Server...

Date: 07/10/2011

The MSDN documentation on the WF designer shell has a very short section describing how WF designer...

Date: 04/01/2010

Previously, I demonstrated how to use an ExpressionTextBox in a custom property editor. In this...

Date: 03/29/2010

I have fielded a couple of questions from customers and also a forum post asking how to get the...

Date: 03/22/2010

In my previous post about keyboard shortcuts, I promised a summary of the hostable editor shortcuts....

Date: 03/02/2010

Oh, the imports designer. This innocuous looking piece of UI packs a lot of functionality in a...

Date: 02/18/2010

Today the RC version of Visual Studio was made publically available for MSDN subscribers. See the VS...

Date: 02/08/2010

In the Workflow Designer, all input provided to the workflow must be valid according to the model...

Date: 02/01/2010

The hosted compiler does something called type coercion. It converts one type to another type using...

Date: 01/28/2010

Expressions created in the WF designer are serialized using square brackets, which is shorthand for...

Date: 01/25/2010

When I was at PDC I spent some time with Ed and Ashley of Ed and Ashley’s 5 minute show. They have a...

Date: 01/23/2010

Hi, today I gave a talk to our support team about the expression editing feature. Since this is all...

Date: 01/21/2010

The Enter and Tab keys work a bit differently in the ExpressionTextBox than in the big VB IDE. In...

Date: 01/18/2010

There are a whole bunch of buttons in the bottom right hand corner of the workflow designer. Here...

Date: 01/14/2010

The Workflow designer, like any good Visual Studio component, has many keyboard shortcuts. We are...

Date: 01/11/2010

Next>