A LookML developer creates a new model and a test dashboard from the model. The developer shares the link to the new dashboard with users, but the users report that all they see is the “Model Not Found” error.
What is a possible cause of this issue?
A developer wants to calculate the ratio of total sales from the orders view and total users from the users view.
Which two methods can be used to create ameasure that meets these requirements? (Choose two.)
A)
B)
C)
D)
E)
A user reports the following SQL error when selecting the discounted sale price field:
ERROR: column “order_items.sale_price”; must appear in the GROUP BY clause or be used in an aggregate function.
The developer checks the field definition and finds it to be:
measure: discounted_sale_price {
type: number
sql: ${sale_price} * 0.8 ;;
}
The developer also finds the LookML definition of the sale_price field to be:
dimension: sale_price {
type: number
sql: ${TABLE}.sale_price ;;
}
What isthe likely cause of the SQL error?
A developer defines the following measure in the order_items view:
The code must validate without errors.
Which action should thedeveloper take?
DumpsMate's team of experts is always available to respond your queries on exam preparation. Get professional answers on any topic of the certification syllabus. Our experts will thoroughly satisfy you.
TESTED 26 Apr 2024
