Active form misery - continued

[Wim Gielis]

Hi all,

I encounter (again) an issue with active forms.

I am migrating a TM1 model (call it model A) and incorporate it into another TM1 model (model B). All dimension names, cube names, process names, etc. are unique.

I copy/pasted all websheets from model A to B, through the }Externals folder and restarting the receiving TM1 model. This is done on the remote desktop of the customer. Also all other objects were copy/pasted, in the Cube viewer it all works fine.

Now, some reports contain active forms. I can copy/paste the entire model A to my laptop, use Perspectives to the hardcoded TM1 model name (CAPEX) and the active forms work fine.

As the previous company that set up the reports hardcoded the TM1 server name I now need to find/replace all such CAPEX names to the model name of B. Easy enough with a find/replace in Excel. However, the active form refuses to return rows. This is done in PAFE on the server of the customer.

This is what it looks like locally on my PC:

11.png (24.5 KiB) Viewed 3329 times

Easy enough, 1 cube, nothing but plain selections with SUBNM and values with DBRW. Hardcoded server name CAPEX into these formulas as well as in TM1RPTROW, TM1RPTVIEW, etc.

This is what it looks like in PAFE on the server, with model name B:

12.png (30.65 KiB) Viewed 3332 times

Hardcoded server name for B with find/replace. All references are fine, subsets exist, and so on.

What am I missing here ? Don't tell me I cannot find/replace (hardcoded) server names to have the reports available in a different TM1 model... and that I would need to rebuild many many reports with active forms...

UPDATE: this method of copying a websheet and replacing hardcoded server names works in Perspectives and in TM1 Web. I wonder why it would not work in PAFE.

[MarenC]

Hi Wim,

what version of PAX are you on? There was a defect fixed in version 63 where #value was being shown.

Also, as a test, what happens if you have a very simple active form, looking at a cube with just 2 dimensions, does that not render either?

I presume when you publish the active form from PAX it works fine in web and PAW?

Maren

[Wim Gielis]

Hello Maren,

Thank you for your feedback.

It's version 2.0.55, on-premise install, Excel 2013 32 bits.

When I do the same with a simple 3-D cube and active form, it works.
I only need to find/replace TM1 server name 1 into TM1 server name 2 and it works out of the box.
The other report from yesterday is a different cube but ultimately not different.

[Wim Gielis]

It's solved !

The reason is a change in element names:

12.png (27.4 KiB) Viewed 3277 times

While the SUBNM's give a dropdown list but still show the element name from the other TM1 server:

13.png (15.09 KiB) Viewed 3277 times

Glad that it's solved and it's not the fault of Active forms. For once, I may add