As I demo MDS, there is one question that is asked pretty often - "Do I have to use the Import Wizard to pull the data from the Stage table into the MDS table?". Microsoft made this a little bit confusing so I am going to explain how Stage sync can be initiated programmatically. There … Continue reading Loading data in MDS programmatically
Author: Business Intelligist
Dynamic security in a tabular model for analysis services
The second iteration of the tabular model for analysis services now allows us to implement very sophisticated security scenarios including row-level dynamic security. In order to implement it, first we need the means of finding out the windows credentials of the user. That can be accomplished using the DAX function USERNAME(). Second, we need to map … Continue reading Dynamic security in a tabular model for analysis services
More on Powerview on my Windows 8 Tablet
I have finally figured out how to exit the Full Screen mode on a tablet. Normally, one would need to hit Escape to exit into the reading or editing modes. Since there are no Esc key on the soft keyboard, it was always a challenge for me to exit out. Yesterday, I finally found something … Continue reading More on Powerview on my Windows 8 Tablet
PowerView on Google Chrome
I just noticed that Chrome is not listed as a supported browser for PowerView and in fact somebody already filed it as an issue on the connect site here http://bit.ly/IYwdfx. I normally use Internet Explorer for everything work related, but I also use Chrome a lot for email and also Google Music service (not that it would not run … Continue reading PowerView on Google Chrome
How to create Sharepoint workflow for MDS
Microsoft Master Data Services is one of the most exciting new features of SQL Server 2012. Technically, the V1 of the product was introduced with SQL Server 2008 R2, but to be completely honest, it did not get much acceptance. In my prognostication, this will drastically change with the V2 of the product. There are two … Continue reading How to create Sharepoint workflow for MDS
Reading and Loading SharePoint Data using SSIS
Lists are one of the cornerstones of SharePoint and many companies have a wealth of information stored and managed using this SharePoint feature. I sometimes get questions whether it is possible to extract that data (or load that data) into a data warehouse or a cube elsewhere. The answer is yes, using the SharePoint SSIS Adapters. … Continue reading Reading and Loading SharePoint Data using SSIS
Office 15 beta
Looks like we only have a month or two before the next version of Microsoft Office (commonly known as Office 15) becomes available for beta testing. Not surprising, SharePoint, Visio and Project will be released in a beta form around the same time.
Choosing a Tabular or Multidimensional model in SQL Server 2012 Analysis Services
Many great discussions are taking place about the future of the Multidimensional mode for the Analysis Services. It is very clear where the majority of the investment went for the 2012 version (hint... think rows and columns and not multidimensional). At the same time, one might argue that the traditional or Multidimensional set of features is already … Continue reading Choosing a Tabular or Multidimensional model in SQL Server 2012 Analysis Services
Microsoft SQL Server 2012 Fast Track White Paper is now available
Microsoft has updated its excellent Fast Track ( Microsoft Data Warehouse reference architecture) white paper for latest versoin of SQL Server (2012). Whether you decide to follow this architecture or not (and there are good reasons for and against it given your budget and objectives), you will find a wealth of great and useful information that will help you … Continue reading Microsoft SQL Server 2012 Fast Track White Paper is now available
SharePoint on iPad
Microsoft has recently released a Cumulative Update 2011-12 for Microsoft SharePoint that enables consuming Microsoft BI data visualizations on Apple iPad running iOS 5 Safari browser. Not all visualizations are supported: Visualization Type Renders on iPad Dashboards (filters, linked elements) YES Excel Services (including PPS webpart) YES Reporting Services (including PPS webpart) NO PerformancePoint ScoreCards YES … Continue reading SharePoint on iPad
business intelligist 