TM1 Forum

So there actually seems to be a way though not official/documented. If you add PooledMemoryMaxLimit=<threshold in MB> to your tm1s.cfg, that instance will basically just crash when the threshold is reached. Not ideal normally but may be what you need in your specific case. My TM1server.log shows th...

Sorry for bringing this old thread back from the dead. 2 years later, looks like the issue still exists, with the number of columns expanded to 1000 upon activeforms rebuild. Nothing we can do there. In terms of the file size though, I have found a way to minimise the file size . Because that's my m...

Is the destination instance name same as source instance name? If not, you may need to update the excel file (in }externals) with the correct instance name.

What I would do is, attached a random number (10 digits) to the view/subset name every time a temporary object is used. And I've removed the check and remove existing view/subsets (the chance of the same object name is used in the same process chain is pretty low). Since they are temporary objects, ...

Just to clarify on a few things: 1. What does the button do? 2. When a websheet is opened, does it open in tm1web? 3. Does it store a counter, or update a subset as part of a process that action button triggers? 4. Does the original websheet contains the 5 worksheets? or does it get generated as par...

The issue here is not with the MDX. Checking the MDX, it looks ok. The issue is here, there may be cases where one or more site codes stored (in the Primary Site attribute) is invalid site. Hence the MDX errored out. If you are confident that all the non-blanks are valid site codes, then there is a ...

Hello, 1) How do I use/setup Notepad++ 7.6 to Edit and Save TI processes. I am not sure how to set up Notepad++ 7.6 for TM1 10.2.2. Its painful indenting TI with space bars in TM1 native editor. 2) Does IBM PA (latest version of TM1 have better editor for TI and Rules ?) Thanks, Rtel If your main c...

If you want to stick with csv, then I would suggest getting the source file tidied up, as I believe the csv file is not correctly created. In the scenario you've shown, if correctly formatted in csv, it should be "126", "Lance, Christopher" ,"Christopher","Lance&q...

I am not very familiar with Postman, but should your JSON payload not be in the body? Pre-request script should be Javascript code. Yes, in this case, the MDX query statement should be part of "Body". Is TM1 so difficult for newbies ? I have worked for 15 years on webapps and Java develop...

Nice one.

Sorry if my original post was a bit brief and/or confusing. Just want to clarify a couple of things: TI: }tp_deploy_create_shadow_dimension - This TI replicates your ApprovalDim to a shadow dimension, eg. }tp_task}....... This TI doesn't have anything to do with security. TI: }tp_rights_update_RDCLS...

The security cubes I've mentioned in my post behaves the same way as other security cubes in TM1. So, you can apply rules to those cube if you want. Just need to make sure you trigger a security refresh after update of approval dim. Because ruled security doesn't take effect straightaway, it is diff...

In your MDX example, TM1FILTERBYPATTERN is not doing anything, since you don't have a wildcard (*) in your criteria. If what you wanted is just to specify, months (M01 to M12), then bring through all the children/leaf elements, then this may help: {TM1FILTERBYLEVEL( {DESCENDANTS( {[Period].[M01],[Pe...

Someone who has the time to play around with it ? :D 5 minutes can always be donated :lol: A TI process with a dynamic level 0 subset as the data source, and the Metadata inserting an N-level element in the dimension, will have the Data tab including this new element. Anyone who can test in a diffe...

That's really interesting. I wondered if this is a version specific functionality.

Yes, you can refresh/save rights of a Contributor Application via TI. I've done that for a few contributor apps for multiple clients. 1. You need to find out which apps (assuming you have multiple apps that use different approval dim/subsets). You can get all the info via "}tp_applications"...

Have you tried unloading picklist target cube, and then reload the target cube (create a one cell cube view and access it).

Suspect there is a cube dependency on picklist cubes. Destroying the picklist cube may have removed this dependency.

This is a fairly common scenario for a TM1 reporting cube, whether is reported from BI or other reporting tools such as Perspectives. Here is what I would do: All calculations is done in TM1 cube. Introduce another Account Attribute [1, -1] in TM1 that refers to the Revenue/Expenses attribute. This ...

If user usability outweighs performance, then I would be more incline to go with multiple cubes. DBRW formulas on perspective would be shorter, since you don't have to select those non-relevant dimensions for a cube. Users can still reference multiple cubes on the same sheet, (but it is more difficu...

I guess you would have evaluate the pros and cons of each method: Separate cube pros: less sparse cubes easier to rule and feed easier for user consumption (fewer dimensions to select from) cons: may require more TIs for data load or export may introduce reconciliation issues (as one GL combining P&...