TM1 Forum

It does not, and that's what I am trying, to avoid users see the element codes since they have no meaning to them, instead I am trying to use this Caption Alias, which in all other cases ( for Cube Names and Dimension Names ) is applied automatically, so if there is a Caption Attribute defined for a...

It is an Alias, and I can see it in the list of Aliases in the subset editor, and yes If I manually turn the Caption Alias ON, it shows the values. But I thought this should show automatically, otherwise, what is the difference from a regular alias?

Thanks

Hi, I am trying to localize the dimension element names by creating an attribute called caption and populating it with ATTRPUTS Ti function ( for the selected language ), basically Im trying to figure out a way to create a default display type of Alias so every time you click the dimension in TM1Web...

I think i was dealing with an issue like this a few months ago, I was trying to Use LEFT function in the MDX expression. I could never get it working in Perspectives but it worked in TM1Web. Just try this

Hi, I have a requirement to populate a TreeView with names of websheets of a specific folder under TM1 Applications. I was able to add them to the treeview node with HTML/JavaScript but what i need now is to make the list dynamic, so a piece of code that loops through applicationentries dimension or...

Yes, replacing CubeSetLogChanges with CellPutS seems to work, but IBM technical support guy does not agree with that. They're saying that by design, if 2 processes are trying to update the same cell at the same time, TM1 will put a lock on the second process. I showed him how it works when Logging f...

Yes, that exact code causes locking ( the only way it does not create locking is if Cube Logging for the cube }CubeProperties is ON, so in that case TM1 will not commit the change to the cube yet ). So just make sure that in the }CubeProperties cube, the setting for the cube }CubeProperties is NO a...

Hi I would be interested to know why rules behaved poorly on this. They generally only do this when you are feeding from one cell and have to target many cells. However, this looks like a classic case of changing levels. Therefore the feeders should be simple to write. Another alternative would be ...

I just fired up my copy of 10.2 RP2 FP2 and I can't see your issue. I created a dummy TI that just does this: prolog CubeSetLogChanges('PriceCube',0); sleep(10000); epilog CubeSetLogChanges('PriceCube',1); If I log in twice and run the same TI at the same time I can see the both run in parallel in ...

I forgot to say that YES, PI is turned ON, and what happens is, if I have 5 processes running in parallel, and let's say the first one changes the cube logging for Cube_A, when the second process tries to change the cube_logging for Cube_A, it cannot proceed, and after that point the execution of a...

Also, I can't find any references to back this up; but for some reason I keep thinking you can just write to the }CubeProperties cube directly using CellPutS and that it *might* have a different contention footprint. Since I can't verify that right now, YMMV. I am on 10.2.2 FP2 I guess, but this is...

Any overlapping data write operation causes locking issues. If 2 processes try to update the same cell in the same time, the second one will be locked, and this is exactly what happens with setting cube logging on or off No. Without parallel interaction two users writing to any cell in the same cub...

turning off/on cube logging will impact the parallel execution of processes, that's why I cannot do it. Are you running with ParallelInteraction=T? If so, changing the cube logging property should be no more invasive (from a locking standpoint) than a data write. Maybe that was not the case in some...

You can turn the logging off and on in the prolog and epilogue of the TI called by action button. What do you mean by "log files are getting huge"? Define it. If you are talking 10s to 100s of GB of logs per day you may have a point, otherwise probably not. What kind of data is being copi...

To be clear is the problem that the process is running too slowly (which would obviously be improved by not logging transactions for the process) or are you just struggling with the size of log file it is creating? The process execution time is OK, but if I turn off cube logging it can be better. E...

The users only directly manipulate "Cube A" so leave the logging turned on for that cube and just have it constantly off for "Cube B"; since "Cube B" is updated by TI process the users wouldn't need write access - therefore if your TIs and admins are trusted then it sh...

Hi, We have to keep Cube Logging on in our data entry cubes in order to be able to trace users transactions. In our model, we have multiple data entry cubes ( at different level or granularity ) so users enter transactions at a very detailed cube ( Cube_A) and in the Websheet they click an Action bu...

If you're not using the wizard, then it's easy to resolve this issue. Looking at your sample data, your source file contains 3 columns, which in most cases represent a child-parent-grandparent relationship. So in your metadata tab, with the assumption that you have 3 variables named (vElement, vPare...

Hi, Trying to write a document for all the Websheets in our model, and just wanted to check if you have done such a document or if there is any magical tool that I can use for that purpose:) Our websheets are active form based, with Action Buttons to perform data calculation and data movements. If y...

Hi, I have a few websheets with active forms, where users will adjust data, and then I have an Action Button which will perform some calculations and move data to a Reporting cube. For some of the intersections, the active form returns lots of rows ( and columns ), and eventhough the execution time ...