TM1 Forum

Steve Rowe wrote: ↑Fri Apr 19, 2024 8:31 am You need to read up on TI Local Variables https://www.ibm.com/docs/sl/planning-an ... -variables

Specifically in this case DatasourceNameForServer and DatasourceCubeview

This looks like just what I'm looking for. I'll give it a try... thank you!

Is it possible to pass the view and cube name as a parameter of the TI Process for a more 'generic' export process? Can I pick the data source in the Prolog instead? Thanks.

Appreciate you confirming my suspicion, many thanks.

We have an issue at the moment when updating a meta-data cube that is relied on heavily throughout our larger data cubes that it seems to be causing a constant recalc everytime a view is pulled once it's updated. The odd thing is, the measure that is being updated I do not believe is in ANY rules. S...

Can this be done via the rest API, or even TI process?

Thanks
Ray

Ah, I got it! I should be looping through the second dimension like such... GENERATE(FILTER(TM1FILTERBYLEVEL(TM1SUBSETALL([MMAP Versions]) , 0) , [MMAP Versions].CURRENTMEMBER.PROPERTIES("Vintage") <> "") , {STRTOMEMBER("[MMAP Vintages].[" + [MMAP Versions].CURRENTMEMBE...

Thank you for the reply. The trouble is the attribute is on a different dimension. I tried to modify your code as... GENERATE(FILTER(TM1FILTERBYLEVEL(TM1SUBSETALL([MMAP Vintages]) , 0) , [MMAP Versions].CURRENTMEMBER.PROPERTIES("Vintage") <> "") , {STRTOMEMBER("[MMAP Vintage...

Thank you so much for your reply. Here is a screenshot. I'm basically trying to get a unique list of elements of the 'MAP Vintages' dimension that are used in the 'Vintage' column of the 'MMAP Versions' dimension. And ONLY those that are used.
Thank you

I want to filter elements in a dimension (Vintage) to show only those that are used in ANY element on another dimension (Versions) in the attribute 'Vintage'. Is this possible using an MDX subset?

I appreciate the reply, and it's nice to know we're not the only ones feeling the pain. :D I'm suspecting that this is not even calc related, but is just masking a timeout. If I move the grid to another tab and refresh it separately afterwards the error does not even appear. Software development wit...

Hi All, Unable to refresh contents of widget CCL Runtime Error. Argument value -9223372036854775616 is not >= 0 We are getting this error when refreshing a review after doing some data manipulation in TI. We suspect it's an data error (as it's not happening on all selections of data) causing a probl...

Firstly, thanks for all the replies. I really appreciate you all reading through my rant. Doing a string search on the control cube was a good call. It turns out that there were rules in a second control cube that referenced the first control cube, that in turn linked back to the original cube that ...

We have a cube that is fed from another cube for reporting. It's pulling just a single metric from another cube with no calculations other than that DB pull from the other cube. When I run a query pulling all vendors (one of our dimensions) it takes a long time (about 1 minute; I will assume a first...

Thank you. It turned out what was going on here was that views were timing out with no error message being returned, and the user hit the button again thinking the views had completed. So TM1 was still running a cellset retrieve on the back end and the user was running the TI process again, which wa...

I used architect to create the view, so I think it's a traditional view, but when I trace through TM1PY (that uses restful API) it seems to create MDX anyway. Maybe that's another downside of using the restful approach. However, the benefits of being able to use Python are great, so if I can trim do...

That's very interesting, thank you. Certainly worth investigation. TI is a little clumsy for pushing data to external databases, especially for large sets of data. I guess we could spit out to CSV and consume from there, but our infrastructure makes it difficult to have shared directories on the ser...

Hi, We have another odd issue. When a user loads a template, they wait for all the views to refresh. Then they push a button in PAW that launches a TI process. We then see something strange. We see 3 active threads for that user. 2 of them are blocking each other. One thread is the execution of the ...

Hi, We are seeing some strange behavior with contention. I have no dea why a cellset retrieve would try and lock a dimension in write mode. That makes no sense to me. :( Does anyone know what's going on here? This is becoming a real headache for us. 15224 [3d15] DEBUG 2021-11-19 16:42:02.589 TM1.Loc...

Hi All, We are getting this error intermittently when loading PAW screens that are refreshing views. It says... Unable to fetch data. CCL Runtime Error: Argument value -9223372036854775616 is not >= 0 I can't find any references to it online. Has anyone seem this or knows where it's coming from.

Does anyone know if there's an article anywhere explaining exactly how locking works internally in TM1? It might shed some light on what's going on here. I've read the IBM page about locks, but it only talks about 'object' locking. I seriously hope that when I'm pulling from a view that it's not pla...