Hi @cw-ch,
Sorry if it was confusing. Canvas does not bring all the dimension, it brings only what is defined in the MDX or subsets.
What I mean is that the Active form in Canvas v1.2 will bring all the data in one go (the first time the page opens or refreshes) depending on what is defined in the tm1-ui-rpt-config.**
Before Canvas v1.2 or in TM1 Active Form, when you drill down, the Active Form will request the data to TM1 and then display the rows so it will take a bit of time to get the data.
To make it faster, in Canvas v1.2, when you drill down or up, Canvas only shows or hides the available rows. If a row is not available in the page you won’t be able to drill down.
When you drill down, if the children are not part of the mdx or subset defined in tm1-ui-rpt-row, you won’t be able to drill down.
For examples in the Active Form of the samples application, the rows for the Region are defined by the following mdx:
tm1-mdx="{[Region].[1]}"
When you open the page, Canvas brings only the “1” element which is Total Europe. Only Total Europe is available, you won’t be able to drill-down to the children.
To be able to drilldown, you need to update the mdx to show all children and then collapse the consolidations:
tm1-mdx="{TM1SUBSETALL( [Region] )}"
tm1-collapse-elements="1,10,2,9"
This way Canvas brings all the data associated to the mdx and then collapse to show first only the consolidations, the children are hidden.