Amol Pandey

Experiments, tutorials and ideas on developing business intelligence solutions

Skip to content
Menu
  • Home
  • About Me

Tag: SSAS

MSSQL – Runaway Job, Missing Max Run Time for SQL Job (Tame Them…)
SQL

MSSQL – Runaway Job, Missing Max Run Time for SQL Job (Tame Them…)

Posted on August 24, 2018August 24, 2018 by Amol Pandey

Hi, Recently an issue attracted my attention where we needed to tame the runaway SQL jobs, where the step in the job to import a…

SSAS – MSMDPUMP.DLL failing occasionally under high user loads
SSAS

SSAS – MSMDPUMP.DLL failing occasionally under high user loads

Posted on August 26, 2016August 26, 2016 by Amol Pandey

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…

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

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

Posted on August 24, 2016 by Amol Pandey

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…

SSIS: Extract data from the cube (via MDX) fails, OLEDB extended properties
SSIS

SSIS: Extract data from the cube (via MDX) fails, OLEDB extended properties

Posted on August 6, 2016 by Amol Pandey

This is a short post just to highlight a small setting which is critical to the task at hand !!! I was trying to import…

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

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

Posted on April 17, 2016August 1, 2016 by Amol Pandey

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…

Hot Topics

ASP Backup C# Case Catalog CI Code config CSharp Cube Data Deployment Docker Gulp Javascript Jenkins Job Key long Management Master MSSQL MVC NET pem Processing Python Query Report running Script Service Setup SQL SSAS SSIS SSISDB SSRS TFS Typescript ubuntu UDF VSTS Web Windows

Categories

Archives

© Copyright 2022 – Amol Pandey
Wisteria Theme by WPFriendship ⋅ Powered by WordPress