Hello,

I would like to create a dynamic report that references an alternate time hierarchy. I understand I can use the TM1SET function that will create a dropdown member list and allows me to reference the alternate hierarchy. I am wondering if there is a way for the TM1RPTROW function to reference the TM1SET and display all of the members in the report rows. 

For example, the result of the TM1SET is a list of five products:

• product a
• product b
• product c
• product e

In the TM1RPTROW function, I reference the TM1SET using the "element list" property. Then I can select a value (product a - product e) and the row will update to show the selected product. However, I want to show all five products in the rows at once.  

Is something like this possible? Or is trying to use an alternate hierarchy in dynamic reports a lost cause?

TIA

Dynamic reports require DBRW sourced cube values/content to be returned/displayed. The DBRW function cannot reference alternative hierarchy values. TM1Val can reference hierarchies but that function is not part of Dynamic Reports. 

Given IBM have said that Universal Reports will supersede Dynamic Reports and given .104 (Just released) has User rows/columns, you may be better off putting your time in that. You can control both the X & Y axis content and reference hierarchies and with user rows I expect (Though I cannot be user) that you could use TM1Val Formulae in those user rows/columns. 

Hello,

I would like to create a dynamic report that references an alternate time hierarchy. I understand I can use the TM1SET function that will create a dropdown member list and allows me to reference the alternate hierarchy. I am wondering if there is a way for the TM1RPTROW function to reference the TM1SET and display all of the members in the report rows. 

For example, the result of the TM1SET is a list of five products:

• product a
• product b
• product c
• product e

In the TM1RPTROW function, I reference the TM1SET using the "element list" property. Then I can select a value (product a - product e) and the row will update to show the selected product. However, I want to show all five products in the rows at once.  

Is something like this possible? Or is trying to use an alternate hierarchy in dynamic reports a lost cause?

TIA