TM1 Forum

You really haven't given any specific information which would help anyone diagnose the issue but it sounds like you should be checking the cell security for the cube where FY25 doesn't send and element security for the time dimension.

I also used to be really excited to put everything in a variable, sCube=this and sCube=that etc. just in case you need to update it later. Never happens as the likelihood of the process switching cubes is almost zero, and if you do, search and replace. All it has seemed to do is frustrate the debug...

Rules - Arc
TI - Arc
MDX - Apliqo

I don't much participate here but as I finish my lunch I might have a quick stab at this one. A : ViewZeroout (whole cube) will: - clear all data from the cube - take a variable amount of time depending on the volume of data in the cube (could take quite a while of cube is large) - assuming logging ...

I would like to bet there isn't a model out there that doesn't use an if somewhere, be it a TI or a rule. There will always be IF statements. The point is that a Boolean test is one of the most, if not the most expensive functions you can use in a rule. If you can write a rule with a pure mathemati...

I agree. Much easier done in the lookup cube itself. Then simply call the "next year" value from the cube in the MDX.

write some data to the cube. It doesn't matter where in the cube. It can be an unused portion which doesn't actually flow or consolidate anywhere. Just as long as some leaf level data is changed. The caching mechanism in TM1 is very non-granular and doesn't track calculation dependency. As soon as a...

You don't.
You are running on 11.x
Just use Arc and stop wasting your time.

I don't think you really understood the concept of using Expand here. You EITHER use expand to build the whole string converting variable names to their value by wrapping with % OR you use the pipe symbol to do the concatenation. You don't use pipes within the Expand, because what is there is just a...

Here you can use Expand to generate a string which contains double quotes. TM1FILTERBYPATTERN also has an argument for the attribute to search in. Otherwise you will be searching the principal name. The Descendants function can already return only leaves so no need to wrap in FilterByLevel. Even tho...

source has numbers -> ran the process -> data got loaded into the cube Source deleted some numbers -> ran the process -> will it replace the existing numbers with a zero in those target cells. This will depend. If the numbers deleted from the source are represented in the query as records containin...

You can list multiple data directories (yes, you can: https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=pitf-databasedirectory-1) for DataBaseDirectory parameter in tm1s.cfg file. How does it work? How can you use it? Multiple database directories was great way back when. It was quite usef...

So let me get this straight. * data from Cube A on server 1 is extracted as CSV * this CSV is used as a data source to load data to cube B on server 2 * because of concerns that someone with access to the CSV may have changed the data before loading to cube B you want to check that CSV values are st...

Well 2.1 is what you will get on SaaS if the flavour of SaaS is PAoC post rich tier depreciation. If PAaaS then that is a completely different stack on the TM1 server side as it is PA Engine or v12.x. There was an overlap where the last 2.0.x release was identical to 2.1 on the TM1 server side. This...

For me it looks like your 2nd Example is using the 's Value' Element from the same Cube, in that case you would need to write the rule like this: [ 'N Value' ] = N: NUMBR ( ['S Value'] ) ; Nope that won't work. The square bracket shorthand notation is only valid for numeric values. To retrieve a st...

Very recent addition to PAW https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=2095-new-synchronization-settings-allow-customized-display-hierarchies So this supports the base cases and is much better than before (ie: nothing). What it doesn't allow is the setting of custom MDX in the targe...

From tm1s-log.properties you can comment out or remove the following section. log4j.appender.SRC=org.apache.log4j.SharedMemoryAppender log4j.appender.SRC.File=vcsch.log log4j.appender.SRC.MaxFileSize=10 MB log4j.appender.SRC.MaxBackupIndex=0 log4j.appender.SRC.TimeZone=Local You also need to remove ...

Holy hell you weren't concerned already that loading subsets was taking over 1 hour?!

Devil's advocate here. Why do you need rest API? Wouldn't you get exactly the same result if you just used a text file with 202 columns and simply renamed the last 3 variables?

TM1 is pretty good and reliable at parallelizing pure data transactions, and even metadata these days as long as there is absolutely no overlap in objects (and dependencies) between threads . If your threads are locking then the most likely explanation is that there's a conflict in the subset names ...