TM1 Forum

Resurrecting this thread from the dead... I noticed this technote from IBM, which states that conditional formatting should be working in both Excel and TM1 Web from 10.2.2 FP1 onwards: To see the hidden text in Excel you can change the color of the font by using a conditional format on the outer ro...

Hello All, Need a quick help. I have below statement in data tab but whenever i run the TI Process i get an error of SQL invalidity. sql= 'UPDATE MON_SAL SET UPI = get_decryption(UPI) WHERE UPI IS NOT NULL AND month =''APR'' and year = 2015'; ODBCoutput(strOrcDB, EXPAND(sql)); Please let me know wh...

Do you have a DimensionSortOrder statement directly before the DimensionDeleteAllElements statement? Than you're probably caught by this bug...
In that case reversing the order of the statements would solve the issue.

Michel

Has anyone found a solution to this problem? We recently upgraded to the TM1 10.2.2 version. We have some applications that use active forms to help users export data. Some of these active forms had macros attached to hide columns with no values. With the new version, macros can’t be use, and colum...

Hi I have created a Ti to load data from SAP with package connector in 9.5 version. in that to minimize time and data load i have use filtering for month and year by using prompts in framework manager. now i want that the prompts should be picked up from any cube or dynamic ti process so that i can...

LOL BTW - the issue seems to be the application (at least for radhikah78) is behaving as documented

What it SHOULD say is only the user owning the lock ( OR any member of the Admin group) can release the lock. I think that would be Reserve rights - in case of Lock rights only an admin can undo the lock. Interesting this - based on the documentation I always assumed the Reserve and Lock rights wer...

Maybe I've gone through this thread too quickly, but... Reading the fine manual on element security it states: Locking and Unlocking an Element When a user locks an element, only those users who have Admin rights for that element can update the data that it identifies. Even the user who locks the el...

when you have a multiplication or division based rule, you only need to feed the area definition with the first part of the calculation. I agree with you that you only need to feed from one of the calculation component areas, but this can either be A or B (so not necessarily the first part), where ...

lotsaram wrote:It would definitely be a useful feature to have in the cube viewer and active forms.

Seconded.

Michel

lotsaram wrote:Unfortunately all native TM1 interfaces such as the cube viewer and active forms do not support asymmetric slices/views.

I don't know whether you consider Cognos Insight native, but that front end does support asymmetric slices/views.

Michel

Thanks Brian-I am aware of the floating point issue and am fairly sure there will be issues in the model relating to this due to the large numbers in the model. However, I would expect the two functions to present the same results with the floating issue present in both. This is really what is irki...

Was the error a one-off or is this a consistently occurring error? Some thoughts: Is there a virus scanner active that could lock files from time to time? Did anything change recently in the (rule-based) security setup that could lead to the user trying to commit data to areas that (s)he was allowed...

You could have a look at this technote, and if you're talking about Cognos Express PM, than you could have ea look at this technote.

Michel

Did you activate the application in TM1 applications?

Michel

Thanks Michel,I am puzzled too! Since all the dimensions in this cube has numeric datatype elements ,still "Can't convert to real number " error I am unable to understand. Hi Abdul, The error message is about your data source, not your cube. You receive a value "SLT" in field (v...

Cannot convert field number 8, value "SLT" to a real number Here,SLT is of numeric datatype,I have deleted the destination cube and created again with different dimensional ordering ,even tried StringToNumber etc but no success. Hi Abdul, The error states that it cannot convert the value ...

After dragging the new Dimension to the Cube and selecting the first option to "Place all of the data in one member of DIMENSION" and also "Clear all the Data". I get the following error: java.lang.RuntimeException: com.cognos.pmta.api.exceptions.TM1APIException: com.ibm.cognos....

Hi, We are using IBM Cognos for Microsoft Office and after installation, it asks for Namespace, Username and password. We are NOT using integrated log on and whenever we provide TM1 access user name password it throws error. Any idea how to resolve this issue? Are we missing any configuration part....

lotsaram wrote:Whenever I'm teaching TM1 to users I always make the point in the subset editor section "don't worry about this button, you will never use it."

That's what I do too.

Michel