-
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 hierarchy. So for example for product member “Fender Set – Mountain” (user hierarchy [Product].[Product Categories]) the measure value should be the following string “All Products -> Accessories -> Bottles and Cages”. In this blog post I’ll provide the comments on the proposed solution as well as my own solution to the puzzle. These MDX functions were used in the solution: Generate, Hierarchize and Ascendants.
-
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 […]