Have not had a response to this from IBM Support in months, so now I turn to the community and hope someone can explain this behavior we see.

I have an active form which was originally created on a local TM1 (10.2.2) server in Perspectives. We have now moved to a PA Cloud solution and we are experiencing some odd behavior with the active form. The layout or format of different cells/columns show up differently and we have tried to play around with most of the language settings on the user side without finding a good explanation.

If I open the active form from the RDP Perspective (which is in English) my date formatted cells show up as mm/dd/yyyy and my elements are shown with their alias (id and name).

If I open the same active form in PAX on my local pc then the date format reflects my local setting of dd/mm/yyyy but my elements are not showing the alias - only the id.

If I open the same active form in PAW (or TM1web - same result) then the date format is back to mm/dd/yyyy despite my local os and browser is set to Danish (which is dd/mm/yyyy) and the elements are shown with their alias (id and name).


What we want to have is an active form which will show us the elements with alias and the date format as it is setup up locally (dd/mm/yyyy) in both browser and PAX.

Any ideas?

------------------------------
Jesper Poulsen
------------------------------

#PlanningAnalyticswithWatson

Hi Jesper,

I suspect these are really two different issues.  Let me try to summarize:

1 - Alias not working in PAX (but does work in Perspectives and TM1Web).  We should take a look at the TM1RPTRow function, there is a parameter for this function which determines which alias is used.  It would help to see the xlsx/xlsm file for this Workbook to examine how the alias parameter is being passed to this function.   Can you also confirm you have tested in a current PAX version?  2.0.43 was just released.  This is to rule out any defects that we have already resolved.

2 - Date format in TM1Web is mm/dd/yyyy instead of dd/mm/yyyy.  Can you share both the formatting in Excel, and the formatting of the cells in TM1 (Element attribute format).  We should be able to setup a very simple testcase to try and reproduce once we know these two things.

You are also welcome to send me an e-mail with the ticket number (stuart.king@ca.ibm.com).  I can touch base with support on these issues.


------------------------------
Stuart King
IBM Planning Analytics Offering Manager
------------------------------

Original Message:
Sent: Thu June 20, 2019 09:02 AM
From: Jesper Poulsen
Subject: Different websheet layout format in PAW and PAX

Have not had a response to this from IBM Support in months, so now I turn to the community and hope someone can explain this behavior we see.

I have an active form which was originally created on a local TM1 (10.2.2) server in Perspectives. We have now moved to a PA Cloud solution and we are experiencing some odd behavior with the active form. The layout or format of different cells/columns show up differently and we have tried to play around with most of the language settings on the user side without finding a good explanation.

If I open the active form from the RDP Perspective (which is in English) my date formatted cells show up as mm/dd/yyyy and my elements are shown with their alias (id and name).

If I open the same active form in PAX on my local pc then the date format reflects my local setting of dd/mm/yyyy but my elements are not showing the alias - only the id.

If I open the same active form in PAW (or TM1web - same result) then the date format is back to mm/dd/yyyy despite my local os and browser is set to Danish (which is dd/mm/yyyy) and the elements are shown with their alias (id and name).


What we want to have is an active form which will show us the elements with alias and the date format as it is setup up locally (dd/mm/yyyy) in both browser and PAX.

Any ideas?

------------------------------
Jesper Poulsen
------------------------------

#PlanningAnalyticswithWatson