TM1 Forum

The CellPutProportionalSpread works great. But if I try to run it in TM1 Contributor through an action button embedded in Websheet, the function does nothing. If I open the same websheet in Perspective or TM1 Web, the process works fine. Is there any additional configuration I need to do for it to w...

Thanks Mvaspal

In contributor, it is possible to manually enter data at a consolidated level cell. Data automatically breaksback to the child elements proportionally.
Can TI be used to write values to a consolidated cell through CELLPUTN or any other function?


Thanks.

Mark,

I am using a Subset with just the leaf level elements as picklist. Screenshot I posted earlier shows that.

Screenshot showing the contents of 'Time Strat Plan Licensee' is attached.

Thanks for the replies.
I have tried removing the picklist and then adding it back. That didn't help.

Screenshot showing the issue:

I am trying to create a link in TM1 10.1 Performance modeler just to see how it behaves as compared to Cognos EP. The link I am trying to create is an accumulation link and the in the source cube the Time dimension has an element called 'licensee' which uses a Picklist based on 'Licensee' dimension....

Thanks Declanr & Lotsaram. @Lotsaram - I have tried writing a rule with just one variable but even then I can't update the rule calculated cell. For example, if the rule says ['FY12']=N:2*['FY11'] and I try to update the cell ['FY12'], I still get data spread failed. Ideally I would expect it to...

Hi, In Cognos EP the calculated cells provide you the ability of editing them and then breaking back the changes to source cells. I am trying to replicate the same functionality in TM1 using rules as described below:- http://www.tm1forum.com/download/file.php?mode=view&id=1383&sid=fff5014fbe...

We are trying to create logs in form of csv or text files which would log when a particular TI process ran along with some of the key variables. I was planning to use Textoutput or ASCIIOutput functions but they overwrite the previous data present in the text file instead of just adding new rows. Is...

I need to know what is the order of priority among the Security cubes. For example, if a user 'A' has 'Read' rights to an element of a dimension in ElementSecurity cube but write permissions within the CellSecurity cube, then would he be able to just READ or WRITE? And what happens if the rights are...

Is there a way to use wildcards in TM1 rules?

For example if I want to set value of all elements starting with code 123( eg. 12345 & 12399) to a certain value, is there a way to do it in rules?

Thanks.

Thanks Jim.

Issue was with the way I was creating the view itself.

In our source cube we have certain cells which are being calculated through rules. Feeders are in place and values are visible as expected. We are trying to use TI to transfer values from this cube to another cube but TI is not copying any calculated cubes from source into the target cube. All other...

Thanks Martin. I agree with you that this is a Transactional approach and TM1 is not built for this. But client requirements rule. Since TM1 is being promoted as an Cognos EP replacement, I would expect it to at least be able to do some basic functions that are available in EP like an Accumulation D...

Can someone advise as to what would be the best way of achieving the below functionality in TM1 through rules? I have a source cube which has column using Accounts as picklist. So users can pick the account for each row from dropdown and then type in expense for that account in corresponding month. ...

Thanks for the response. I will look into the Tools you mentioned.

Hi, How can I load data into just one specific TM1 9.5.1 Contributor Workflow node using TI. In TI I don't see any options to select the workflow nodes. Is there any other way we can achieve this without using TI. For example in Cognos Enterprise Planning tool we can dump data into IM tables using I...

Cognos Enterprise Planning had the 'Get Data' function with quickload which the user could use to upload the excel sheet directly into Contributor, provided the excel sheet looked similar to the cube.

In TM1 Contributor 9.5.1 how can you achieve similar functionality?



Thanks.

Thanks a lot Tomok. This is the information I was looking for.