TM1 Forum

It might be worth noting that the SSL version was changed in FP6 and by default older clients (using the older SSL version) are blocked from connecting. You can enable support for older clients with the SupportPreTLSv12Clients tm1s.cfg parameter. http://www-01.ibm.com/support/docview.wss?uid=swg2704...

FP 6 switched to using TLS 1.2 for communication and rejects all pre TLS 1.2 communication. You need to either update the clients to FP 6 as well, or enable pre-TLS 1.2 support. To support old clients set the parameter SupportPreTLSv12Clients to T in your tm1s.cfg file. Here's the relevant documenta...

a) Your dimension is fine but looks odd due to the sort order of the elements. Issue a DimensionSortOrder on an empty statement or put the values into }DimensionProperties. See elsewhere on this Forum for that. This is the source of your confusion. The "duplicated" elements are not duplic...

Assuming the desired out come is as stated (that "the entire dimension has 'READ' privileges") you would be much, much better off simply setting each of the cubes that uses the ID dimension to 'READ'. This is effectively the same and I'm not sure why it didn't hit me before now. If you do ...

If your goal is to secure data in cubes that use the ID dimension, then dimension security isn't actually taken into account. Cube, element and cell security are all that are considered. Likely the reason your element security rule did not work is the point that Tom mentioned. After you update the I...

Cell Security takes a sort of priority over other types of object security and allows you to override more restrictive access given by element or cube security. Minor correction: I don't believe cell security can override cube security. So if cube security is READ and cell security is WRITE, the re...

Is the Excel installation 64 bit as well? 64 bit perspectives only works with 64 bit Excel.

I'm not sure that the symptoms line up with that issue, but it's worth checking.

Setting a dimension to NONE prevents that group from opening any cube using that dimension in Cube Viewer. The other rights have to do with editing the dimension structure and attributes. ADMIN Add/Remove attributes Create public subsets (from READ elements) but NOT delete them (requires the user to...

Got it. I set it up using Java... for (int iDimIndex = 1; iDimIndex < lTM1Server.getDimensionCount().getInt(); iDimIndex++) { lTM1Dim = lTM1Server.getDimension (iDimIndex); System.out.println ("Dimension Name: " + lTM1Dim.getProperty (TM1Properties.ObjectName).getString()); System.out.pri...

I'm a software engineer at Motio and we're currently working on a feature for our TM1 admin tool that could be helpful. The goal was to make debugging security issues as easy as possible. The feature is currently in beta but if you want to give it a spin and see if it helps, send me a PM and I'll ge...

I believe he means the spaces around the "=". As in
-pwd password tiparam=value

and if value happened to be the string 'value with spaces' you would have to quote the value. As in
-pwd password tiparam="value with spaces"

I don't know of any official documentation that explicitly says the Java version. However this article may help you locate the jre folder. https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_inst.10.2.2.doc/t_tm1_inst_tm1web_config_for_SSL.html?view=embed You can t...

It looks like they use Java 1.7. Naturally, that's IBM Java 1.7.

declanr wrote:The OP shows the error is seen in the data tab.

Ah, I must have glossed over that. Good catch. You are clearly much more observant than I am.

tomok wrote:but what I think he meant is that you can't build a variable in the prolog that is based off anything in the data source.

Exactly what I meant.

If the code you're having an issue with is in Prolog or Epilog, the variables are not available as they happen before and after the datasource is processed.

You could define a rule along the lines of ['budget']=N:0; That would set all N elements to 0 for budget and because they are calculated, they would not be editable. But that's assuming you already have a C rule to calculate the budget for consolidations. Otherwise, all of the consolidations will ju...

It would be helpful to say exactly what you're trying to accomplish. There may be another tool besides Java extensions that could help you achieve your goal.

Did you try doing a security refresh after writing the rule?

Rule-based security requires a refresh when the calculation changes. Manually setting the security through "Process > Security Assignment", on the other hand, does not require a refresh.