TM1 Forum

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.

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...

You can update an ODBC datasource from TM1.

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...

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...

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 "...

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".

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...

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...

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,...

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...

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 ...

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.

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...

Burnstripe has got it, I utilized mdx view filtered on alternate hierarchies with ViewZeroOut. Feature has been available since 2.0.9 December 2019.

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...

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"

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...

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...

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