TM1 Forum

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

SELECT NON EMPTY {TM1SubsetToSet([Product], "TEC_FAPMonthlyCompanyDetails_ADM_Standard Export")} * {{TM1SubsetToSet([Cost Center], "TEC_FAPMonthlyCompanyDetails_ADM_Standard Export")} ON 0 FROM [FAP] Doing it like above gives me a syntax error. Which is strange as the syntax sho...

Emixam wrote: ↑Thu Feb 17, 2022 9:30 pm 3. In Notepad++, Search->Find in Files.
Find What: File Name
Filters: *.pro*
Directory: TM1 data folder

Good add, thank you.

Write your mdx and then use the tm1py function execute_mdx_dataframe . If you need help with the mdx, check out mdxpy. I haven't used it personally, but it'll make writing mdx easier. Otherwise, take a stab at writing your mdx and post back here if you're having issues. I won't write it for you, but...

A couple methods come to mind: 1. look at the last modified date/time of the csv file and then search the tm1server.log file to see which TI process finished around that time 2. use the new processes.search_string_in_code function in TM1py 1.9.0 to look for the exact filename string in a TI process....

marko_p wrote: ↑Fri Dec 10, 2021 9:55 am I am using Postman, so my header key is CAMNamespace and value is base64 encoded username:password:namespace, so I guess it is not a problem.

Your header key should be "Authorization" and the value should be "CAMNamespace <base64 encoded username:password:namespace>"

Are you including "CAMNamespace" in your authorization header as a prefix to your username:password:namespace? per IBM, your authorization header should look as follows: CAMNamespace base64(<username>:<password>:<namespace>) or if you've already converted your <username>:<password>:<namesp...

...I feel bad for not thinking about this :mrgreen: ... There are many times in one's life to feel bad about something. Determining that a current method is suboptimal and seeking to better yourself by sharing your frustration and soliciting advice from an online community of users who may have exp...

My mistake PlanningDev, looks like I wasn't following the thread as closely as I led myself to believe.