TM1 Forum

hi, 

my client need to make some calcul with a subset, not a element. 

when i look in documentation, i find that DBRW only reference with element. 

there are a way to do what my client want? for exemple : DBRW(TM1ServerName:CubeName, subset1, Element2, Element3, …, ElementN);

thank a lot for help!


documentation

DBRW(TM1ServerName:CubeName, Element1, Element2, Element3, …, ElementN);

TM1ServerName = Name of the TM1 Server

CubeName = Name of the Cube 

Element1 to ElementN = An element in each dimension from the Cube. Each element must be ordered based on the dimension for the Cube.

Cross-posted IBM community :
https://community.ibm.com/community/use ... 4eda43146b

Have you tried it? you can replace an element name with a subset name within the dbrw. If it's not working check the view() or tm1rptview() is fine.

Hi,

As per the following link, I thought PAX didn't allow for subsets within DBRW's:

https://www.tm1forum.com/viewtopic.php?t=14731

It is a fairly old thread so maybe something changed since then that I wasn't aware of and Burnstripe is aware of.
If that is the case, what did I miss Burnstripe?


Maren

User-defined calculations may be an alternative.