TM1 Forum

Some great responses as always.

The two links provided were excellent and provided some useful techniques.

And you were all write as well, the process I was testing did indeed take only a second to run.

Thanks.

Looking to record when a TI process starts and ends in a Process Log Cube. Ive created a variable for each vStarted = TIMST(NOW,'\D_\M_\Y_\h_\i_\s'); I have put into the Prolog tab and then done a CellPutS to a Log cube vEnded= TIMST(NOW,'\D_\M_\Y_\h_\i_\s'); I have put in the Epilog tab and again d...

Thanks for the link to the technote perfect. Much appreciated.

David, thanks for that but maybe you misunderstand my predicament. I have series of cubes where data is loaded from TI process. The target cells are currently open to data entry in cube viewer. What I would like to do is add cell security so in cube viewer the cells are greyed out but then allow the...

Does anyone know if it is possible to turn off breakback on a cube by cube basis in TM1 V10 Contributor ?

Im looking to allow apply read-only security to a number of cubes for non-admin users. Simple ! But these users will also be expected to execute TI processes to load data to these same target cubes. Is it possible for a non-admin user to execute a ti process but with the privaleges of an admin user ...

Am just getting to grips with the Controller FAP functionality in TM1. I would like to rename or recreate the default TM1 cube created FAPMonthlyCompanyDetails to something a little more elegant / intuitive. Has anybody managed to do this yet ? Would appear to be set in the FAP Client ? Anybodyelse ...

Thanks very much for the prompt response, much appreciated although I dont like the answer. Cognos Planning anyone

Simple question I hope

Is it possible to reorder the items in a TM1 Web application somehow ? The cube views are ordered alphabetically but I would like a different order to match my business process more closely.

Thanks.

Ive written rules in the ElementSecurity_Products control object based upon the User Groups Ive created and it works an absolute treat. Thanks for all your help and suggestions on the matter. Critically I had also forgotten to Refresh Security when using Element Security. Thanks.

Beast

If each user has only access to a single buyer then you don't have a problem. Simply apply element security to BOTH the buyer dimension AND the product dimension. Again thanks for response,indeed by applying element security to both the buyer dimension AND the product dimension as you suggest i get...

That's the way cell security works. If your user has access to multiple buyers and products then that is what they will be able to see. If you need to design a form to populate a only relevant products for a buyer selected elsewhere on the form then it is possible using an active form or subsets an...

I have a cube with a number of dimensions, the most relevant to my issue are Buyer and Products. When selecting a particular Buyer I need the user to be presented with an appropriate selection of just the Products for that particular Buyer. I have successfully used Elements Security Assignments to a...

Thanks lotsaram appreciated. Might have all the tools in my toolbag but I'm obviously trying to fix a broken pipe with a spade

Now I'm trying something along the lines of

SubsetCreate('Products',ATTRS('Product'',!Products,ProductGroup);

Am on the right lines ?

I have a product dimension is has many thousands of elements. To use the cascaded picklists functionality I have to of course create subsets.I can 'manually' create them using TI by adding SubsetCreate('Products','ProductGroup1'); SubsetCreate('Products','ProductGroup2'); etc etc etc to the Prolog t...

Steve Thank you very much indeed, you are a gentleman and a scholar. I changed the & to a % and it worked precisely as I had hoped. :D :D I think your opening point "When writing a reference to strings you have to fully qualify the reference using the DB statement" was particularly rel...

Many thanks for your help guys, :D managed to get it to work now, just couldnt get the syntax to work quite right. And I will investigate the suggestion of having a look-up cube but just wanted to get the hard coding to work first. New to TM1 and trying to convert Cognos Planning models. My next dil...

Wondered if anybody could offer some advice ? I am attempting to write a conditional formula that calculates a value for Payroll Tax % dependent on salary (ie Salary =0 THEN Payroll Tax % = 0, Salary <= 20000 THEN Payroll Tax % = 24%, Salary > 20000 THEN Payroll Tax % = 35%) and have come up with th...

James Many thanks for your reply. I have managed to get it to work with the help of a consolidation cube, setting it up with the dimension used as picklist as a dimension in my target cube. I then had to set up a string attribute of each to then test picklist in source to string attribute of dimensi...

I am trying to covert a Cognos Planning into TM1 9.5 and am trying to use picklists as a virtual dimension in the same was as i would use a formatted d-list item in Planning. And then aggregate / consolidate the totals for each of the picklist items from the source cube into a target cube wihich has...