TM1 Forum

You could set element security against the }ElementAttributes_Employee dimension or set cell security for the }ElementAttributes_Employee cube. However I think you would be better off storing your attributes in either a custom lookup cube or else create a replica employee dimension for holding the a...

Yes it is possible but not automatically without user intervention. If you are happy for the user to click an action button that runs a process containing the ServerActiveSandboxGet() and TM1User() functions then you can write to a string cell in a cube containing the }Clients dimension the name of ...

And just to add to what Mike said, an often overlooked issue until it causes a problem is that the larger the .cub file size, the longer a data save is going to take. Our largest .cub is around 600 meg, and even with that save times can be painful (several minutes, though it's rarely that cube alon...

When a TI process runs it runs with full DataAdmin access regardless of the security process of the user who kicked the process off. If the process needs to perform security functions then you need to right-click the process and make sure the "Security Access" option is ticked. This ensure...

I'm a little confused by your post as perhaps are others. Is the screenshot you attached from your system after your changes or is it from the IBM reference material? If the image is taken from your system then YOU HAVE HIDDEN THE ADMINISTRATION NODE. The Tm1 Web navigation pane shows in order the t...

I was assuming the user would be using the manual "set dimension order" right-click option in the Perspectives UI in which case the options are more limited as once dimension sort order "by Hierarchy" is selected the component sort order automatically defaults to by name, but it'...

... BUT at the bottom of my dimension I get all the months listed. I sort of want a DimensionComponentSetParent instruction. How on earth should I do this? It doesn't look like there is anything wrong with your TI code so I assume that your dimension and the element relationships have been created ...

A simpler and less risky approach to creating an }ElementAttributes XDI would be to use an action button to run a generic process to insert a dimension attribute. That way the dimension can be edited entirely from within Excel. For columns D onwards you can use something like DINNM(DIMIX()) combinat...

There is no such thing as "advanced subset editor" in Perspectives.

This thread should not be in posted under bugs. Please review the posting guidelines.

Dear Martin, You got the exact issue. I have a cube that imports data on a daily basis and i want to compare two days' data side by side, ie. the previous day's value along with the current day's value. I'm a TM1 developer and this is an issue i have come across from one of my clients. I just want ...

Didn't work properly in 9.1 that's for sure (but no worse than the old rules editor with formatting in 8.x )
But works fine in 9.4 and 9.5, I'm now a convert for most purposes.

It is good to see other experiences here. I also experienced that metadata changes during prolog and metadata tabs are committed at the end of the metadata process. If you need to get some metadata operations to be done after the metadata tab, then you can put them in prolog or metadata tab in anot...

Yes the blb files only contain view formatting such as view number format (if being used), window size and position. As the blb files contain no actual data of importance from a system integrity point of view there is no need to back them up when backing up the data directory (in fact they probably ...

This is a simple and common requirement. Suggest you get yourself acquainted with the TurboIntegrator guide and developer guide and get a good working knowledge of TI.

Make sure Excel is in MANUAL calculation mode.

well, actually I made it with another workaround, I checked, with a CellGetN, if the value at the Top of all the dimensions is 0 or not. I was just wondering if there was a command to do this thing in order to use it. That's not quite the same as testing generically whether a view contains data (in...

Just set security mode to 2 in the tm1s.cfg file

If you are only planning on using TM1 then no issue with going with another server name other than CXMD and putting the data and logging directories in a more sensible location also!

Some lateral thinking ... You could assign the view as a data source to a generic process that has skip blanks ON but skip calcs and rules OFF (make sure the process has sufficient variables to accommodate all cubes in the model). On the prolog initialise a counter with a value of zero. On the data ...

I think it is mentioned in some documentation ... somewhere.

At least it has always been my understanding that meta data changes are not possible in the Epilog.

I would like to remove element level security completely from a dimension. Can I delete the "}ElementSecurity_fyday.cub" object when the TM1 service is stopped, and then restart without the object? Is this safe? Is there a better way to do it? A very reasonable question. When it comes to ...