Search found 132 matches
- Thu Aug 20, 2015 7:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Localization of Dimension Elements with Caption Attribute
- Replies: 7
- Views: 4386
Re: Localization of Dimension Elements with Caption Attribute
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...
- Thu Aug 20, 2015 6:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Localization of Dimension Elements with Caption Attribute
- Replies: 7
- Views: 4386
Re: Localization of Dimension Elements with Caption Attribute
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
Thanks
- Thu Aug 20, 2015 5:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Localization of Dimension Elements with Caption Attribute
- Replies: 7
- Views: 4386
Localization of Dimension Elements with Caption Attribute
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...
- Tue Aug 11, 2015 10:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - Activeform vs Subset Editor results
- Replies: 4
- Views: 2525
Re: MDX - Activeform vs Subset Editor results
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
- Mon Aug 10, 2015 7:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API / JQuery to list all the websheets under an application folder
- Replies: 0
- Views: 1188
REST API / JQuery to list all the websheets under an application folder
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...
- Wed May 06, 2015 6:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing Cube logging from Action Button TIs
- Replies: 27
- Views: 13263
Re: Managing Cube logging from Action Button TIs
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...
- Wed May 06, 2015 1:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing Cube logging from Action Button TIs
- Replies: 27
- Views: 13263
Re: Managing Cube logging from Action Button TIs
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...
- Tue May 05, 2015 1:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing Cube logging from Action Button TIs
- Replies: 27
- Views: 13263
Re: Managing Cube logging from Action Button TIs
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 ...
- Tue May 05, 2015 1:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing Cube logging from Action Button TIs
- Replies: 27
- Views: 13263
Re: Managing Cube logging from Action Button TIs
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 ...
- Mon May 04, 2015 7:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing Cube logging from Action Button TIs
- Replies: 27
- Views: 13263
Re: Managing Cube logging from Action Button TIs
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...
- Mon May 04, 2015 7:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing Cube logging from Action Button TIs
- Replies: 27
- Views: 13263
Re: Managing Cube logging from Action Button TIs
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...
- Mon May 04, 2015 6:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing Cube logging from Action Button TIs
- Replies: 27
- Views: 13263
Re: Managing Cube logging from Action Button TIs
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...
- Mon May 04, 2015 6:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing Cube logging from Action Button TIs
- Replies: 27
- Views: 13263
Re: Managing Cube logging from Action Button TIs
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...
- Mon May 04, 2015 6:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing Cube logging from Action Button TIs
- Replies: 27
- Views: 13263
Re: Managing Cube logging from Action Button TIs
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...
- Mon May 04, 2015 4:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing Cube logging from Action Button TIs
- Replies: 27
- Views: 13263
Re: Managing Cube logging from Action Button TIs
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...
- Mon May 04, 2015 3:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing Cube logging from Action Button TIs
- Replies: 27
- Views: 13263
Re: Managing Cube logging from Action Button TIs
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...
- Mon May 04, 2015 3:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Managing Cube logging from Action Button TIs
- Replies: 27
- Views: 13263
Managing Cube logging from Action Button TIs
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...
- Mon Apr 20, 2015 8:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: A circular reference
- Replies: 10
- Views: 14591
Re: A circular reference
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...
- Mon Apr 20, 2015 5:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web Websheet Documentation
- Replies: 2
- Views: 2621
TM1Web Websheet Documentation
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...
- Mon Mar 23, 2015 4:46 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Best Practice for Action Button that Run a TI Process
- Replies: 3
- Views: 3818
Best Practice for Action Button that Run a TI Process
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 ...