TM1 Forum

I discussed my early encounters with Vista in the thread The Vista From My Windows (http://forums.olapforums.com/viewtopic.php?f=5&t=485) in the General forum, but I'm putting this one in the TM1 forum since it has a specific relevance to TM1 use. Now, before we begin, everybody please pretend t...

I am curious to know how many people are interested in developing web-based applications around their TM1 solutions. By this, I mean, is there a real need out there to create more customized and guided applications for your users, or do you find that you can do everything you need today and they ar...

I started the line : Feeders; ['Oct-08','Actual'] =>['Oct-08','Test']; Thinking that will map all n element of Oct, actual to all n oct-08 test. But it did not work, so I posted the question and I was told to use add one line at the begining, so I thought that was initialised line. ['Oct-08','Test'...

I was trying to find help for what this line actually do, was it to initialise the element actual ? :roll: ['Oct-08','Test'] =N: ['Oct-08','Actual']; I'm not following you. The purpose of a rule is to calculate an "area" (range of values) of the cube based on values stored in another area...

Vote in the poll above. Will stay a sticky for the week. Then languish for several weeks till I remember to action whatever we decide. It would appear that you remembered. :D I think that works much better. Although.... there is just one small bothersome thing for keyboard hounds. When you hit the ...

May have to dabble my toes in the recruitment waters again at some point soon and would appreciate any feedback from anyone who's tried recruiting over the last few months. I haven't, but I HAVE noticed an upswing in recruiters wanting to "pick my brain" about a TM1 position, blah, blah (...

Thanks - In regards to inserting new line characters: I tried the following and in notepad it seems not to work: string = '123'; string = string | Char(10); string = string | Char(13); string = string | '456'; ASCIIOUTPUT('output.txt', string); ExecuteCommand('notepad output.txt', 0); output.txt co...

Thanks for the quick and concise replies - How can I add in a a newline character to a string? Eg. string = 'Hello'; string = string|'\n'; string = string|'more'; ASCIIOUTPUT('output.txt', string); How can I add in other special characters? Use the CHAR rules function. New line is Char(10) (though ...

Thanks - how can I get the number of dimensions in a cube? Just loop through the dims until you hit a blank. For example: SC_CUBE = 'YourCubeName'; l_Counter = 1; While ( l_Counter <=256 ); s_DimName = TabDim ( SC_CUBE, l_Counter); If ( s_DimName @= ''); l_NumberOfDims = l_Counter - 1; l_Counter = ...

Some spreadsheets with no macro but with lots of TM1 link formulas on it, when the spreadsheet get refreshed, the code pop up and the debug tab was grey out. leaving continue and end tab. The code doesn't have to be within the workbook itself. The tm1p.xla add-in has VB/A code in it as well, and th...

I mean I have cube1 on TM1 Server A and cube2 on Tm1 Server2 Can I write a DB rule between cube1 and cube2? No. Only if cube1 and cube2 are on the same server. For communicating between two servers you'd have to use either TI or replication, but you don't have any option which allows live calculati...

Can someone tell me how to stop a chore other than set it not active ? The chore settings have parameter to run by/by day, hrs and min, for a chore that requires to run from 8 to 5 , there is no setting to tell it stop at 5 other than manual intervention to set the chore not active from "front...

Another approach is to use the TI Function GetProcessErrorFileDirectory Since the ProcessErrorFileDirectory will generally be the same as the Database Directory, or the Logging Directory if you use one. That will generally be similar to the path for the Server, assuming that you are really trying t...

Has anyone used TI to create a private subset? Not directly possible, I don't think. TI's run as Administrator, not as the person who triggered them, if any. If a chore is manually triggered then any changes to the data are logged under that person's name (which means that TM1 must know who pulled ...

Perhaps it does not solve that specific issue, however, it certainly is better than allowing a user to copy over another users views and perhaps destroying a similarly named one inadvertently. It also introduces the perception that the copy is linked to the original view, such that if someone makes...

This could have been made twice as useful as it is had someone thought about it more... CellIsUpdateable checks if a cell can be written to, but it FAILS if one of the elements doesn't exist. Rather than failing (and dumping things in to the error log) it should also return zero if the element is m...

Hello, Is it possible to rename elements of a dimension without losing data? I have a situation where project managers create contract names (an element in the Contract Dimension) and forecast using those contract names. However, some of them make typing mistakes or put the wrong contract name. You...

One of my New Year's resolutions for 2009 is to reduce my internet watchlist by 75%. Olapedia did not make the cut, for obvious reasons: (1) it is no longer active, having no new articles since July, and (2) since none of the administrators are policing it, spammers are turning it into a link farm....

That was one of the first guesses, should have mentioned that as well. I have backup of all the source files, and have checked. Nothing is duplicated there. Will look at it tomorrow. I will keep everyone posted. I can't buy the data tab running twice either; not in 9.0. If that were possible I thin...

Hello, Can I change the weight of an element in a dimension through Dimension worksheet ? I have tried using DBSA command but it didnt seem to work.... or is there a faster way? The weight isn't an attribute; it's specific to the consolidation that an element appears in, not to the element itself. ...