Starting SSIS 2012 Job Remotely
Scenario: Inspired by the new SSIS 2012 capabilities, you’ve managed to convince management to install SSIS 2012 on a new server for new ETL development. But your existing ETL is […]
If you are not happy with the results below please do another search
Scenario: Inspired by the new SSIS 2012 capabilities, you’ve managed to convince management to install SSIS 2012 on a new server for new ETL development. But your existing ETL is […]
Recall that the Microsoft BI Semantic Model consists of three flavors: Multidimensional, Tabular, and Power Pivot. The default storage mode of Tabular and Power Pivot is the xVelocity in-memory engine. […]
Scenario You need to assign a dimension dynamically to a cube measure group, such as to calculate binning. In the extreme example, you might need to perform fact row level […]
In my “Optimizing Dimension Data Security” blog, I’ve mentioned that converting static sets to dynamic could reduce the connection initialization time. To my surprise, using Excel to connect to the […]
A customer is moving from Impromptu to SSRS. One of the SSRS missing features that was very important for this customer was the Imprompu pick list that allows users to […]
In the spirit of the last day of 2013, I’m sipping eggnog and contemplating on BI in 2013. BEST Microsoft leads the Gartner’s 2013 Business Intelligence Magic Quadrant. Microsoft leads […]
Scenario: A custom application needs to display a filter dialog to prompt the user to select accounts from a tree consisting of thousands of nodes, such as a tree that […]
Dimension data security is a great feature of Analysis Services and one of the top reasons to strongly consider a semantic layer in your BI implementations, as I mentioned in […]
In my previous blog, I was somewhat hard on Oracle for not testing their connectivity software property. On a positive note, I like their effort to integrate Oracle Developer Tools […]
The Atlanta BI Group is meeting tonight. Main Presentation: Dimensional Modeling 101 Level: Beginner Date: Monday, September 30th, 2013 Time 6:30 – 8:30 PM ET Place: South Terraces Building […]