List of Contributions

George Tonkin

MCI Consultants

Contact Details

MCI Consultants

My Content

1 to 20 of 50+ total
Posted By George Tonkin Fri March 22, 2024 03:00 AM
Found In Egroup: Planning Analytics
\ view thread
Hi Ted, yes, the white space formatting of the query text is essentially what I would like to be able to keep intact after committing the code to the server. There are really two aspects to the request: 1) Keep the format of the hand-crafted MDX code as written/pasted etc. 2) When viewing system ...
Posted By George Tonkin Thu March 21, 2024 02:05 PM
Found In Egroup: Planning Analytics
\ view thread
Thank you very much Ted - will do some reading. Leaving this link here for others: https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=reports-common-view-specification ------------------------------ George Tonkin Business Partner MCI Consultants Johannesburg -------------------------- ...
Posted By George Tonkin Thu March 21, 2024 12:09 PM
Found In Egroup: Planning Analytics
\ view thread
@Ted Phillips - Thanks for picking up my question on MDX formatting. Please could you share a link or point me to the CVS related information you made reference to. Thank you. ------------------------------ George Tonkin Business Partner MCI Consultants Johannesburg ----------------------------- ...
Posted By George Tonkin Thu March 21, 2024 04:15 AM
Found In Egroup: Planning Analytics
\ view thread
Hi Asgeir, 100% agree - IMO, there should be two layers to MDX, just like in Perspectives, a code layer (RUX) and a presentation layer (BLB) Not saying I want two copies in files but rather that when opening MDX, it should either present the MDX you saved, in the same format or if in the case of MDX ...
Posted By George Tonkin Mon March 11, 2024 02:09 AM
Found In Group: Planning Analytics Blogs
Part 3 - Aggregate Calculated Members in MDX In Part 2 , we introduced Calculated Members and looked the syntax needed to add these into our MDX code. We focused on arithmetic calculations that derived new members based on an existing sales measure. Our Calculated Members VAT and Sales Revenue incl ...
Posted By George Tonkin Wed March 06, 2024 03:40 AM
Found In Egroup: Planning Analytics
\ view thread
Thanks for closing the loop on this. I guess most users would not have had this issue as the default is T, like you mention. What I am trying to work out is what would the case be where ViewConsolidationOptimization needs to be set to F? ------------------------------ George Tonkin Business Partner ...
Posted By George Tonkin Tue March 05, 2024 04:38 AM
Found In Egroup: Planning Analytics
\ view thread
Thanks for this Chris. Will definitely need to ask some more pointed questions. ------------------------------ George Tonkin Business Partner MCI Consultants Johannesburg ------------------------------
Posted By George Tonkin Tue March 05, 2024 01:42 AM
Found In Egroup: Planning Analytics
\ view thread
HI Scott, Thank you for the feedback. As far as I understood from IBM they join the entire domain to federate the client's users on their corporate IDs. Are your users using SSO when logging in or an IBM ID (username) and password? ------------------------------ George Tonkin Business Partner ...
Posted By George Tonkin Sun March 03, 2024 03:50 AM
Found In Egroup: Planning Analytics
\ view thread
HI Wim, level005 is probably your leaf level. My gut feel is that due to ragged rollups being possible, a Leaf member could really exist at any level. What may make more sense is popping up the options like in the set editor when right-clicking the header: and when right-clicking a member, maybe ...
Posted By George Tonkin Thu February 29, 2024 12:51 PM
Found In Egroup: Planning Analytics
\ view thread
Thanks for the reply Shahhere. We do something similar currently for the on-premises models currently running. There is also the IsDisabled flag which could be set. I think the main issue here still is the fact that the entire domain is federated which is likely to impact other users in other ...
Posted By George Tonkin Thu February 29, 2024 06:30 AM
Found In Egroup: Planning Analytics
\ view thread
Thanks for the detailed response Paul, appreciate it! The management and risk mitigation through managing access through groups etc. on the domain is very useful and was something we had discussed. Definitely easier than requiring a two step approach to removing someone when they leave/transfer as ...
Posted By George Tonkin Wed February 28, 2024 04:45 AM
Found In Egroup: Planning Analytics
\ view thread
HI Herman, seems like I gave you the incorrect sequence of keys above - the first one should have been Alt+Shift+F9 Could you see if that helps the user if the workstation switch or "problematic" user on a working PC does not work out for you? ------------------------------ George Tonkin Business ...
Posted By George Tonkin Wed February 28, 2024 04:39 AM
Found In Egroup: Planning Analytics
\ view thread
Hoping that someone who has gone through a similar migration can share some insights. We have a banking client who has been using TM1 on premises and is migrating to PAoC. We are stuck with the clients InfoSec team as we cannot simply enable federation as this does the entire domain/all users. ...
Posted By George Tonkin Mon February 26, 2024 09:34 AM
Found In Egroup: Planning Analytics
\ view thread
Have you tried the magic PAfE Keys? Ctrl + Shift + F9 or Ctrl + Shift + Alt + F9 - this seems to clear cache etc. and was mentioned by Ted on an AMA ------------------------------ George Tonkin Business Partner MCI Consultants Johannesburg ------------------------------
Posted By George Tonkin Mon February 26, 2024 09:17 AM
Found In Egroup: Planning Analytics
\ view thread
Hi Herman, #NUM! could also be down to security where the user does not have permissions to the cube, elements etc. ------------------------------ George Tonkin Business Partner MCI Consultants Johannesburg ------------------------------
Posted By George Tonkin Mon February 26, 2024 09:13 AM
Found In Egroup: Planning Analytics
\ view thread
HI Svetlana, Running a poll to see what other TM1 developers think. The obvious choice is neither 2 or 4 but an actual tab stop Char(9) Any reason why it cannot be the standard ASCII Tab character?
Posted By George Tonkin Mon February 26, 2024 04:27 AM
Found In Egroup: Planning Analytics
\ view thread
This feels like a hack but traditionally we have always edited c:\windows\system32\drivers\etc\hosts on the TM1 server and added an alias on the loopback address i.e. # localhost name resolution is handled within DNS itself. # 127.0.0.1 localhost # ::1 localhost 127.0.0.1 localhost TM1Server May work ...
Posted By George Tonkin Sun February 25, 2024 11:02 AM
Found In Egroup: Planning Analytics
\ view thread
Thanks for the update on what behaviour to expect in the future. One consideration that may need to be given is to existing code and how tabs will be updated from 2 to 4 spaces for example to align existing TI and Rules with the new behaviour. ------------------------------ George Tonkin Business ...
Posted By George Tonkin Sun February 25, 2024 08:59 AM
Found In Group: Planning Analytics Blogs
Using Calculated Members in MDX In Part 1 of this series we looked at some fundamentals on creating MDX views. In this next part, we introduce calculated members and give some basic examples of how to define them and what they can be used for. What are Calculated Members? Calculated Members ...
Posted By George Tonkin Sat February 24, 2024 08:20 AM
Found In Egroup: Planning Analytics
\ view thread
Closing the loop on this one. Can confirm that the Tab key in PAW 2.0.93 behaves as it used to pre PAW 2.0.92 Tab indents, Shift+Tab outdents, Tab on the auto-complete/intellisense selects the proposed items and inserts it into your code. This behaviour is consistent in TI and Rules. What is inconsistent ...