Search found 845 matches

by gtonkin
Thu Jun 10, 2021 6:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mdx to get 2 years date
Replies: 5
Views: 984

Re: Mdx to get 2 years date

I'll throw another option into the mix - based on a Daily period dimension but concepts should still apply. I have a subset that is updated via TI with the current business day each night. The Period in the subset is used as the basis from which to derive the last 32 days. The StringToMember bit wit...
by gtonkin
Tue Jun 08, 2021 3:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule set value to zero
Replies: 7
Views: 1237

Re: Rule set value to zero

I tend to use the Global Security Overlays to block things that are not Group specific and cell security to open things that are Group specific and where input is expected. If for example I do not want people to capture outside of my planning months on my rolling forecast scenario, I use the global ...
by gtonkin
Sun Jun 06, 2021 9:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: view zeroout - subset all n
Replies: 9
Views: 1619

Re: view zeroout - subset all n

... How do I know if my variables order do not change when i change my source view in prolog. Which should be my initial source view. ... Maybe to elaborate on what Wim said - NEVER use a view that you created by opening and saving the view - you cannot guarantee that the variable order will be the...
by gtonkin
Fri Jun 04, 2021 8:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with CreateHierarchyByAttribute
Replies: 6
Views: 2618

Re: Problem with CreateHierarchyByAttribute

HI Ty, Your last line about suspecting an alias being the issue brings an issue I had earlier to mind. A dynamic report was returning #Values when the TM1RPTROW had the Alias, Description on. Remove it and values were retrieved as expected. Copying the members with the alias on and pasting into the ...
by gtonkin
Sat May 29, 2021 7:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Performance
Replies: 9
Views: 1517

Re: TM1 Performance

Going to point you to these articles for a better understanding:
What exactly is cube optimization
Optimising dimension order in cubes
by gtonkin
Fri May 28, 2021 3:52 pm
Forum: Enhancements
Topic: RFE 73333-Copy visible members from a cube view
Replies: 8
Views: 21264

Re: RFE 73333-Copy visible members from a cube view

Whoohoo - PAW - Copy Member from Cube View has changed status to: Future consideration Definitely going to prematurely celebrate this one!! Lost count of the number of times I needed to do this recently from PAW and had to export the view, open Excel and copy the members then paste into another view.
by gtonkin
Fri May 28, 2021 8:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Performance
Replies: 9
Views: 1517

Re: TM1 Performance

... Once you have large datasets in TM1 the dimension order in the cube becomes crictical and you should reorder the dimensions off the right-click menu against the cube in perspectives. ... Please do any re-ordering in Perspectives - PAW lets you reorder but does not give you any indication of exp...
by gtonkin
Fri May 28, 2021 7:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Numeric to string
Replies: 2
Views: 740

Re: Numeric to string

I would personally rather do a cast or convert and configure my TI variables for their purpose. Would not leave anything to chance.
by gtonkin
Fri May 28, 2021 7:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Performance
Replies: 9
Views: 1517

Re: TM1 Performance

Think you will get vague answers as without being able to see the cube, difficult to say. 25 million rows does not seem particularly big at all. Have you run performance monitor to get an idea of where the memory is going? Input data, calculations etc? If you have string fields in your measures, thi...
by gtonkin
Tue May 18, 2021 4:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: UseSSL
Replies: 5
Views: 1437

Re: UseSSL

Hi Wim, Seems fine on my side - What version are you trying on? TM1 Build Number: 11.8.00500.12 (possibly PA 2.0.9.6) 33244 [] INFO 2021-05-18 15:53:13.521 TM1.Server Logging Directory: c:\tm1 logs\XYZ 33244 [] INFO 2021-05-18 15:53:13.521 TM1.Server Configuration Directory: c:\tm1 data\XYZ 33244 []...
by gtonkin
Thu May 13, 2021 3:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View in cube does not exist error
Replies: 8
Views: 2351

Re: View in cube does not exist error

Random thought but have you tested if you have two dimensions on the rows in your default view then try move V_Verze to the Titles?
PAW explorations do not show data if you do not have dimensions on either rows or columns - may be similar.
by gtonkin
Tue May 11, 2021 5:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1S Logging Properties - Capturing form publishing
Replies: 2
Views: 1151

Re: TM1S Logging Properties - Capturing form publishing

Not sure what kind of activity you are trying to log but if it is TM1 related, you may try: log4j.logger.TM1.Folder=DEBUG, Folder log4j.appender.Folder=org.apache.log4j.SharedMemoryAppender log4j.appender.Folder.MemorySize=5 MB log4j.appender.Folder.File=TM1_Folder.log log4j.appender.Folder.MaxFileS...
by gtonkin
Sat May 08, 2021 5:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC Read Error
Replies: 5
Views: 2139

Re: ODBC Read Error

Hi Jim, have you configured a logger for TM1.SQLAPI that is logging the read error? Not sure from your post.
If not, may be worthwhile configuring it - very useful detail when things go wrong.
by gtonkin
Mon May 03, 2021 8:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleting the Admin account
Replies: 6
Views: 2003

Re: Deleting the Admin account

Then the auditors are quite frankly idiots... Cannot disagree with you here. Complete lunacy as the account is protected with a long random generated password in case mode 1 is ever used. Had some auditors a few years back come with a ream of findings on another Unix system I ran at the time, telli...
by gtonkin
Sat May 01, 2021 2:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prior Year and Next Year in Rules: What is Faster?
Replies: 9
Views: 2398

Re: Prior Year and Next Year in Rules: What is Faster?

HI Adam, I use the attribute approach - find it easier for others to follow. Cannot comment on the speed of one vs the other. I also like having picklists attached to the attributes so that the values are aligned to my meta data and I do not have calculation running on something like 2025 where 2025...
by gtonkin
Sat May 01, 2021 4:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleting the Admin account
Replies: 6
Views: 2003

Re: Deleting the Admin account

Thanks for link and the feedback guys. Will look at how to actually delete Admin as we have not tried yet.

Would be fun to have the auditors around and try it in Production to see the fireworks show ensue!
by gtonkin
Fri Apr 30, 2021 3:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleting the Admin account
Replies: 6
Views: 2003

Deleting the Admin account

HI, May seem like a silly question but has anyone deleted the Admin account and had any unintended consequences. Auditors raised a finding that the default user is "available" and want it removed. Using Security Mode 3 with AD so would give at least one named user Admin rights but just checking if a...
by gtonkin
Thu Apr 29, 2021 2:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to include aliases in result
Replies: 11
Views: 3664

Re: MDX to include aliases in result

Hi Andy, cannot explain how it would fit in, was just a wild idea of referencing the alias using the properties. Have not done enough cube view selections to be of more help. The only other thing that comes to mind is with PAW 2.0.63 there is an MDX button for the exploration - maybe if you can crea...
by gtonkin
Wed Apr 28, 2021 11:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to include aliases in result
Replies: 11
Views: 3664

Re: MDX to include aliases in result

Possibly off on a tangent but have you tried using the member properties in the query - something like the syntax below:
[Customer].CurrentMember.Properties("Country")
by gtonkin
Wed Apr 28, 2021 10:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Setting default parameter in PAW based on subset
Replies: 5
Views: 1774

Re: Setting default parameter in PAW based on subset

Or why not test if the Version has been left blank and then use the first element from the subset? I have had the same issue on PAW as the default will let you select from the subset, list etc. once configured but is not dynamic i.e. would be ideal to put 1 into the default to read element at index ...