TM1 Forum

Hi All, I am looking to generate stats by rule to monitor rules statistics - Old vs new rule. I am currently do not see the }StatsByRule cube in the model-so I enabled }CubeProperties control cube selected the Cube and enter YES for RULE_STATE (ELEMENT) After that I enabled the start (server) perfor...

Hi All, I am facing dimension attribute issue while copying attribute values Year to copy to New Year- only for the Top levels Example: FY 2017 attribute is 1000 same value should appear in year in FY 2023 as 1000-but it is blank. My Prolog code: vElemLength = LONG(ExistingElem); vPos = SCAN(NumberT...

Hi Mark, Sorry for any confusion. I used the Cellsupdatable function - just make sure we do not get the rule applies to cell error while running the TI. after one more try- I changed the code &(Ampersand) IF(CellIsUpdateable(TargetCube, elmCurrency, elmSource, vAccount, elmLOB1, elmEntity1, elmV...

Hi All, I am trying code with two if statements one- IFCellsupdatable and other one if CellputN IFvAccount. I am not able to save and execute TI process after the multiple try "END" out of place problem. I thought to take your suggestion to know where I am making mistake. IF(CellIsUpdateab...

It worked finally...

ASCIIOUTPUT(pFile , vdepartmentt | '|' | vDepartDescr | '|' | sRet | '|' | dPeriod | '|' | sASOFDATE);


#sRet= NumberToStringEx(Value, '####0.0000', '.', '');

Thanks again for your time..

Hi I have been trying to use NumberToStringEx to get decimal after the values, example 1234 to 1234.0000 ASCIIOUTPUT(pFile , vdepartmentt | '|' | vDepartDescr | '|' | NUMBERTOSTRINGEX(ROUNDP(Value,'#,00)) | '|' | dPeriod | '|' | sASOFDATE); I thought to get expert advise- with some example and expla...

Hi Alan,
Thank you record count worked after i tried per your suggestion.

I am still having problem to of using "NumberToStringEx" - I will come back if I can't get it.

thanks again.

Hi All, I have been trying achieve row record count and decimals in asciioutput file-but unsuccessful- i thought seek your advise In the asciioutput - file it need to contain decimal and trailing zeros. Example AMOUNT column need to contain the decimal 4 places like 1234 filed would look like 1234.0...

Hi All,

Tm1 rule do work in Dev environment -but not working when migrated to Test environment. Any advise?

Thanks
Tm1 Ver 10.2

Hi, I need to a create TI process to calculate percentage on current day value and previous day values on a dimension elements- Only for few elements-not all elements. And I need to trigger exception email to notice percentage have changed between current day and previous day. My questions are: 1) I...

Hi I am trying to move existing dimension (Accounts) hierarchy from one tm1 instance-A to another tm1 instance -B What I did - re-created the IT process to accommodate hierarchy need in instance B. used the same IT code of Instance -A- IT process executed successfully and noticed hierarchy build loo...

Hi All, I have a requirement rename dimension element-I am not sure we have element rename option is available. Do I need to delete the existing dim element and then add back? But - I have data available-present and previous. In this case do i need to export the existing element data and then load b...

Use MDX to filter out unwanted elements already in place- our MDX is currently pulling accounts list only. Some of the accounts (numbers) values are Zero- we have written macro hide accounts having zero's -but when use the print functionality of tm1 and generating PDF reports- we see the Zero appear...

Hi All,

I have active form built with few tabs zero suppress ON (=1) OFF (=0)....
Issue i am facing is Zero suppress should be been hidden on the measures (accounts) when we use cognos tm1 print functionality generating PDF's - PDF show-up Zero- which we don't want. please advise.

Regards,
Ravi

Thank you-BrianL and BariAbdul

Hi All, I am not very clear and need to understand In Cognos TM1 version 10.1 or higher, there is an option to commit each TurboIntegrator process in a chore. We are on 10.2.2 - would like to use this function/property. Not finding the format of the syntax Commit chore/process. Please advise- Regard...

Hi All, We take weekly tm1 data backup every saturday night from PRD environment. When we use these tm1 back up data/files for any of Development/enhancement purspose- we tend to compare backup data files with PRD environment for folder size, number of rux, cub, and all other tm1 folder and objects ...

Hi All,

I am trying to capture chore timing start and end time for a particular. I am currently copying log details in MS excell and then finding out the start and end of chore timing.
Is there better way get this done- MS excell macro?

Please advise
Ravi

Hi I would like to speak to you on this opportunity. Please send your contact number and email ID to send my resume. Regards, Ravi My Priofile Summary: Total 13 year of IT experience and have 7 years Financial Performance Management system implementation involving Cognos Suite Cognos Planning, TM1, ...

Hi, I haven't found any information on the Tm1 Subset IX lock- below link suggest that - it would have caused to IT process running when tm1 dynamic subset was updating. http://www-01.ibm.com/support/docview.wss?uid=swg21449631 Is there any way we re-produce issue in test environment? Please advise ...