Search found 221 matches

by ascheevel
Thu Sep 15, 2022 3:56 pm
Forum: Useful code, tips and tricks
Topic: Available loggers for use in tm1s-log.properties
Replies: 5
Views: 16681

Re: Available loggers for use in tm1s-log.properties

Adding all available loggers here so I can reference in future when I inevitably forget where I saved my list to save me from needing to update the log properties and then bounce the service to regenerate the list. TM1.API TM1.API.Parameters TM1.API.Return TM1.API.Return.Error TM1.API.Return.Object ...
by ascheevel
Wed Sep 07, 2022 12:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Syntax for CellvalueN referencing a dimension with multiple hierarchies?
Replies: 6
Views: 464

Re: Syntax for CellvalueN referencing a dimension with multiple hierarchies?

I too have seen the message log errors you mention. Although it seems to work ok, it does get upset on the server side that there are too few arguments. Are you asking how to reference the alternate hierarchies from within the CellValueN function? You add them just like the other dimension arguments...
by ascheevel
Tue Sep 06, 2022 2:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell Snd-MailMessage Fail to Attach File
Replies: 16
Views: 741

Re: Powershell Snd-MailMessage Fail to Attach File

Great, thanks for confirming. Wanted to ensure it wasn't due to file lock issue by some other script above your ExeucteCommand.

Glad to hear you've got it working now.
by ascheevel
Tue Sep 06, 2022 2:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell Snd-MailMessage Fail to Attach File
Replies: 16
Views: 741

Re: Powershell Snd-MailMessage Fail to Attach File

kenship wrote: Tue Sep 06, 2022 1:57 pm The command has to be run in Epilog not Prolog. Not sure why because the working TI has been in Prolog all the time.
Were you doing something else in the prolog like generating the export file you were trying to attach to email?
by ascheevel
Tue Sep 06, 2022 1:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell Snd-MailMessage Fail to Attach File
Replies: 16
Views: 741

Re: Powershell Snd-MailMessage Fail to Attach File

I suppose I can test it in my local machine but then if works in local machine but not on TM1 server then what's does it mean? It rules out the obvious culprits. Briefly looking at your ps code, I don't see anything glaringly wrong. I normally don't construct powershell code right in a TI, preferri...
by ascheevel
Sat Sep 03, 2022 3:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell Snd-MailMessage Fail to Attach File
Replies: 16
Views: 741

Re: Powershell Snd-MailMessage Fail to Attach File

sAttachment = 'E:\System\ExtractFiles\Test.csv'; Regarding the file path, "E:\System\Data" is where the TM1 data is stored. Are you saying the file you're trying to attach and your tm1 data directory are in similar location on the E:? If not, have you confirmed your TM1 server can read/wr...
by ascheevel
Wed Aug 31, 2022 1:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transaction Log Duration
Replies: 4
Views: 308

Re: Transaction Log Duration

No parameter for transaction log retention. If you're only seeing 2 weeks of transaction logs, there must be a utility running that's deleting tm1s<datetimestamp>.log files older than a certain time. Theoretically, the transaction log could go as far back as you have saved tm1s log files. You could ...
by ascheevel
Wed Aug 03, 2022 3:36 pm
Forum: Useful code, tips and tricks
Topic: Quickly promote or copy a PAW book
Replies: 4
Views: 1074

Re: Quickly promote or copy a PAW book

Great stuff, thanks for sharing George. This must be a small product of the initiative to bring the cognos and and planning analytics teams closer together. Copying report specifications in report studio was a much appreciated feature.
by ascheevel
Mon Aug 01, 2022 4:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculation inconsistency after using a DB
Replies: 16
Views: 862

Re: Calculation inconsistency after using a DB

What is the value when you copy the unformatted value of the input cell? If the user says they inputted 4.77 and you're seeing something different, isn't this simply user-input error? Is the end user inputting at a zero level or a consolidation using TM1Web/PAX/PAW? If at a consolidation, it would k...
by ascheevel
Wed Jul 20, 2022 4:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX for All fiscal periods up to and including last month
Replies: 9
Views: 1190

Re: MDX for All fiscal periods up to and including last month

I was also trying something like this but can't get the second half to default to previous month...always says invalid mdx statement [fixed_asset_fiscalPeriod].[fixed_asset_fiscalPeriod].[2011.12] : FILTER(TM1SUBSETALL([fixed_asset_fiscalPeriod]) , [fixed_asset_fiscalPeriod].[NextPeriod] = [CONTROL...
by ascheevel
Tue Jul 19, 2022 5:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX for All fiscal periods up to and including last month
Replies: 9
Views: 1190

Re: MDX for All fiscal periods up to and including last month

I'll add that you can also use the Range operator if the element indexes are ordered based on calendar date. In it's simplest form, it could look like this {[fiscal period].[Jan-20] : [fiscal period].[Jun-22]} Your requirement that the the latest period in the subset should be the prior month of cur...
by ascheevel
Tue Jul 19, 2022 5:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX for All fiscal periods up to and including last month
Replies: 9
Views: 1190

Re: MDX for All fiscal periods up to and including last month

One way that keeps the MDX simple is to leverage an attribute on your fiscal period dim to specify when a given month is in the past. You'd then apply a Filter statement in the MDX to select only completed months. Assuming your dim is called "fiscal period" and you have an attribute "...
by ascheevel
Thu Jul 14, 2022 6:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hide TM1 Servers in Architect/Perspectives/PAW/PAX
Replies: 4
Views: 445

Re: Hide TM1 Servers in Architect/Perspectives/PAW/PAX

I forget in what release it became available, but you can definitely hide servers in PAX. The item in the PAX options is "Set Hidden Servers".
by ascheevel
Wed Jun 22, 2022 1:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Modify default TM1web layout
Replies: 8
Views: 1009

Re: Modify default TM1web layout

Short of direct editing the source files in the install location that would then get overwritten any time you upgrade, I'm not aware of how to do this. I guess you could create a custom browser extension that dynamically updates the html of the page for all users. You could even build your own custo...
by ascheevel
Thu May 12, 2022 2:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE API: RefreshSheet
Replies: 18
Views: 1520

Re: PAfE API: RefreshSheet

I have a few questions on the VBA code if I may. me [well aware of Wim's excel prowess]: this is gonna hurt I see a loop to delete cells. Isn't it just Range("K2").ClearContents ? I guess that K2 has the formula (TM1ELLIST) that spills down to a number of cells below K2. The first loop is...
by ascheevel
Wed May 11, 2022 8:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE API: RefreshSheet
Replies: 18
Views: 1520

Re: PAfE API: RefreshSheet

I'm curious if there is something like: Reporting.QuickReports.Get(qrIDNumber).Refresh There is, but it's not well documented in the PAX API documentation. The below code will refresh whichever current report the cell "B2" finds itself in. You could of course use named ranges, ActiveCell,...
by ascheevel
Wed May 11, 2022 4:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE API to open a set editor
Replies: 5
Views: 508

Re: PAfE API to open a set editor

Did you see gtonkin's post a few weeks ago with a link to a blog they wrote about getting started with the rest api in vba? The MDX was going to be piped into a TM1ELLIST function dropped into a hidden worksheet to return a list… but I could never figure out how to get PAfE to execute/calculate that...
by ascheevel
Wed May 11, 2022 1:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE API to open a set editor
Replies: 5
Views: 508

Re: PAfE API to open a set editor

I don't think this is a preferred option, but the set editor is an available widget in the PAW api . You can render the set editor within a userform in excel. This method would require the modifying & saving a public subset and then calling a refresh of the list pointed to that subset after the ...
by ascheevel
Tue Apr 12, 2022 12:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automated Server Restart - IBM Cloud
Replies: 2
Views: 421

Re: Automated Server Restart - IBM Cloud

Haven't tried that on Cloud, I just submitted a P4 ticket noting which server to restart, the interval, and they set it up on their end.