You plan to create a Power BI report. You have the schema model shown in the exhibit. (Click the Exhibit button.)The mod

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

You plan to create a Power BI report. You have the schema model shown in the exhibit. (Click the Exhibit button.)The mod

Post by answerhappygod »

You plan to create a Power BI report. You have the schema model shown in the exhibit. (Click the Exhibit button.)The model has the following relationships:-> Store to District based on DistrictIDSales to Store based on LocationID-> Sales to Date based on PeriodID-> Sales to Item based on ItemIDYou configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage.When the district managers view the Store by Items report, they see items for all the stores.You need to ensure that the district managers can see items for the stores they manage only.How should you configure the relationship from Sales to Item?
You Plan To Cre 1
You Plan To Cre 1 (41.38 KiB) Viewed 71 times
You Plan To Cre 2
You Plan To Cre 2 (116 Bytes) Viewed 71 times
A. Select Assume Referential Integrity.
B. Change the Cardinality to One to Many (1:*).
C. Change the Cross filter direction to Both.
D. Change the Cardinality to One to one (1:1).
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This topic has 1 reply

You must be a registered member and logged in to view the replies in this topic.


Register Login
 
Post Reply