Which set should you use?

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.)

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
)



Leave a Reply 2

Your email address will not be published. Required fields are marked *


MicrosoftAnswer

MicrosoftAnswer

Ok

Mahmoud Ibrahim

Mahmoud Ibrahim

C