Search found 757 matches

by gtonkin
Fri Sep 18, 2020 6:08 am
Forum: Enhancements
Topic: DBS should fail, hard!
Replies: 9
Views: 797

Re: DBS should fail, hard!

Thanks Alan - added my 2 cents worth too as we ran into this again this week. To mitigate this, as you and others have mentioned, you need to do all sorts of reads and checks to test if what you have sent actually got sent. The risk here is you now introduce macro code and other nonsense which is er...
by gtonkin
Wed Sep 16, 2020 7:12 pm
Forum: Enhancements
Topic: Transfer of data between servers
Replies: 8
Views: 769

Re: Transfer of data between servers

Just saw that too - no doubt it will be via the RestAPI but fine as long as it is native, easily configurable and lightning fast with error-handling etc. etc.
by gtonkin
Mon Sep 14, 2020 5:39 pm
Forum: Enhancements
Topic: MDX Object type for picklists
Replies: 5
Views: 522

Re: MDX Object type for picklists

Looks like this one has made the cut - from the looks of some of the others that have previously made the cut, the comments added by others may weigh in when the ideas are picked, not only the no. of votes. The comments may highlight other use cases and bolster the case for inclusion. That's my thou...
by gtonkin
Wed Aug 12, 2020 11:52 am
Forum: General
Topic: Genes, Excel and Dates
Replies: 2
Views: 228

Re: Genes, Excel and Dates

I saw that too and had a good chuckle.

Lies, damned lies and statistics!
by gtonkin
Fri Jul 31, 2020 11:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subnm index change
Replies: 6
Views: 325

Re: Subnm index change

And if the enhancement to be able to drive the picklist via MDX ever gets developed, cascading picklists will be even easier.
by gtonkin
Sat Jul 11, 2020 5:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculate minutes
Replies: 10
Views: 576

Re: Calculate minutes

This may work for you: [Minutes]=N: (SUBST(DB(<EndTime>),9,2)-SUBST(DB(<StartTime>),9,2))*60 + SUBST(DB(<EndTime>),11,2)-SUBST(DB(<StartTime>),11,2) Assuming you are not crossing days, months or years. If you plan to, you could add those and multiply days by 24*60 etc. etc. Hope it works for you.
by gtonkin
Sat Jul 04, 2020 6:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1py Use Case
Replies: 3
Views: 348

Re: TM1py Use Case

Have a look at some of Nick’s videos - opens up a world of possibilities...

https://www.youtube.com/channel/UCHXa4O ... HrLeIzw7Yg
by gtonkin
Fri Jul 03, 2020 1:59 pm
Forum: Enhancements
Topic: DBS should fail, hard!
Replies: 9
Views: 797

Re: DBS should fail, hard!

Sounds like it is borked.

Here's the link if anyone needs it:

+1
by gtonkin
Thu Jul 02, 2020 4:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SwapAlias in Dimension
Replies: 1
Views: 197

Re: SwapAlias in Dimension

I have found that you need to dirty the cube before restarting. Have not done this for a while and never on }Clients so YMMV.
by gtonkin
Thu Jul 02, 2020 10:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change of MDX security in 2.0.9 - Discussion
Replies: 18
Views: 2348

Re: Change of MDX security in 2.0.9 - Discussion

That will save a lot of everyone's time - thanks for posting Scrumthing
by gtonkin
Tue Jun 30, 2020 3:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: check if a parameter value is numeric
Replies: 9
Views: 2732

Re: check if a parameter value is numeric

Or you could use =ISNUMBER() assuming you are not using TM1 Web.
by gtonkin
Mon Jun 29, 2020 6:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LogOutput fails where AsciiOutput runs fine
Replies: 3
Views: 488

Re: LogOutput fails where AsciiOutput runs fine

Hi Wim,
Cannot test for you but you may need to escape the backslashes e.g. \\\\customer.local\\...
Or switch them to forward slashes e.g. //customer.local/...
by gtonkin
Tue Jun 23, 2020 1:14 pm
Forum: General
Topic: A little bit of help with world domination!!
Replies: 9
Views: 2271

Re: A little bit of help with world domination!!

Still not sure how Hernan got almost 300 Fakebook votes in the closing hours :shock: Auto-hot key, Temp-mail.org, Join Facebook, Vote, repeat?? Yours was a great entry and a super specc'ed machine. My wife commented on how clean it looked. Enjoy the endless hours you will spend on it! Curious as to ...
by gtonkin
Mon Jun 22, 2020 12:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there an easy way to convert a dynamic subset to static?
Replies: 15
Views: 6932

Re: Is there an easy way to convert a dynamic subset to static?

I have been doing mine like this for a while: IF(SubsetExists(sDim,sSubset)=0); SubsetCreate(sDim,sSubset); ENDIF; sMDX='TM1SUBSETALL( ['|sDim|'] )}, ['|sDim|']}'; SubsetMDXSet(sDim.Measures,sSubset,sMDX); SubsetMDXSet(sDim.Measures,sSubset,''); Create a blank subset if it does not already exist, ap...
by gtonkin
Sun Jun 21, 2020 6:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1py and python integration with TM1
Replies: 13
Views: 1686

Re: TM1py and python integration with TM1

Have a look at some of Nick’s videos, some really exciting possibilities open up!
by gtonkin
Sun Jun 21, 2020 4:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change of MDX security in 2.0.9 - Discussion
Replies: 18
Views: 2348

Re: Change of MDX security in 2.0.9 - Discussion

I like your thinking Wim - just trying to find the best way to report the findings.
Write back to the calling workbook or something else.
by gtonkin
Sun Jun 21, 2020 2:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change of MDX security in 2.0.9 - Discussion
Replies: 18
Views: 2348

Re: Change of MDX security in 2.0.9 - Discussion

This is indeed going to be fun, especially with some of those MDX statements located in Excel templates and reports!
Some lateral thinking will be needed too no doubt.

Thanks Mike and everyone else for the review and feedback on this.
by gtonkin
Sun Jun 21, 2020 8:37 am
Forum: General
Topic: A little bit of help with world domination!!
Replies: 9
Views: 2271

Re: A little bit of help with world domination!!

Nudged you to 60% on Twitter - cheering for you!
Image
by gtonkin
Thu Jun 18, 2020 6:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Some icons missing on set editor
Replies: 10
Views: 1057

Re: Some icons missing on set editor

Duly noted Lotsaram, thanks. One question: how is PAfE pronounced, is it like cafe but with a P? I think I'll stick with calling it PAX for now, but will owe the first person who hears me using PAfE a modestly priced beverage of their choosing whenever we have in-person conferences again. I would g...
by gtonkin
Wed Jun 17, 2020 2:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sending an email using PA on IBM Cloud
Replies: 2
Views: 398

Re: Sending an email using PA on IBM Cloud

Thanks Adam, have included a link to this thread from my PA readiness thread.
p.s. Thread may not be available to all users at this time.