TM1 Forum

One more observation. I opened }ElementAttributes_MyTestDim.cub file in Notepad++ (yes I know .cub are binary files and are not supposed be viewed in a text editor), but among all the not recognized content I can see my TestElementOldName . The same is for MyTestDim.dim file, I can see both TestElem...

Thanks Tom. That was the first thing I thought of. The mystery is those subsets and views perfectly display the new element name after the server restart so somehow TM1 translates the old to new name when loading those sub and vue files on startup

Hi all I'm playing with SwapAliaswithPrincipalName , in particular I want to test how the new name works in subsets and views My scenario: 1. Created 1 public subset, 1 private subset, 1 public view, 1 private view 2. Set a TempAlias for my test element 3. Ran a process calling SwapAliaswithPrincipa...

My first approach would be: {FILTER( {TM1SUBSETALL( [dim2] )}, [cube1].( [dim1].[([}ElementAttribute_dim2].([dim2].CurrentMember, [}ElementAttributes_dim2].[attr_dim1_elm_name]))], [cube1_measure].[value] ) > 0 )} untestetd especially with the brackets. Idea is to extract the Elementname as Element...

Hi all To make it simple: I have 2 dimensions: dim1 and dim2 I also have a settings cube1 containing just 2 dimensions: - dim1 - cube1_measure dimensions cube1_measure dimension contains just one element: value In dim2 I have attribute attr_dim1_elm_name which contains dim1 element name related to d...

So after chatting with IBM support, the only found solution is to use Excel Conditional formatting. I tested it works as expected

Hi all I have an active form perspectives report with TM1 Report Row in column B. Column A contains my formatting rule keys. I want to calculate a format key based on the values of active form cells. Let's say I get values in columns C and D using DBRW function. Then I calculate column E as the diff...

Yeah i have done it , but not sure it will cause performance issues . I personally use this approach quite often. Especially if you need to see the total of some dynamically selected elements. For instance. You have "cube A" where you can set "exclusion flag" for elements from D...

Hi all
It's been a few months since IBM released IBM Planning Analytics Local. Could you please share your experience on trying it, thoughts on when to upgrade (how stable it is).
Thanks!

Croder wrote:I have the consolidated Total member that was created being ruled to an N Level Element

What that means?

Finally found the easier way. In tm1_64\webapps\tm1web\scripts\tm1web\standalone\ TM1WebApp.js there is a piece of code which generates URL for CAM server: window.location.href=_a576+"?b_action=xts.run&m=portal/bridge.xts&c_env=portal/variables_TM1.xml&c_cmd=../tm1/web/tm1web.html&a...

lotsaram wrote:Have you tried a search for "setting up multiple tomcat instances on a single server"?

It is different to IIS but quite well documented.

Well, I was hoping for some easier solution
Will try to follow your suggestion, thanks lotsaram

Hi all I have a few TM1 model servers and would like users to access them through TM1Web using different URLs. I don't want to show the server selection dropdown (leaving "TM1ServerName" parameter empty in "tm1web_config.xml") simply because: 1). I don't want an extra step when l...

Today I opened a PMR and had even a WebEx session with IBM. They agreed it seems like a bug with locales. Regarding DatasourceASCIIDecimalSeparator they offered to create a request for enhancement to support this variable in AsciiOutput (like it works with DatasourceASCIIDelimiter).

did you upgrade certificates on the client machine?

So DatasourceASCIIDecimalSeparator does not use decimal separator from user's locale, but NumberToString does TI processes do not interact with the user for anything other than status updates so they cannot use anything from the user's locale (as was stated earlier by Declan). They use the locale o...

babytiger wrote:I tend to use NUMBR function for converting strings to numbers.

The string you want to convert to a number. All characters other than '0' through '9', '+', '-', '.', and 'E' are ignored.

NUMBR fails converting this string: "-"

Is the transfer into text file necessary? For example, cross TM1 instance? Is cube to cube an option? As I explained before, in this particular case I can load data directly to my target cube. But in some cases I need to use file export. The issue is that with TM1 web the process is not able tonpic...

Hi all I have an issue when some user with French Windows Regional Settings runs a process (actually clicks a button in TM1Web to run that process). The process exports data to a tab delimited file, then another process imports it back to TM1 cube. Initially I used NumberToString function to export ...

Thanks for your reply As I have mentioned before we have updated the SSL certificates in the TM1 application server ,Now It shows up expiry date 17 June 2016 to 15th Jun,2024 by following steps given by below link. Link: http://www-01.ibm.com/support/docview.w ... wg21991546 Same steps we are follo...