PAW questions

Post Reply
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

PAW questions

Post by Wim Gielis »

Hello all,

We can create a process in PAW, and the editor shows coloured functions, arguments to functions, and more of that.
However, where can I indicate the data source of the process, like a subset or a text file for example ?

When a process creates a dimension, it seems that a Refresh of the objects is needed to see the new dimension. This is not needed in good old Architect. I prefer that approach.

When editing a dimension, can we do a "Paste as child" operation like in Architect ?

I am currently using a provisioned environment from IBM with PAW 2.0.28.

Thanks,

Wim
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: PAW questions

Post by Wim Gielis »

And what about the TI function in hierarchies as the variant of Dimsiz ? To count the number of elements in an hierarchy, or do I miss something ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
escape18in
Posts: 26
Joined: Tue Feb 03, 2015 10:22 am
OLAP Product: IBM Cognos BI
Version: 10.2
Excel Version: Excel 2010

Re: PAW questions

Post by escape18in »

Hi members,

i have downloaded and installed Planning Analytics 2.0 but i was unable to locate Planning analytics work space(PAW) in it. its looks like TM1 10.2 version for me with Architect,performance modeler and insight application.where i can locate PAW? is there any other software i need to install. Please help
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: PAW questions

Post by David Usherwood »

PAW is a separate SKU. Also, it requires Docker to run. The current version is supported under Docker for Windows (Server 2016) but I have not heard positive reports about it so you are better off installing on Linux (IBM push Red Hat but Ubuntu is fine). This can be virtualised. It is a new set of skills but don't be put off - it works well and delivers features which are well overdue. However, the developer and admin features which Wim has been grappling with seem to me to be quite a way from being stable and complete.
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: PAW questions

Post by Steve Rowe »

Wim, I encountered the DimSiz hole as well, was told that you can use DimSiz('dimname:hierarchyname') to get the correct value back, believe this works with many of the old style TI functions if you can't find the equivalent.

Not sure if this is formally supported though so I'd use the new functions if you can.
Technical Director
www.infocat.co.uk
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: PAW questions

Post by David Usherwood »

The current version is supported under Docker for Windows (Server 2016) but I have not heard positive reports about it so you are better off installing on Linux (IBM push Red Hat but Ubuntu is fine)
I have now heard from the InfoCat team that the latest release of PAW for Windows is stable and recommended for clients. Personally I rather like working with the Linux version but it does constitute a major barrier especially for mid-market customers and prospects.
codingCPA
Posts: 22
Joined: Sun Mar 12, 2017 1:41 am
OLAP Product: TM1
Version: Planning Analytics 2.0.21, PAW
Excel Version: Excel 2013
Location: Los Angeles, Atlanta

Re: PAW questions

Post by codingCPA »

I have had mixed results with the stability of docker for Windows. I know IBM has said that their build is stable, but I'm not sure that makes a wider comment on the overall deployments stability. In the end I've opted to run all of my workspace servers on Ubuntu Linux, and have had really great results.
Paul Segal
Community Contributor
Posts: 306
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

Re: PAW questions

Post by Paul Segal »

Wim,
I think data source has now been added to PAW in
2.0.29
, but I haven't tested it yet.
Paul
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: PAW questions

Post by Wim Gielis »

Thanks all !
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply