Search found 825 matches

by gtonkin
Fri Apr 23, 2021 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube last data pull
Replies: 12
Views: 186

Re: Cube last data pull

You could try using the TM1 Loggers e.g. #--VIEWARRAY log4j.logger.TM1.ViewArray=DEBUG, VIEWARRAY log4j.appender.VIEWARRAY=org.apache.log4j.SharedMemoryAppender log4j.appender.VIEWARRAY.MemorySize=5 MB log4j.appender.VIEWARRAY.File=TM1Views.txt log4j.appender.VIEWARRAY.MaxFileSize=5 MB log4j.appende...
by gtonkin
Thu Apr 22, 2021 8:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monthly Poll 202105 - What's your security mode poison?
Replies: 3
Views: 74

Re: Monthly Poll 202105 - What's your security mode poison?

More options than you can shake a stick at! For me as a consultant, the answer is "It depends..." For offsite development, we use mode 1 or 2. Mostly in production we use mode 3 as clients integrate with AD. Due to the price point of PA, only larger clients purchase PA and they are the clients who h...
by gtonkin
Fri Apr 16, 2021 5:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX: Sorting on an attribute
Replies: 2
Views: 81

Re: MDX: Sorting on an attribute

Try change ASC to BASC

Order MDX
"...If BASC or BDESC is specified, the Order function arranges members in the set without regard to the hierarchy...."
by gtonkin
Fri Apr 16, 2021 3:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1s.cfg my own parameters
Replies: 13
Views: 283

Re: Tm1s.cfg my own parameters

tomok wrote:
Fri Apr 16, 2021 3:37 pm
...Here is the code I use in the Data tab of a process where I do that...
Start up chore to run and update?
by gtonkin
Mon Apr 12, 2021 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOUTPUT does not create output file
Replies: 18
Views: 1343

Re: ASCIIOUTPUT does not create output file

Another thing I like to do when I have a view I am not 100% certain of is to right-click, then Export as text Data. This lets you confirm the sets/members on each dimension and if you run the export, you should end up with data in a file per the view. Per the previous posts though, you will need to ...
by gtonkin
Mon Mar 29, 2021 3:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automatic commit of data entry in TM1 Web sheets via PAW
Replies: 4
Views: 627

Re: Automatic commit of data entry in TM1 Web sheets via PAW

Going for a wild swing here as I have not seen anything either but what comes to mind is the option to Commit immediately in the Manage Features on PAW. Possibly only for the cube viewer but cannot recall exactly.
Not in a position to get the exact name or test but HTH (or someone else can).
by gtonkin
Fri Mar 19, 2021 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE: Refreshing Behaviour Issue
Replies: 4
Views: 894

Re: PAfE: Refreshing Behaviour Issue

Have you got any volatile formulas in your workbook e.g. OFFSET?

Also found it critical to use the Wait() function when triggering any refreshes via VBA to ensure that the refresh has actually completed before moving on.
by gtonkin
Tue Mar 16, 2021 5:46 am
Forum: Useful code, tips and tricks
Topic: PAW Explorations after cube dimensionality changes
Replies: 3
Views: 450

PAW Explorations after cube dimensionality changes

I recently had to "update" a few cubes with extra dimensions to meet some new business requirements. Anyone that has done this knows that it is a complete rebuild, with exports, updating rules, feeders, views, templates etc. etc. I was able to update all the views by editing the .vue files and addin...
by gtonkin
Mon Mar 15, 2021 5:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error 500 after trying to download a table from PAW to excel
Replies: 1
Views: 402

Re: Error 500 after trying to download a table from PAW to excel

Tried the good old Ctrl + F5 to clear the cache?
Possibly clear cookies too.
by gtonkin
Fri Mar 12, 2021 8:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow MDX subset creation in a TI
Replies: 5
Views: 476

Re: Slow MDX subset creation in a TI

Late here so a completely random idea but have you tried specifying the dimension name as the fourth argument in the SubsetCreatebyMDX?
by gtonkin
Thu Mar 11, 2021 1:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX question
Replies: 10
Views: 735

Re: MDX question

Have to agree with Declan - great code Ty!

@Alan - a like button would be great in these situations :)
by gtonkin
Wed Mar 10, 2021 3:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Comments and threaded conversations in dashboards
Replies: 4
Views: 496

Re: Comments and threaded conversations in dashboards

Would you not just need to add string measures to your measures dimension to store these items? p.s. Depending on your cube/model there are best practice recommendations to keep numerics in one cube and strings in another. Saying this, would be tricky to present in a grid as a dashboard though in PA...
by gtonkin
Sun Mar 07, 2021 9:41 am
Forum: General
Topic: About Forum Ranks And Voting
Replies: 31
Views: 55004

Re: About Forum Ranks And Voting

Congratulations indeed guys!

Thanks for all the valuable contributions and making this site the “go-to” site for TM1/PA.
by gtonkin
Mon Mar 01, 2021 7:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW installation error unable to copy docker images final step of installation
Replies: 9
Views: 997

Re: PAW installation error unable to copy docker images final step of installation

I have had similar issues on older versions of PAW and my notes have: To clear out all the Windows filter and other docker folders: Stop PAW then stop the Docker Service. Once done, run the below command. Download: https://github.com/jhowardmsft/docker-ci-zap PS> docker-ci-zap.exe -folder "c:\Progra...
by gtonkin
Tue Feb 23, 2021 5:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Migrate ActiveForm from Perspectives to PAfE / PAX
Replies: 5
Views: 325

Re: Migrate ActiveForm from Perspectives to PAfE / PAX

HI Mark, There were one or two minor changes but have been able to get my old Active forms working in PAX with a few reviews and updates. Where I have a TM1RPTROW formula, I try and reference a subset or if MDX, put the MDX in a cell to make it easy to view and update. If you have used the set edito...
by gtonkin
Fri Feb 12, 2021 3:16 pm
Forum: Enhancements
Topic: Shared Sandboxing
Replies: 3
Views: 568

Re: Shared Sandboxing

HI Garry, based on the AMA sessions, I am cautiously optimistic on this materialising "soon". What I have done to emulate this is to have multiple active Scenarios - Rolling Forecast plus Active 1,2 etc. The Active scenarios are flagged to be Live or Static and rules look at this. I also have system...
by gtonkin
Tue Feb 09, 2021 5:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule/Feeder using attribute not calculating/working
Replies: 9
Views: 548

Re: Rule/Feeder using attribute not calculating/working

The right side looks to be the problem at a very quick glance. I would generally use the DB reference and put any IF statements within the DB to resolve the Cube name when valid and blank when not valid, so as not to feed. Something like: [ 'Base', 'COMMON Profit and Loss':'EBITDA' ] => DB( IF ( DB ...
by gtonkin
Sat Feb 06, 2021 6:55 am
Forum: Enhancements
Topic: PickList to show Alias but store Element Name
Replies: 15
Views: 17362

Re: PickList to show Alias but store Element Name

ppniederbracht wrote:
Fri Feb 05, 2021 9:37 pm
Try: subset:DIMENSION:SUBSET<StoreAlias=F> as picklist definition.
Thanks Paul Peter - great tip!!

Does not look like there are any other modifiers for the PicklistParser.
by gtonkin
Tue Feb 02, 2021 1:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New security groups in TM1 on cloud
Replies: 8
Views: 732

Re: New security groups in TM1 on cloud

HI Wim,

Burnstripe is correct, you can click on the "meatballs" menu next to Cubes, Edit Settings.
The widget added to the canvas will have Cube Security on columns and you will see a plus sign (Create user group) on the right below the security shield, next to the bin.