How to perform data masking – Business Intelligence Article

One of the cool features with Information Design Tool and UNX universes is the ability to point to different table views depending on your security profile. Because of this, we can easily perform data masking, which allows us to mask restricted data. For example, I have 2 different types of users. Group FULL who can see all revenue/cost measures, and Group PUBLIC who can see revenue measures but 0 for any cost measures. A question one might ask is, “Why…

Read More

Change Tracking Inserts Require SELECT Permission – Business Intelligence Article

I’ve been writing about change tracking in SQL Server for some time now, but I recently came across a permissions issue on a change tracking table that I’d never encountered before. When attempting to insert data into a change tracking-enabled table using an account with no select permissions, I learned that the effective security principal must have both insert and select permission to write data to a table that has change tracking enabled. Insert-only permissions for certain accounts Before we…

Read More

Interviews with Microsoft Data Community Speakers and Leaders – Business Intelligence Article

What is the key to advancing your career in the Microsoft data platform?  Here is some advice from some of the most successful people in the industry… Every year we have some big community events that bring together community leaders from all over.  These are international user group and community leaders who write books and speak at conferences. we had our local Oregon SQL Saturday “SQL Train” which is a chartered train – some coaches that one of our speaker’s…

Read More

How to Configure the Power BI Gateway to use Dataset Connection Parameters – Business Intelligence Article

A service provider or vendor might want to publish multiple copies of a report that should connect to different database servers or databases.  In a true multitenant service solution, we would have a singe database with row-level user mapping tables that filter data by the logged in user.  True multitenant solutions require quite a lot of planning and development work to implement.  In smaller-scale or interim solutions, copies of a report can be deployed to different workspaces and then queries…

Read More

Handling many-to-many joins using a bridge table (Part 1) – Business Intelligence Article

As a data warehouse architect, star schemas are great until we encounter the dreaded many-to-many fact to dimension scenario. For example, we have a Ticket Fact table and a Tag Dimension table. The cost metric is calculated at the ticket level, so tickets have the lowest granularity and hence the ticket fact table.   However tickets can be tagged with multiple describers. A ticket can be interesting, excellent, and complicated. If we flatten the tags into the fact table, you’ll notice…

Read More