Search found 138 matches

by ravi
Fri Feb 09, 2018 5:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }StatsByRule
Replies: 1
Views: 691

}StatsByRule

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...
by ravi
Wed Mar 08, 2017 10:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dim Attrubute copy problem
Replies: 0
Views: 611

Dim Attrubute copy problem

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...
by ravi
Mon Feb 27, 2017 6:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IF Statement
Replies: 4
Views: 1242

Re: IF Statement

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, elmVersi...
by ravi
Mon Feb 27, 2017 3:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IF Statement
Replies: 4
Views: 1242

IF Statement

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(CellIsUpdateable(TargetC...
by ravi
Fri Jan 27, 2017 9:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: asciioutput record count
Replies: 5
Views: 1560

Re: asciioutput record count

It worked finally...

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


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

Thanks again for your time..
by ravi
Fri Jan 27, 2017 8:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: asciioutput record count
Replies: 5
Views: 1560

Re: asciioutput record count

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...
by ravi
Fri Jan 27, 2017 1:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: asciioutput record count
Replies: 5
Views: 1560

Re: asciioutput record count

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.
by ravi
Thu Jan 26, 2017 11:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: asciioutput record count
Replies: 5
Views: 1560

asciioutput record count

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...
by ravi
Mon Nov 21, 2016 7:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 rule do not work from dev to test
Replies: 2
Views: 852

Tm1 rule do not work from dev to test

Hi All,

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

Thanks
Tm1 Ver 10.2
by ravi
Thu Oct 27, 2016 7:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process
Replies: 1
Views: 613

TI Process

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...
by ravi
Tue Oct 18, 2016 6:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension hierarchy
Replies: 1
Views: 761

Dimension hierarchy

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...
by ravi
Wed Oct 12, 2016 1:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element rename
Replies: 2
Views: 1347

Element rename

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...
by ravi
Sun Sep 11, 2016 12:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form issue with zero suppress
Replies: 3
Views: 1377

Re: Active form issue with zero suppress

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...
by ravi
Sat Sep 10, 2016 2:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form issue with zero suppress
Replies: 3
Views: 1377

Active form issue with zero suppress

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
by ravi
Mon Feb 16, 2015 4:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Commit function
Replies: 3
Views: 1903

Re: TI Commit function

Thank you-BrianL and BariAbdul
by ravi
Thu Feb 12, 2015 6:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Commit function
Replies: 3
Views: 1903

TI Commit function

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...
by ravi
Tue Feb 10, 2015 10:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Backup file compare
Replies: 3
Views: 1511

Tm1 Backup file compare

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 ...
by ravi
Fri Jan 23, 2015 9:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Chore timing
Replies: 1
Views: 1176

Chore timing

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
by ravi
Wed Jan 14, 2015 12:23 am
Forum: OLAP Jobs
Topic: Senior TM1 Consultants - Southern California
Replies: 1
Views: 2620

Re: Senior TM1 Consultants - Southern California

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, ...
by ravi
Tue Jan 13, 2015 1:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1.Subset IX Lock successfully acquired
Replies: 3
Views: 1988

Re: TM1.Subset IX Lock successfully acquired

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