Refer to the exhibit.
A business analyst is testing an existing app that returns unexpected results.
– Using the selection tool, the business analyst observes the following behavior.
– Select a CompanyName and the associated OrderID records are white
– Select a Year and all OrderID records are gray
– Select an OrderID and the Quarter values are all gray, but the CompanyNames are white
– Select a ProductID and the associated ShipperName and OrderDates are white, but the Year is gray
What is causing these results?
A . OrderID should be the key field in the MasterCalendar
B . The logical model is NOT a star schema
C . The OrderDate fields are different data types
D . MasterCalendar should be associated to the OrderDetails table
Answer: B
Explanation:
Reference: https://mindmajix.com/snowflake-and-star-schema-in-qlikview
Leave a Reply