usage of tuple function

[karthik12345]

Hi all,
   
I am consuming dimensional data (TM1 cubes) with Report Studio. I want to combine the slice given by using tuple. i tried like below but i am getting error

tuple ([USD] within set([Total Assets],[cUS1],[Total Legal],[Total Partners],[Total Projects],[Total (For Taxes)],[Total JBA Actuals],[Total Customers],[Total AE],[All Excl Corp RO],[EBITA]))

but i am getting below.
XQE-V5-0017

      V5 syntax error found for data item 'Data Item2' of query 'Query2', invalid token "within" found after "tuple ([USD] ".
 
kindly advise me how i have to use tuple function for the above requirement.


Thanks,
Karthee

[cognos05]

Why do you want to use Tuple here?
Tuple should be used when you need to pick a specific value for a given member.

Ex(Tuple([Qty],[Product1],[2016]) so this will give us the qty for product1 for 2016 .

In your example I think you might need to use (
Total()

Thanks,
Nithya

[karthik12345]

Thanks Nithya1224,
    I have a cube with 13 regular dimensions and 1 measure dimension, i want the USD(query item) of all 13 regular dimensions.(intersection point). thats why i used tuple function.

tuple ([USD] within set([Total Assets],[cUS1],[Total Legal],[Total Partners],[Total Projects],[Total (For Taxes)],[Total JBA Actuals],[Total Customers],[Total AE],[All Excl Corp RO],[EBITA]))

Thanks,
Karthee

[MFGF]

Thanks Nithya1224,
    I have a cube with 13 regular dimensions and 1 measure dimension, i want the USD(query item) of all 13 regular dimensions.(intersection point). thats why i used tuple function.

tuple ([USD] within set([Total Assets],[cUS1],[Total Legal],[Total Partners],[Total Projects],[Total (For Taxes)],[Total JBA Actuals],[Total Customers],[Total AE],[All Excl Corp RO],[EBITA]))

Thanks,
Karthee

What is [USD]? A measure? Member? Set? Attribute? Something else?

Assuming it's a measure, you should be able to use:

tuple ([USD],[Total Assets],[cUS1],[Total Legal],[Total Partners],[Total Projects],[Total (For Taxes)],[Total JBA Actuals],[Total Customers],[Total AE],[All Excl Corp RO],[EBITA])

MF.

[karthik12345]

Thanks MFGF,
  Now it is working fine..