SSAS – MSMDPUMP.DLL failing occasionally under high user loads

Hi, Recently in one of our systems, we started experiencing that the cube which were hosted out by the use of MSMDPUMP.DLL, on some occasions responded with failed request during the high load by multiple users. And researching for the same, provided us with the following steps with which we were able to restore the Read More …

Cannot set the initialization properties for OLE DB provider “MSOLAP” for linked server, Double Hop Authentication

Ohhh… Well the above words can only describe the pain which I encountered again on a different combination of multi server components authentication of MSBI using windows authentication. Well the set up, I worked with is as follows: So as it goes, I had a chart on SSRS, which sources the data from the SQL Read More …

Case Study: Reporting and Planning System BI, ASP MVC and MSBI Stack

Hi, Is it Reporting… Is it Planning… Can you classify, what system is yours…. Well sorry for my sarcasm, but indeed its a question which at times is not very clear in the objectives of the business when they are mentioning their BI systems. Reporting: As system which collates data from multiple (or) single source Read More …