TM1 Forum

gtonkin wrote: ↑Sat Oct 11, 2025 3:22 pm Is your alias by any chance called "Description"?

No, it's called 'Name'.

Appreciate the prompt reply, thank you. We use pre-defined views so that our super-user clients can control the data that's output themselves. We were allowing them to design these views and then output to CSV using them. However, since 2.1 that now seems to be completely broken. Most of the views a...

We have found a problem in upgrading to 2.1+. It seems using a cube/view data source it's now showing correctly (in preview) a variable (v1, v2, etc.) for each dimension, but in the data script v1 has id for the first dimension, v2 has alias for the first dimension, v3 has id for the second dimensio...

Ok, so I had to modify the registry and change HKEY_CLASSES_ROOT\Applications\modelerclient.exe\shell\open\command to...

c:\program files\ibm\spss\modeler\18.3\bin\modelerclient.exe -stream "%1"

Previously it did not have the -stream part. Yikes. Why isn't this part of the install?

I just had to re-install SPSS and now when I try and open a stream my double-clicking (or from CNDS) it says 'unrecognized argument'. I follow the KB article and re-selected SPSS as the program associated with STR, but it's still not working. Is this a Windows 11 issue? Works fine when I open the st...

Hi All, I have a TI process to export a view. It works fine consistently for native view but, and I'm not sure what's triggering it, after a while it stops outputting for PAW designed views (MDX). No file is produced, as it seems no rows are getting returned. If I switch the source back to native it...

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