TM1 Forum

Thank you very much Stefan for this answer. I am able to create a view using MDX, which I can see in PA workspace is correct. However, my ultimate goal is to read this view into a process and create a special summarized cube by using one of the hierarchies. When trying to read the MDX view, I get th...

I am using Planning Analytics 2.0 (on premises). The alternative hierarchy feature can be very powerful and it appears to be easy to retrieve data using either PAW or PAX. However, does anyone know if it is possible to retrieve data which references an alternate hierarchy by using either a DBRW form...

Does anyone know the syntax to take this one step farther? That is to be able to pass the dimension name as a parm to a process that would create a dynamic subset using the MDX code. For example, I have the following code: SubsetCreateByMDX('Level0','{TM1FilterByLevel({TM1SubsetAll([GR_ActuarialSegm...