Search found 751 matches

by gtonkin
Sat Jul 04, 2020 6:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1py Use Case
Replies: 3
Views: 101

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: 5
Views: 103

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

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: 14
Views: 957

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

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

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: 7
Views: 469

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

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

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: 14
Views: 957

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: 14
Views: 957

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: 7
Views: 469

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

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

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: 1
Views: 136

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

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

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

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?
by gtonkin
Fri May 08, 2020 3:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cell Security vs Global Security Overlays
Replies: 0
Views: 409

Cell Security vs Global Security Overlays

I am looking at possibly changing how we apply locking to some of our planning models. In a typical model we have Scenarios which may be Actuals, Rolling Forecast (live planning) or other static versions. Actuals would be locked for users (Groups based) and possibly open for Custodians (Group based)...
by gtonkin
Fri May 08, 2020 3:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Insert a Subset into a Subset through TI
Replies: 4
Views: 231

Re: Insert a Subset into a Subset through TI

To the best of my knowledge, going with a No as the Insert subset creates the pseudo element with the Subset name as a consolidation holding the members of the inserted subset. If you use TI, you will need to use MDX and to my knowledge you will only be able to add members, not create these user def...