TM1 Forum

Hi Thanks for the update, I got workaround to scan this by using CHAR(39) code

Hi All, I have came to issue where i need to scan for ' (Single quotes). the issue was i am capturing user names in the TM1 from cognos and i have one user Name "N'DOUBA". Now the issue is i am exporting this to database with SQL statement and because of this special character TI getting f...

Hi everyone,
Just for information...
The issue was related to the SSL certificates and the fixpack which i have removed. Now everything is working fine.
Thanks

Hi, I have installed TM1 10.X in AWS environment. the installation is completed successfully and i have test servers up and running. i am able to access those from architect of that AWS server with Admin host blank or machine name. But when i tried tm1 web by localhost:9510/tm1web or <machine-name>:...

Hi,

i would like to create subset based on the element type, mean i need to create subset only with numeric elements or string elements.

Kindly provide the solution....

Thanks for the quick reply. I have implemented this option to take backup of the server. But if we implement this we have to start the backup server, but in my case i need both the servers up and running so in case production server(Hardware) get crashed we will link to DR server with minimum effort...

Hi, I need to keep Production and data recovery(DR) server in sync. To solve this i have two options: 1.crated TI processes in The DR server which will load data from Production with the help of ODBO and run these TI in CHORE. 2. Create replication in DR server and synchronize data. Kindly suggest w...

Hi Mincharug Shulft , As per the my understanding, kindly try this MDX code for the dimension i think this will solve your purpose. in this "Dimension_Name" refers to the name of the dimension in which the elements are present and I have hard coded Americans as you need that to be displaye...

hi David,

actully the excel formating doesn't worked in this case as i have tried this before.
my data is upto 15 decimal.

Hi, Recently I come to the situation where my leaf level cell are set to zero/ blank but at the consolidation I have applied one rule. I have written feeder for the same but as per my knowledge feeders will be applicable only for leaf level. So because of this my consolidated cell becomes NOT FED an...

Hi i am extracting the values from the TM1 cube to the excel through DBRW/DBR function. values are flowing correctly to the excel sheet but when the number is more than 12 decimal it automatically round off and display in the excel, this is creating the data mismatch in the excel. So kindly provide ...

Hi,

I need to find the subsets which are used in the TM1 views of the cube.
Is there any way to find it through TI process.

Thanks & Rgards
Vaibhav Late

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 ...

Hi I have two TM1 instances in server one is to load SAP data and other one is regular. In this i have connected these two server with ODBO connection which was working fine. But from yesterday it is giving me error that "Can not connect to ODBO data source" please give suggestions to solv...

Hi
I have observed that if i set any view with suppress zero then while opening from web it gives me only white screen unlike architect which give message"No Value Available"
Is there any other option so that user get to know that the value is zero for that cell, Or any other message...

Hi I have scheduled one ti process to pull data from SAP system to TM1 through framework manager. But the problem is that SAP cube is also get refreshed at regular interval and if both the time matched with each other my server get crashed with following Error message: 14104 [461] DEBUG 2014-07-07 0...

I am Using Admin ID for this process an All user in the server has access to this process.

Hi All , I have the Scheduled TI process to load data from SAP to TM1 which gives me the error message as Execution was aborted. No Security Access for "SetElementGroupsSecurity". But if the same TI executed manually it get executed successfully . So please help me on this issue as i want ...

Hi Sir,

I have created two servers server 1 and server 2. In server one i have created two dimensions with some common elements.
And in server 2 i try to pull these dimension into one by different ti processes.
Now you can see the duplicate elements with _1 suffix for common elements...

Actually while pulling from SAP to Cognos I am getting this type of errors. Suppose i have manually created "SLVR" and if it is in SAP it will create "SLVR_1" Prolog: #****Begin: Generated Statements*** NULLV1='#'; DIMENSIONELEMENTINSERT('sapcapthreadtype', '', NULLV1,'N'); #****...