I know very late to the game, but I am working on migrating our websheets from TM1 Applications to PAW. I have built out the Security stuff in the application and that is all working. However I am noticing that there are a lot of functions that work when developing in Excel that don't work in PAW. Is there a listing of these or do you just have to discover them for your self. Some examples.
1. In Cell images does not work.
2. TM1ELLIST does not work.
It is strange that IBM would make something that functions just fine in excel not work when viewing in PAW.
What PAfE functions do not work in PAW
-
- Posts: 6
- Joined: Fri Jan 31, 2020 12:57 am
- OLAP Product: Planning Analytics
- Version: 2.0
- Excel Version: 360
- Elessar
- Community Contributor
- Posts: 412
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: What PAfE functions do not work in PAW
Hello,
TM1ELLIST does work in websheets. And all other TM1 worksheet functions should work in websheets. You can find a list of supported and unsupported Excel functions here: https://www.ibm.com/docs/en/planning-an ... ctions-tm1
TM1ELLIST does work in websheets. And all other TM1 worksheet functions should work in websheets. You can find a list of supported and unsupported Excel functions here: https://www.ibm.com/docs/en/planning-an ... ctions-tm1
-
- Posts: 6
- Joined: Fri Jan 31, 2020 12:57 am
- OLAP Product: Planning Analytics
- Version: 2.0
- Excel Version: 360
Re: What PAfE functions do not work in PAW
Sorry I should clarify. Yes it works in a websheet. However when I publish the websheet to PA. And then view the websheet in a report in PAW it does not work.
- Elessar
- Community Contributor
- Posts: 412
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: What PAfE functions do not work in PAW
The whole websheet? Is it blank?