A report author creates the following nested report using 2 adjacent levels of the same hierachy. Users should be able to drill down on the inner nesting with the outer nesting remaining unchanged. What advanced drilling behavior should the report author use to achieve this?
Exam C2090-645 - admin post to:2017-07-28 read more

To display all individual campaigns in a crosstab report, a report author could use the expression set([TrailChef Campaign],[EverGlow Campaign],[Course Pro Campaign]). Instead, the report author decides to use the parent member of the campaigns in the set expression "children([All Campaigns])". Which statement is true about the method that was used?
Exam C2090-645 - admin post to:2017-07-28 read more

Which of the following statements is correct about the order function?
Exam C2090-645 - admin post to:2017-07-28 read more

To create a report from the data source shown, what entities will the report author use?
Exam C2090-645 - admin post to:2017-07-28 read more

A report author is working with an OLAP data source. The report author creates a query that uses a caption function on a member and applies a string function. What is a possible consequence of this action?
Exam C2090-645 - admin post to:2017-07-28 read more

When must a report author use the caption function?
Exam C2090-645 - admin post to:2017-07-28 read more

Instead of prompting the user to select any countries in Europe, the report author wants to constrain the user to select one or more countries from the Northern Europe region. What kind of prompt should be used and how can this be achieved?
Exam C2090-645 - admin post to:2017-07-28 read more

The author has created a complex expression called "Sorted Products" on the row edge, which sorts product line by Revenue for 2006. What must the report author do to sort the members when drilling down?
Exam C2090-645 - admin post to:2017-07-28 read more

Which of the following family functions is most similar to the relative time function parallelPeriod?
Exam C2090-645 - admin post to:2017-07-28 read more

What is a key difference between the total function and the aggregate function?
Exam C2090-645 - admin post to:2017-07-28 read more

What is true about MUNs?
Exam C2090-645 - admin post to:2017-07-28 read more

The report author uses the filter function to focus data in a report, but the results are unexpected. What did the report author overlook when filtering the data?
Exam C2090-645 - admin post to:2017-07-28 read more

When would a report author define a set?
Exam C2090-645 - admin post to:2017-07-28 read more

Consumers want a report to compare the revenue and quantity sold for all product lines in a selected quarter, to the same quarter for the previous year. They also want to see the total for periods, up to and including the quarter selected. Which of the following dimensional functions could the report author use to create this report?
Exam C2090-645 - admin post to:2017-07-28 read more

Of the following prompt syntax expressions, which two are considered to be dimensional? 1) -> ?? 2) in (??) 3) = ?? 4) set( -> ??)
Exam C2090-645 - admin post to:2017-07-28 read more

A report author creates an expression using the closingPeriod function to return the latest month found in the data source, and names the expression "Current Month". What can the report author do with "Current Month"?
Exam C2090-645 - admin post to:2017-07-28 read more

What is the default behavior when drilling down on an edge in a crosstab report?
Exam C2090-645 - admin post to:2017-07-28 read more

Which of the following are dimensional objects?
Exam C2090-645 - admin post to:2017-07-28 read more

A report author creates a revenue report from an OLAP data source. On the rows, there are nested levels, each from different dimensions having a large number of members. The report author filters out empty rows using the expression "[Revenue] > 0". When running this report, there is poor performance. What could cause this?
Exam C2090-645 - admin post to:2017-07-28 read more

When the report consumer drills through from a dimensional member to a relational data item, what data type is passed?
Exam C2090-645 - admin post to:2017-07-28 read more

Which of the following is true if a report author nests members in a crosstab report?
Exam C2090-645 - admin post to:2017-07-28 read more

A crosstab report has product lines in the rows, years in the columns, and revenue as the measure. In Query Explorer, from the source tree, the report author drags the order method Telephone to the Slicer pane. Why does the report author do this?
Exam C2090-645 - admin post to:2017-07-28 read more

When a report author inserts Revenue into the Measures area of a blank crosstab report, which of the following statements is correct?
Exam C2090-645 - admin post to:2017-07-28 read more

A report author uses the following expression: lastPeriods(3,[2007/Mar]). What data will be returned when the report is run?
Exam C2090-645 - admin post to:2017-07-28 read more

A report author creates a report with a drill-through definition. In the target report the parameter expression is " ->?P?". What type of data must be passed to the parameter?
Exam C2090-645 - admin post to:2017-07-28 read more

The sales manager requires a crosstab report to display the top 3 sales people for the month. Considering that an OLAP data source is used, what will the report author use when creating this report?
Exam C2090-645 - admin post to:2017-07-28 read more

What type of prompt would a report author use to return a set of members from a hierarchy?
Exam C2090-645 - admin post to:2017-07-28 read more

The following expression is used to focus OLAP data in the rows of a report: filter([sales_and_marketing].[Order method].[Order method].[Order method type], [Revenue]>150000000). Which of the following statements describes the purpose of the expression?
Exam C2090-645 - admin post to:2017-07-28 read more

Based on the crosstab displayed, the report author creates a singleton using the tuple function as follows: tuple([Camping Equipment],[Revenue],[2006]). Which of the following will appear in the singleton when the report is run?
Exam C2090-645 - admin post to:2017-07-28 read more

In the data source shown, what dimensional component is selected?
Exam C2090-645 - admin post to:2017-07-28 read more

A report author uses an OLAP cube to create a crosstab with Revenue as a measure, the Product line level in the rows, and the year members (2004-2007) in the columns. How can the report author efficiently determine the difference in revenue between the years 2005 and 2006?
Exam C2090-645 - admin post to:2017-07-28 read more

A report author has created a crosstab report from the data source shown. The Retailer name level has been dragged to the rows and default drilling up and down has been activated. What will be displayed in the report if the consumer drills up on one of the members of Retailer name?
Exam C2090-645 - admin post to:2017-07-28 read more

The following expression is used in a crosstab report: filter([sales_and_marketing]. [Product brand].[Product brand].[Product brand type],[Revenue]<100000000). There are 26 product brand types in the OLAP data source. Why does the report only return 11 product brand type rows?
Exam C2090-645 - admin post to:2017-07-28 read more

Which of the following statements is true about explicitly defined member sets?
Exam C2090-645 - admin post to:2017-07-28 read more

A report runs, and is 433 pages long, with 19,010 rows. Many of the rows are blank. The report author uses a filter function to filter nulls, and runs the report again. The result is 143 pages, with 6273 rows, and none of the rows are blank. What filtering style did the report author decide to use?
Exam C2090-645 - admin post to:2017-07-28 read more

What does the following expression do: "generate([Product line],topCount(descendants(currentMember([sales_and_marketing].[Products].[Pro ducts]),[ sales_and_marketing].[Products].[Products].[Product]),2,[Revenue]))"?
Exam C2090-645 - admin post to:2017-07-28 read more

If the syntax for the head function is head(set_exp[,index_exp]),then which of the following expressions is correct?
Exam C2090-645 - admin post to:2017-07-28 read more

Based on the diagram, if the expression firstSibling([2006 Q 1]) is used in the report, what item will be returned?
Exam C2090-645 - admin post to:2017-07-28 read more

A data source has a Time hierarchy, a Products hierarchy, and a Retailers hierarchy. What are the preferred techniques the report author would use to focus reports for this type of a data source?
Exam C2090-645 - admin post to:2017-07-28 read more

What kind of authoring style uses the filter function?
Exam C2090-645 - admin post to:2017-07-28 read more

Can a prompt be used in the expression of a slicer?
Exam C2090-645 - admin post to:2017-07-28 read more

The report author creates a source report that contains values from "Products" on which the report consumer will drill through for details. The report author has created a target report which expects a member from the source. Is this a supported drill-through combination?
Exam C2090-645 - admin post to:2017-07-28 read more

What dimensional function is used to return the members on the level below the Product line level?
Exam C2090-645 - admin post to:2017-07-28 read more

Why would a report author consider overriding the default drill behavior?
Exam C2090-645 - admin post to:2017-07-28 read more

Which statement is true about MUNs?
Exam C2090-645 - admin post to:2017-07-28 read more

A report author creates a crosstab as shown. What is the default measure of the report?
Exam C2090-645 - admin post to:2017-07-28 read more

What functionality will allow the report consumer to focus the report each time it is run?
Exam C2090-645 - admin post to:2017-07-28 read more

The "Sales" and "Inventory" data stores each have "Products" and "Time" dimensions. For drill-through between the data stores on the "Products" and "Time" dimensions to work, which items in the structures must be identical in the data stores?
Exam C2090-645 - admin post to:2017-07-28 read more

In a crosstab report, the report author wants a column to display a percentage of overall revenue that a particular product contributed to.
Which of the following is a valid dimensional expression for this purpose?
Exam C2090-645 - admin post to:2017-07-28 read more

The report author wants to create a report to compare the sales of product types for special sales promotions in 2005 and 2006, but the report will exclude regular sales. Which style of authoring and which function will the report author use to create this report from a cube data source?
Exam C2090-645 - admin post to:2017-07-28 read more

The dialog box shown appears when a report is run. What should the report author do to correct the situation?
Exam C2090-645 - admin post to:2017-07-28 read more

Which of the following statements is true about a slicer?
Exam C2090-645 - admin post to:2017-07-28 read more

Assuming that Star products and Husky products are sets, which statement below is correct about the sets in the graphic?
Exam C2090-645 - admin post to:2017-07-28 read more

In a crosstab, Campaign is in the rows area, Order method type is in the columns area, and Quantity is the measure. Campaign and Order method type are specified in the query. The report runs, displaying quantity values for all years. Why does this happen?
Exam C2090-645 - admin post to:2017-07-28 read more

The report author creates a query where two items (TopThree and Retailer country) exist in the same member set. The expression for TopThree is: topCount([Retailer country],3,[Revenue]). What drill behavior should the report author set in order to display the top three children instead of all children on drill down?
Exam C2090-645 - admin post to:2017-07-28 read more

A report author can use a slicer to do what?
Exam C2090-645 - admin post to:2017-07-28 read more