Which of the following should you use for the named set?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
The company has a SQL Server Analysis Services (SSAS) cube named ProductsCube1.
You are using Multidimensional Expressions (MDX) to define a named set in
ProductsCube1.
The Product dimension in ProductsCube1 contains a hierarchy named Type and an
attribute hierarchy named Size.
You need to configure the MDX to return all the products in the Type hierarchy with the size
value of Large.
Which of the following should you use for the named set?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
The company has a SQL Server Analysis Services (SSAS) cube named ProductsCube1.
You are using Multidimensional Expressions (MDX) to define a named set in
ProductsCube1.
The Product dimension in ProductsCube1 contains a hierarchy named Type and an
attribute hierarchy named Size.
You need to configure the MDX to return all the products in the Type hierarchy with the size
value of Large.
Which of the following should you use for the named set?

A.
Filter
(
[Product] . [Product Type] . [Product Name] . Members, ([Product] . [Size] . &[Large],
[Measures] . [Quantity]) > 0
)

B.
CrossJoin
(
[Product] . [Product Type] . [Product Name] . Members, [Product] . [Size] . &[Large]
)

C.
Generate
(
[Product] . [Size] . &[Large], [Product] . [Item Name] . [Item Type] . Members, ALL
)

D.
Exists
(
[Product] . [Product Type] . [Product Name] . Members, [Product] . [Size] . &[Large]
)

Explanation:



Leave a Reply 1

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


Mahmoud Ibrahim

Mahmoud Ibrahim

D