Active form misery - continued
Posted: Wed Jul 14, 2021 6:36 pm
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:
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:
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.
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 3330 times
This is what it looks like in PAFE on the server, with model name B:
- 12.png (30.65 KiB) Viewed 3333 times
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.
