Dynamic Subsets in Dynamic Slices

[hbell]

Version 9.1.3.

Trying to put a dynamic subset into a Dynamic Slice so that it will always show all Initiatives a user is entitled to see. The expression is shown here:

{TM1SORTBYINDEX( {TM1SUBSETALL( [hb_Init] )}, ASC)}

The subset works fine in Cube Viewer. However, if I try to create a dynamic slice it does not seem to work. For example, if an Initiative is deleted, instead of disappearing from the dynamic slice it stays there and comes up with a KEY_ERR.

To be honest, I'm not all that surprised. It would have been very clever if it worked. Just wanted to check that there is no "Work Properly" button that I should have pressed.

What I was working towards was a WebSheet with an ActionButton that allows a user to set up a group of (say) 10 new initiatives. After adding them to the dimension (using a simple incremental number counter), the procedure should then present a cube view back to the user with all the empty Initiatives down the page for him to complete the data.

In the light of the above discovery, I'm thinking that the user will need to navigate off, under their own steam, to a Web View (where the dynamic expression should work). Not the end of the world, but a little less helpful.

thanks ............hugh

[lotsaram]

Dynamic slices don't work on TM1 web!

When viewed in a web sheet a dynamic slice is converted to a static slice. If you want this functionality you need active forms in 9.4 ...

[hbell]

OK ... thanks for the update

[Gregor Koch]

Hi

Although Dynamic Slices don't work on TM1 Web you could still use SUBNM functions on a dynamic subset to return your row headers which will make your web report kind of dynamic. Surely will allow you to do what you described.

Cheers