- All Exams Instant Download
Which of the following can you use to filter results dynamically? (2 answers)
Which of the following can you use to filter results dynamically? (2 answers)A . Element linkingB . Report mapC . Results Object paneD . Input controlView AnswerAnswer: A,D
In which two situations should you use sub-queries? There are 2 correct answers to this question.
In which two situations should you use sub-queries? There are 2 correct answers to this question.A . When the query filter involves values that are knownB . When the query filter involves values that are not knownC . When the query filter for the report involves a value that will...
Which two are calculation context types? There are 2 correct answers to this question.
Which two are calculation context types? There are 2 correct answers to this question.A . InputB . OutputC . LogicalD . ConditionalView AnswerAnswer: A,B
What is the output of the following expression when the CurrentDate is January 31, 2014?
What is the output of the following expression when the CurrentDate is January 31, 2014? If (MonthNumberOfYear(CurrentDate())=1; Year(CurrentDate())-1; Year(CurrentDateQ))A . 2014B . 01/31/2014C . 01/31/2013D . 2013View AnswerAnswer: D
Which object should you use to aggregate the number of cars sold?
You are creating a report to summarize the number of cars sold by region . Which object should you use to aggregate the number of cars sold?A . SumB . DetailC . MeasureD . DimensionView AnswerAnswer: C
Modify dimension after "Section on".
Modify dimension after "Section on".View AnswerAnswer: B
Which method should you use to group query filters together to form one AND statement?
Which method should you use to group query filters together to form one AND statement?A . Drag the queries togetherB . Drag the query filters to the Group panelC . Select the filters, right-click and select GroupD . Select the filters, then click the Group Filters button on the toolbarView...
Why would you use the FormatDate() function? There are 2 correct answers to this question.
Why would you use the FormatDate() function? There are 2 correct answers to this question.A . To modify the format of a string object into a non-standard date format.B . To convert a string object into a date object.C . To convert a date object into a string object.D ....
Which three methods can you use to combine queries using the Web Intelligence Rich Client? There are 3 correct answers to this question.
Which three methods can you use to combine queries using the Web Intelligence Rich Client? There are 3 correct answers to this question.A . UNIONB . MINUSC . UNION ALLD . INTERSECTView AnswerAnswer: A,B,D
What is the correct formula for the RunningSum column (shown in the attached graphic)?
What is the correct formula for the RunningSum column (shown in the attached graphic)? A . RunningSum([Sales revenues];([Year];[Quarter]))B . RunningSum([Sales revenues];[Year];[Quarter])C . RunningSum([Sales revenues];([Year]))D . RunningSum([Sales revenues] in [Quarter])View AnswerAnswer: C
