TM1 Forum

thanks all.

Byron

Hi, I have a question. Is the TM1 an XBRL product?

XBRL — eXtensible Business Reporting Language — a language for the electronic communication of business and financial data is revolutionising business reporting around the world.

Code: Select all
SELECT PriceLists.PL_Open, IsNumeric([PriceLists]![PL_Open]) AS ValueIsNumeric
FROM PriceLists;

I have to say this solution is the easiest workaround so far. thanks Alan!!!

Cheers,
Byron

thanks all. If the Code value is NOT between 48 and 57 (the values for the characters 0 through to 9), 45 (a minus sign), 46 (a decimal point) or (possibly) 44 (a comma), then set the flag to 'F' and increment the counter to the Long value +1 to exit the loop. (This ensures that you loop through the...

Hi Alan, The data source is a SQL DB. The column was set as a string value in the databse, I also defined the variable field as a String variable. For example(Source data): Product Name (prodnm) 012 ABC What I want the TI process to do is IF(prodnm is a numeric); do ABC ELSE(Prodnm is a string); do ...

hi all,

is there a way to identify if a variable is a numeric or a string in a TI process?

I will be using it in a if statement, if the variable is a numeric value then do ABC, if the variable is a string value then do DEF.

Cheers,
Byron

have a try to use "NUMBR" in your TI process to get rid of the leading Zero. NUMBR converts a string to a number. The string passed to the NUMBR function must use . (period) as the decimal separator and , (comma) as the thousand separator. Any other decimal/thousand separators will cause i...

IBM Cognos now provides online training. If you are interested, please visit its website.

http://support.cognos.com/en/training/e ... tails.html

"Perhaps Martin should ask them for a contribution from their support revenue towards running this place that saves them so much work? "

I strongly support your idea.....

Hi guys,

I tried Cognos proposed solution and it didn't work.
All I need to do is to resize the subset editor once and click "cancel", the problem goes away.

thanks a lot Steve Vincent, you are the legend. How did you figure that out?

Cheers,
Byron

it's the reply from Cognos.

Hi Byron...

Download and upgrade to 9.1 SP4

http://www-01.ibm.com/software/data/cog ... nload.html

Regards,

Matt

thanks v much Alan. I am going to log a call with Cognos, see what solution they will come up with and I will update you on this.

Cheers,

It is happening on all subset editors in TM1 Server explorer. I've also discovered one thing, if I select multiple elements and click "OK', Excel doesn't crash. But if I select one of elements and click "OK", it crashes the whole Excel. It seems the issue is not happening on the TM1 s...

Hi Alan,

the TM1 folder you mentioned was found on our file server under the user profile. Anyway, I deleted and regenerated the file, but it seems the Excel crashing problem's re-appearing.

Cheers,
Byron

Hi Alan,

thanks for the reply. I couldn't find a file called "Subed.tbd" on computer. is it possibly called something else?

Cheers,
Byron

Hi all, error.JPG Everytime I open a cube in TM1 and select an element (such as “Months”) it looks like the above snap shot. If I then click on OK to select one of the elements, it then crashes my whole excel. TM1 Version : TM1 9.1 SP3 Update 1 Excel Version: Office 2003 Did anyone experience si...

Dear forumers, I am experiencing a problem on the TM1 web. I tried to export the TM1 websheet report to Excel and PDF, but I kept receiving same error message. "Excel could not open the xml spreadsheet: the server threw an exception." Has anyone experienced the same issue? Does someone kno...