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 …
Hi, Recently I got engaged in a discussion, Which I feel the ones that really was an eye opener for me and some thing i thought trivial played an important role in my day today work. The conversation went as What is the effect of WHERE clause in a (INNER/LEFT/RIGHT) join, if moved to ON clause Read More …