TM1 Forum

Hi, Is there a way to format the TM1 Reports so it doesn’t show the pennies? The default would be decimals hidden but then,I can format and add 2 decimals if needed. If I do this manually to all the reports and tabs I have each month it adds another 30 min or so of time. Is there a way to do dynami...

What do you mean by "duplication" exactly?

afullex wrote:The Data Action is set to Accumulate Values.

This means the process will add the value to the value already in the cube. Is that what you want?

Alternatively (and perhaps I'm missing something) if you don't have to use VBA and just want a list of all accounts except the lowest level, I would have thought you could get such a list using a dynamic subset and an active form fairly easily.

I'm calculating a simple ratio on a cube as follows; ['Gross Commission/Income']=['Commissions']\['Income']; Where ['Gross Commission/Income'] is a ratio nominal in the dimension 'nominal', and Commissions & Income are value nominals in the same dimension. I want to be able to use the above cal...

well, what should i put to text? i try to put not variable but digits and letters to formula and get no progress. i wrote rule like dimix(.., attrs(.., elementprincipalname, aliasname )) and get zero while attrs(.., elementprincipalname, aliasname ) gives string value... The idea is to output to te...

vTechEquipmentID= Dimix ( 'Техническое средство' , vTechEquipmentIDTemp); it returns zero for one of vTechEquipmentIDTemp while i can find it in dimension So the value of vTechEquipmentIDTemp is exactly the name of an element (or an alias)? Have you tried writing the value of vTechEquipmentIDTemp t...

my DIMIX in TI variables can't find element, while i can find it by wildcard searching. Can't get what may be the reason. The same function in another process works properly. So dimix is returning 0 for an element that exists in the dimension? That shouldn't happen. Maybe you can post your actual c...

As suggested, security might be an issue. i manually gave Prod Domain Account user access to batch file path by right clicking on the folder>Properties>Security>Edit>Add full access is there any thing that i am missing As well as having rights to execute the script, the user needs to have sufficient...

Hi Lotsaram, I have done it.It should be opened only under TM1 enviornment or can be opened under where TM1 is not installed. When I opened the excel on my desktop, I cannot see TM1 ribbon on the excel. Thank you. I can't tell if this is a question or a statement but are you really expecting to be ...

Requirement : I should first load the data into Cube 2 and once it done, Cube 1 should take the data from Cube 2 and update it. So that i can avoid the data loading into Cube 1 separately. Do you really need the data in two cubes that are so similar? It sounds a bit redundant to me. In any case, If...

charan wrote:Can we update Excel file with macros on to TM1 applications?

Yes.

Have you looked at this? http://www-01.ibm.com/support/docview.w ... wg21430159

edit: just noticed that page talks about tm1web specifically but the cause might be the same

Depending on your OS and the nature of your vbs script, you might be encountering the problem I ran into here - http://www.tm1forum.com/viewtopic.php?p=33913#p34024.

Is "Days per month" defined as a numeric or a string attribute? If it's numeric, both approaches should work provided the attribute is set for the element of "Time_Day" that the rule is applied to whether or not that's a leaf or consolidation.

edit: DuncanP beat me to the punch.

What may be a reason for TI process not complete? It doesn't stops, no errors, everything is like it is making something but not going to ever finish. Are you sure it will never finish or is it just taking a really long time? Have you looked monitored it using TM1Top? In any case, why don't you jus...

so the formula will be A = B(-1 weight) + C(weight 1) I have to put the weight as Negative for one Consolidation,I want put the formula is A = B - C So which is it? ;) In any case, in the "wrong" examples you've given, it looks like A is equal to B suggesting C might be a rule calculated ...

hi Sorry i cannot post a screenshot as it is confidential Following is the example A B C -170554 153056 323610 433093 433093 804006 -31603 937297 968899 236871 588224 351353 -70891 382619 453511 646378 646378 361722 480696 480696 520925 marked bold are some examples which are not working for this i...

Hi, To ensure that there is no "hidden" issue with my csv file, I have created another TI built with the Map tab of the TI, and there it works (except that I need an attribute concatenating ID - Name). I have thus compared the Advance tabs ot the TI I've wrote with the TI built with the Ma...

Hi, I agree with your point, but I cant understand why two similar sheets created for each element. You should get one sheet for every element in the current subset. A subset can contain the same element more than once in which case you'd get multiple tabs for that element. Is that what's happening?

Hi Friends, I am facing an issue. I am retrieving a value using CELLGETN function and assigning it to a variable as shown below. nRevAdjPctVal = CellgetN (sCube, V10, V1, 'REV ADJ PCT', 'LoadStat-All', 'BP-All', 'BOXMES-All', 'FOP-All', 'Sector-All', 'AP-All', V8, 'data'); Now when I am comparing t...

I'm able to preview the Query but when it comes to uploading the data to the TM1 Cube I get that error. By this do you mean that when you open the TI process in the editor, the preview box on the data tab contains data? If so are passing it any parameters that might render the sql invalid? Are you ...