Area 1: Apply Row-Height Protection during the Stamina BI Desktop
Present: Nine needs material adapted from various workshops by Jose Lena Stevens, Pivotal Resources and JP Van Hulle, Michael Education Foundation.
Examining investigation which have Fuel BI has been fascinating for me. With actually-broadening analysis will come a great deal more chance, and therefore more cover becomes necessary. In this article, I will introduce exactly what line-top protection within the Electricity BI try and how can it works. I’ll including have demostrated in more detail tips use a similar when you look at the Stamina BI Desktop. Later on, we’re going to along with speak about how exactly to use which line-level security in the Fuel BI solution also. To know about line-level coverage in SQL Server, please have a look at my early in the day post, in which You will find explained how to incorporate an equivalent.
Importing Data towards the Strength BI
Step one inside proving any Stamina BI ability is to try to load the dataset towards the Strength BI environment and build the called for design. For it post, I’ll utilize the greatest AdventureWorksDW database, since available with Microsoft. You could down load it databases and just have it attached to their Pc.
Look for a number of tables throughout the AdventureWorksDW database. You will find selected a number of tables regarding databases, which happen to be below.
Fundamentally, manage a sample writeup on and therefore you would like to use the newest row-top safety into the Stamina BI. For this analogy, I will put the fresh line-peak safeguards toward SalesTerritoryGroup column. As you can tell, the fresh SalesTerritoryGroup line would be then put into SalesTerritoryRegion. When we designate opportunities in order to a specific territory classification, simply investigation associated for this class could well be noticeable if you are most other ideas will be undetectable regarding the display.
