Experiments, tutorials and ideas on developing business intelligence solutions
Hi, being a developer at times we value our code more than the content that is modifies… Hmmm.. Well sounds suspicious from the business standpoint, but from a developer perspective our code is gold !!!! Any ways, this post outlines one of the methods to backup your MSSQL database schema and SQL jobs regularly. This Read More …
Hi, This post is about a quick solution to a problem which I have come across quite few times. In few instances, I was required to obtain the “Latitude” and “Longitude” coordinates of the address stored as strings/text in the columns of the database. This was primarily required to leverage the mapping features of the 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 …
In the data warehousing world of relationship, identification at the earliest is vital (lets say we are targeting a star schema Kimball model). But at times you miss out on the critical information during requirement phase and later is brought (even change of business requirements) on table that you have add a new dimension to Read More …