-
SQL Server BI Quiz – 2011- Display "Breadcrumbs" for members of a user hierarchy
Recently, I’ve been provided with a generous offer to participate in the SQL Server BI Quiz – 2011 hosted on beyondrelational.com. The task was to fill in the MDX expression for a calculated measure ‘Parent Breadcrumbs’ that should display a string consisting of all parent names separated by a ‘ –> ’ for a user…
-
ExcelStartup PowerShell module v1.1 released
Tweet If you are new to ExcelStartup PowerShell module please read the previous post Shortcuts to start Excel with or without PowerPivot add-in. A very good observation from Dan English (blog | twitter) made me do a small but important change in the behavior of the ‘Excel only’ shortcut. Here’s the excerpt from the Dan’s…
-
Shortcuts to start Excel with or without PowerPivot add-in
Tweet You love PowerPivot but you hate waiting for Excel to load just to do something quick-and-dirty? Thought so, me too! Here’s a quote from Dan English’s blog (blog | twitter) I came across while my PowerPivot add-in wouldn’t load (btw., I had to edit the registry to resolve the situation but that’s another topic): The…
-
Importing data from 64-bit Excel in SSIS
Tweet Last night I was #sqlhelping someone on twitter having an issue with importing data from excel. The data preview dialog returned results correctly, while the package errored at run time with a connection error. The issue was caused by Run64BitRuntime property of the package being set to true and it is in fact a…