C-BOWI-30 試験問題を無料オンラインアクセス

Which two are limitations of a detail object? (Choose two.)

• A.It cannot be drilled on.
• B.It cannot be used in the WHERE statement of the query.
• C.It cannot be used in the report filter.
• D.It cannot be merged in a document.

Which object types can you merge when using Multi Queries in a Web Intelligence document (WID)?

• A.Dimension - Detail
• B.Dimension -Measure
• C.Measure - Measure
• D.Dimension - Dimension

You want to compare the sales revenue performance of the top 20% of your customers to the average of all of your customers. You decide to apply a rank on the table that shows customers and revenue and create a variable to show the average revenue for all customers. Which function should you use in the variable?

• A.NoRank()
• B.AverageAll()
• C.NoFilter()
• D.IgnoreFilter()

Which statement is true of the Where operator when used within a variable?

• A.It modifies the HAVING clause of the SQL generated to calculate the measure expression.
• B.It is not necessary to place parentheses around the values listed after the Where operator.
• C.It instructs the variable to calculate only where certain values are true.
• D.It modifies the WHERE clause of the SQL generated to calculate the measure expression.

Which three output context expressions are valid extended syntax expressions? (Choose three.)

• A.In Section Where ([State] = "CA")
• B.Where ([State]="CA" And [Year] ="2006")
• C.In Block Where Section = [State]
• D.Where Section In [State]
• E.Where ([State] = "CA")