Her visitors

Region 1: Implement Row-Top Security in the Stamina BI Desktop computer

Region 1: Implement Row-Top Security in the Stamina BI Desktop computer

Supply: Nine needs material adapted from various workshops by Jose Lena Stevens, Pivotal Resources and JP Van Hulle, Michael Education Foundation.

Checking out data with Electricity BI has always been interesting in my opinion. Which have ever-increasing data arrives a great deal more chance, thus significantly more security is necessary. On this page, I will establish exactly what row-peak safety in the Electricity BI are and just how will it really works. I am going to plus have shown in more detail how exactly to use the same inside Energy BI Pc. Later, we’ll as well as talk about tips use it row-level cover in Energy BI service also. To know about line-height coverage when you look at the SQL Server, excite check my personal past post, in which I’ve told me how to pertain a comparable.

Uploading Analysis for the Electricity BI

The first step inside the showing one Stamina BI feature would be to weight the latest dataset on the Strength BI ecosystem and create the brand new required artwork. For this article, I’m going to utilize the well-known AdventureWorksDW databases, since provided by Microsoft. You could potentially install it database and possess it attached to the Desktop.

Select several tables on AdventureWorksDW databases. I have picked a few tables in the database, which can be the following.

In the long run, would an example writeup on and that you would want to pertain the brand new row-height defense into the Electricity BI. For this example, I’ll place the newest row-top cover to your SalesTerritoryGroup line. As you can see, new SalesTerritoryGroup column would be next divided in to SalesTerritoryRegion. When we assign spots so you can a particular territory category, merely study related regarding group will be apparent whenever you are almost every other ideas will be hidden from the screen.

To incorporate line-top safety within the Fuel BI, demand Modeling case at the top, and select Create positions.

Once you simply click Manage, you will have a list of dining tables regarding the investigation model of which you are able to look for a filter to put on the fresh new row-peak defense.

Replace the “value” throughout the DAX term that have a real really worth about SalesTerritoryGroup. Why don’t we range from the really worth while the “Europe” and you can in a fashion that so it part commonly filter analysis just for those information to own European countries as the region class.

Ultimately, why don’t we carry out a role to possess an employer who would like to monitor conversion process across Europe and you may United states. We need to her give usage of these two regions towards the director. You need the next phrase in order to assign one or more worth to have a job.

Now that you will find developed the jobs let’s proceed and find out the newest implementation within the real. Discover an alternative from inside the Energy BI, in which we can understand the profile on the perspective of your roles that we simply composed. It will help all of us try whether your DAX filter phrases try being employed as questioned, assuming the newest row-peak cover in the Energy BI is going to be accompanied truthfully.

Let us try to observe how the new profile browse when we discover a different character. Find Europe given that part and you may proceed in the future.

You are able to observe that the latest report makes the brand new visualization, however, just for the part which is chose. You can also observe towards the left-hand better that it’s stated as “Now watching report just like the Europe”. Find the way the places simply for Europe are blocked while the range chart now reveals just one range, which is having European countries just.

Once the I’m going to filter out towards the territory category, I am going to expand the new DimSalesTerritory and pick Put Filter out then get a hold of the new line SalesTerritoryGroup

As you can tell now, most of the regions belonging so you’re able to The united states to be presented as well as just one line for similar on range chart.

دیدگاهتان را بنویسید

نشانی ایمیل شما منتشر نخواهد شد.