Search found 753 matches

by gtonkin
Fri Jul 31, 2020 11:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subnm index change
Replies: 6
Views: 188

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: 324

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: 224

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: 6
Views: 363

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: 111

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: 1740

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: 2478

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: 374

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: 851

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: 6574

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: 1360

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: 1740

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: 1740

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: 851

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: 841

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: 306

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.
by gtonkin
Mon Jun 15, 2020 5:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBCOutput Insertion to HANA Performance
Replies: 4
Views: 503

Re: ODBCOutput Insertion to HANA Performance

Long time Garry! Have you tried batching multiple insert statements rather than just the values? e.g. Insert into TM1FCE ([Version], [Source], [Period], [Country], [ProfitCentre], [CostCentre], [Currency], [Account], [Value] ) Values('blah','blah','blah','blah','blah','blah','blah','blah','882.09');...
by gtonkin
Wed Jun 10, 2020 12:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Age Calculation based on DOB
Replies: 18
Views: 3931

Re: Age Calculation based on DOB

I do something different. I basically treat months and days as decimals on the year and then do some subtraction and rounding to get the age. ['Age']=N: INT( (NUMBR(SUBST(TODAY(1),1,4))+ NUMBR(SUBST(TODAY(1),6,2))\12+ NUMBR(SUBST(TODAY(1),9,2))\365.25) - (NUMBR(SUBST(DB('Employee',!Employees,'DOB'),...
by gtonkin
Tue Jun 09, 2020 4:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loss of Whole Data Directory
Replies: 13
Views: 3766

Re: Loss of Whole Data Directory

Jim, did you ever get a resolution or a better understanding of why you got the message? We also recently received a similar message to yours: 19880 [284a4] ERROR 2020-06-09 04:48:54.599 TM1.Server.Network net_SetReadBufferAt: Attempted to set position past received network data size. This message s...
by gtonkin
Sun May 10, 2020 11:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server registering with Admin server
Replies: 13
Views: 1453

Re: TM1 server registering with Admin server

Anything is the event viewer during the old time window?
Any new scheduled tasks running, updates being applied, AV scans?