Using PA as a datasource in CA.  I have created a single element subset in a PA timescale dimension to represent "Current Month".  I find that in CA I can't access subsets in an Intersection (Tuple) object and when I manually create a Data Item tuple I get an XQE-PLN-0264 error when I try to use this subset.  Message says its looking for a member or measure.  But what function can I use to coerce this subset sourced element to a member?  Are PA subsets off-limits for use in tuples/calculations in CA?

Thanks for any insight.

------------------------------
Dean Watts
------------------------------

#CognosAnalyticswithWatson

A subset is always a set, even if it contains a single member. Try using item(subset,0) in the tuple


------------------------------
Paul Mendelson
------------------------------

Original Message:
Sent: Wed August 11, 2021 11:35 AM
From: Dean Watts
Subject: PA Subsets in CA tuples

Using PA as a datasource in CA.  I have created a single element subset in a PA timescale dimension to represent "Current Month".  I find that in CA I can't access subsets in an Intersection (Tuple) object and when I manually create a Data Item tuple I get an XQE-PLN-0264 error when I try to use this subset.  Message says its looking for a member or measure.  But what function can I use to coerce this subset sourced element to a member?  Are PA subsets off-limits for use in tuples/calculations in CA?

Thanks for any insight.

------------------------------
Dean Watts
------------------------------

#CognosAnalyticswithWatson

Thank you Paul, that is indeed what I subsequently learned.  The item() function produced the needed results.

Thanks,

------------------------------
Dean Watts
------------------------------

Original Message:
Sent: Thu August 12, 2021 08:21 AM
From: Paul Mendelson
Subject: PA Subsets in CA tuples

A subset is always a set, even if it contains a single member. Try using item(subset,0) in the tuple

tuple(measure, item(subset,0))

------------------------------
Paul Mendelson

Original Message:
Sent: Wed August 11, 2021 11:35 AM
From: Dean Watts
Subject: PA Subsets in CA tuples

Using PA as a datasource in CA.  I have created a single element subset in a PA timescale dimension to represent "Current Month".  I find that in CA I can't access subsets in an Intersection (Tuple) object and when I manually create a Data Item tuple I get an XQE-PLN-0264 error when I try to use this subset.  Message says its looking for a member or measure.  But what function can I use to coerce this subset sourced element to a member?  Are PA subsets off-limits for use in tuples/calculations in CA?

Thanks for any insight.

------------------------------
Dean Watts
------------------------------

#CognosAnalyticswithWatson