Search found 214 matches

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

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

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

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

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

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

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

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

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

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

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

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

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.
by ascheevel
Mon Apr 11, 2022 4:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DIMIX check for element in a Hierarchy enabled dimension
Replies: 4
Views: 593

Re: DIMIX check for element in a Hierarchy enabled dimension

The original functions can be used against hierarchies, but not specifying a hierarchy doesn't magically make the function a super function that can check all hierarchies. It's my understanding that if you don't make the function hierarchy specific, the function will generally apply to the main hier...
by ascheevel
Thu Mar 31, 2022 4:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to zero out the data from elements of TM1 alternate hierarchy
Replies: 2
Views: 513

Re: How to zero out the data from elements of TM1 alternate hierarchy

Burnstripe has got it, I utilized mdx view filtered on alternate hierarchies with ViewZeroOut. Feature has been available since 2.0.9 December 2019.
by ascheevel
Wed Mar 23, 2022 6:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Order in an MDX cube view as datasource
Replies: 21
Views: 63452

Re: Dimension Order in an MDX cube view as datasource

I don't love it, but if it stays consistent I can work with it. I'm bothered by the need to remap variables on existing TIs with mdx views, but that's a one time effort. I'm bothered that IBM's fix documentation simply said it was fixed as of 2.0.9.10 without clarifying what the new expected behavio...
by ascheevel
Wed Mar 23, 2022 1:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Order in an MDX cube view as datasource
Replies: 21
Views: 63452

Re: Dimension Order in an MDX cube view as datasource

I got confirmation from IBM that the variable order matching the order of dims in the query is expected behavior and not necessarily the TABDIM order as of 2.0.9.10.

edit: removed repetitive "expected behavior"
by ascheevel
Fri Mar 18, 2022 7:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Order in an MDX cube view as datasource
Replies: 21
Views: 63452

Re: Dimension Order in an MDX cube view as datasource

Was doing a bit of testing in 2.0.9.11 today and see the dim order for an mdx view as data source for TI will be the order specified in mdx statement. Seems we were expecting the order to be the TABDIM order. Funny thing is that on old 2.0.9.1 version (not 2.0.9.10), as long as I wasn't employing mu...
by ascheevel
Fri Feb 25, 2022 5:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rest API - Powershell
Replies: 6
Views: 955

Re: Rest API - Powershell

I modified your code below with following updates: *added Content-Type to header (not necessary, but reduces clutter in your rest call *reconfigured $Parameters variable as a JSON object *added $Parameters to "-Body" argument of rest call (this was a specified requirement in my initial res...
by ascheevel
Fri Feb 25, 2022 2:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rest API - Powershell
Replies: 6
Views: 955

Re: Rest API - Powershell

Parameters should be specified as a json object passed to the -body argument of the Invoke-RestMethod POST. { "Parameters": [{"Name":"pYear", "Value":"2022"}, {"Name":"pMonth", "Value":"Feb"}] } edit: grammar