Page 1 of 1
Is it possible to open a PAW report in PAX?
Posted: Wed May 15, 2024 3:59 pm
by Paul-TM1
Hi,
Can someone let us know if PAW reports can be opened in PAX? I know we can open PAX reports published to PAW and can be opened.
Thanks,
Paul.
Re: Is it possible to open a PAW report in PAX?
Posted: Wed May 15, 2024 4:31 pm
by Wim Gielis
No. What is your use case ?
Re: Is it possible to open a PAW report in PAX?
Posted: Wed May 15, 2024 5:55 pm
by Paul-TM1
Hi Wim,
Thanks for responding.
We have a few PAW books created in PAW and want to open them from PAX. The reports have attributes displaying along with measures.
Thanks,
Paul.
Re: Is it possible to open a PAW report in PAX?
Posted: Wed May 15, 2024 6:56 pm
by gtonkin
You could conceivably take the MDX from the exploration widgets and reuse within PAfE but that is likely all.
Attributes may need to be added separately or derived as calculated members, depending on what you were doing.
No action buttons, selectors etc. You would need to redo in PAfE.
These
articles may help...
Re: Is it possible to open a PAW report in PAX?
Posted: Thu May 16, 2024 7:25 am
by lotsaram
Paul-TM1 wrote: ↑Wed May 15, 2024 5:55 pm
We have a few PAW books created in PAW and want to open them from PAX. The reports have attributes displaying along with measures.
It's a completely different UI. Sure you could recreate a PAW book in Excel with the same content and layout but you would be
recreating it.
You could have a hyperlink in Excel to open PAW, but I believe as of now PAW doesn't yet have a URL API which could navigate the user to the exact tab in the book and set all the title element context to be the same.
Re: Is it possible to open a PAW report in PAX?
Posted: Thu May 16, 2024 2:11 pm
by Adam
Paul-TM1 wrote: ↑Wed May 15, 2024 5:55 pmThe reports have attributes displaying along with measures.
Is what you're actually looking for displaying multiple attributes next to element in PAFE? Unfortunately MDX-based views (i.e. Quick Report, Exploration) don't support that. It is quite annoying because you can create a cube view in PAW with Attributes and then export to Quick Report and the Attributes aren't there or the view errors out.
Re: Is it possible to open a PAW report in PAX?
Posted: Tue May 21, 2024 12:44 am
by JohnO
Paul-TM1 wrote: ↑Wed May 15, 2024 3:59 pm
Hi,
Can someone let us know if PAW reports can be opened in PAX? I know we can open PAX reports published to PAW and can be opened.
Thanks,
Paul.
You may mean opening PAW "views" in PAfE. A PAW view being something that contains more than a MDX statement. One or more PAW views can reside on a tab in a PAW book. A PAW view can be saved separately using the save button that appears when you click on the view. You can also "save to server" which means saving a MDX view to the TM1 server.
https://www.ibm.com/docs/en/planning-an ... tent-store
In order to do this you need to change a setting in the PAW.ps1 script in the config subdirectory
$env:ENABLE_VIEW_EXCHANGE="true"
I actually tried to do this last week but it has not worked for me, but our environment may not be correct.
I have used this option elsewhere and Stuart King actually made a comment about it in the last AMA.