You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube.
The cube includes a Product dimension that containsa Category hierarchy and a Color attribute hierarchy.
You need to return only the blue products in the Category hierarchy.
Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
A.
CrossJoin
(
[Product] . [Product Category] . [Product Name] .Members,
[Product] . [Color] . &[Blue]
)
B.
Filter
(
[Product] . [Product Category] . [Product Name] . Members,
( [Product] . [Color] . &[Blue] , [Measures] . [Sales Amount] ) > 0
)
C.
Exists
(
[Product] . [Product Category] . [Product Name] .Members,
[Product] . [Color] . &[Blue]
)
D.
Generate
(
[Product] . [Color] . &[Blue],
[Product] . [Model Name] . [Model Name] . Members ,ALL
)
Ok
0
0
The sales database includes a table named Customers that contains 45 columns and two tables that record all sales. The database does not store aggregated sales data. The database is continually maintained to provide optimal indexing. The database server is sized appropriately. The marketing department requests a delimited text file that includes six fields containing customer demographic information from the Customer table. You have the following requirenments
• Display the CustomerID in the first column. Organize the remaining columns alphaetically by column heading
• Sort Rows in Customer ID order
• Aggregate gross annual sales
• Minimize the time required to return the result
A -Only a SQL command -based and a Flat file destination
B – A table -based OLE DB Source, a script component and a Flat file destination
C – A SQL command -based OLE DB Source Aggregate and Sort Transformations and a Flat file destination
D – A table -based OLE DB Source Lookup, Aggregate and Sort Transformations and a Flat file
0
0
C
0
0