TM1: ActiveForm and TM1RPTROW with multiple rows

[Newcomer]

Hi All,

I would like to create an excel active form like shown in the attached file.

Record and Field are 2 dimensions, so in this activeform I would like to show the cube-data.

Record1: conatins the TM1RPTROW-Formula
Field1-4: contains the DBRW-Formulas

Is such a construct possible ?

Thanks in advance,
Newcomer

[tomok]

Is such a construct possible ?

Not really. An ActiveForm is an Excel sheet with macros built-in (albeit they work in TM1Web too) that take a single row and a defined set of columns (the active form) and copy those rows and all the cell contents in them, down to cover the appropriate amount of rows that are in the drilled down state of the dimensions on the left. As such it takes ONE row and copies it down, not two (like in your example) or three or four or whatever. Field 4 needs to be on the same row as Fields 1 thru 3. Keep in mind you can apply all kinds of formatting to the columns that hold all of these fields, like wrapping text, etc., so you can get creative in the look of the form but you won't be able to do it exactly like you have shown. Best thing to do is just play with it and try different formatting scenarios.

[Newcomer]

Hi tomok,

thank you for your reply, I already feared your answer

While try-and-error-testing I found another "solution": I create a 3rd dimension (in my example Dim2) with 2 dummy-elements, so I get 2 records each dim1-element (see the picture). With quite dirty formatting-rules I get my sheet. It is not very funny by I get what I want.

Green: 2 connected fields (defined in the format range), I only have to display a comment in this field (for DBRW in column D, I use an IF-clause)

Thanks
Newcomer

[tomok]

I''m glad you were able to get what you wanted but in my learned opinion, modifying the model layout like this to get "formatting" exactly the way you want it, when said layout really doesn't change the information conveyed in the report, is really not best practice. In fact, I would say it's bad practice.

[Newcomer]

Hi tomok, Bad practice: that's a good description for what I am doing