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 …
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 …
Some times you may receive instructions from you DBA’s to change your database collation (which implies to propagate the change to the column level collation). But the change at the database level does not propagate to your columns, to match all across by default and you are stuck to navigate to each table an find Read More …
Hi Recently I was working on a data warehouse project and was tasked to generate a date dimension table. Now some of the available options for me to achieve the same are listed out as below: Using the loops in SQL to iterate and populate dates Using the date wizard in SSAS (multidimensional) Copy the Read More …