Print Page - usage of tuple function

Title: usage of tuple function
Post by: karthik12345 on 29 Feb 2016 03:20:30 AM

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

Title: Re: usage of tuple function
Post by: cognos05 on 29 Feb 2016 09:57:43 AM

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

Title: Re: usage of tuple function
Post by: karthik12345 on 01 Mar 2016 04:17:03 AM

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

Title: Re: usage of tuple function
Post by: MFGF on 02 Mar 2016 06:20:27 AM

Quote from: karthik12345 on 01 Mar 2016 04:17:03 AM
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.

Title: Re: usage of tuple function
Post by: karthik12345 on 10 Mar 2016 08:07:24 AM

Thanks MFGF,
Now it is working fine..

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: karthik12345 on 29 Feb 2016 03:20:30 AM