What PAfE functions do not work in PAW

Post Reply
engineerairborne
Posts: 6
Joined: Fri Jan 31, 2020 12:57 am
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: 360

What PAfE functions do not work in PAW

Post by engineerairborne »

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.
User avatar
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

Post by Elessar »

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
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 10th article - AI has failed TM1 Quiz.
engineerairborne
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

Post by engineerairborne »

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.
User avatar
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

Post by Elessar »

The whole websheet? Is it blank?
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 10th article - AI has failed TM1 Quiz.
Post Reply