Experiments, tutorials and ideas on developing business intelligence solutions
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 file from the FTP source at times would run up to 2 days (which would normally complete in ~2 minutes). Well at times ftp downloads by scripts are affected by Read More …
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 …
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 …
This is a short post just to highlight a small setting which is critical to the task at hand !!! I was trying to import cube data (MDX query result set), to my SQL table. So I set up my MDX as usual with an OLEDB connection to the cube (source), and similar one for Read More …
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 …