Create a Set of Tuples

[an5ir]

Hi is there a way to create A set of tuples for example using mdxpy:

SELECT   
  {([Customer].[Country].[Australia], [Product].[Product Line].[Mountain]),
   ([Customer].[Country].[USA], [[Product].[Product Line].[Road])}
ON 0   
FROM [Adventure Works]  
WHERE Measures.[Internet Sales Amount]  

regards,

Ansir

[MariusWirtz]

Here are two ways to do it:

from mdxpy import MdxBuilder, MdxTuple

query = MdxBuilder.from_cube("Adventure works")
query.add_member_tuple_to_columns(MdxTuple.of(
    "[Australia].[Country].[Australia]",
    "[Product].[Product Line].[Mountain]"))
query.add_member_tuple_to_columns(MdxTuple.of(
    "[Australia].[Country].[USA]",
    "[Product].[Product Line].[Road]"))
mdx = query.to_mdx()

print(mdx)

from mdxpy import MdxBuilder, MdxTuple, Member

query = MdxBuilder.from_cube("Adventure works")
query.add_member_tuple_to_columns(MdxTuple.of(
    Member.of("Australia", "Country", "Australia]"),
    Member.of("Product", "Product Line", "Mountain")))
query.add_member_tuple_to_columns(MdxTuple.of(
    Member.of("Australia", "Country", "USA"),
    Member.of("Product", "Product Line", "Road]")))

mdx = query.to_mdx()

print(mdx)

[an5ir]

thanks

your help is greatly appreciated.