I am consuming dimensional data (TM1 cubes) with Report Studio. I want to combine the slice given by two (or more) tuple calls. This is because I want to include two elements from the same dimension that is not logically structured in a dimensional hierarchy. An example would be if I wanted to have combine the actuals for 2012 and 2013 without first making separate data items for both. Then I would have two expressions:
tuple([Actuals], [2012])
tuple([Actuals], [2013])
To illustrate what I want, I would ideally be able to write something similar to these suggestions:
tuple([Actuals], [2012], [2013])
tuple([Actuals], set([2012], [2013]))
However, these suggestions do not work. Hence, I was wondering if there is any other way of combining the slices given by two or more tuple calls, as described earlier in this post. Thanks in advance!
The answer that I was looking for can be found here: