Search found 214 matches
- 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.
- 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...
- Fri Jul 29, 2022 1:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Extraction of TM1 DATA TO SQL DW
- Replies: 3
- Views: 507
Re: Extraction of TM1 DATA TO SQL DW
You can update an ODBC datasource from TM1.
- 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...
- 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...
- 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 "...
- 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".
- 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...
- 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...
- 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,...
- 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...
- 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 ...
- 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.
- 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...
- 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.
- 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...
- 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"
edit: removed repetitive "expected behavior"
- 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...
- 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...
- 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