Search found 21 matches
- Wed Mar 20, 2013 5:03 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Contributor Creating a Logical groups in Workflow
- Replies: 0
- Views: 2046
TM1 Contributor Creating a Logical groups in Workflow
Hi All, My Application in TM1 Contributor Automatically Creates a Logical Workflow Groups As Follows Contributor Group Error.jpg Which i have not Configured in TM1 Contributor but whenever it finds more than 15 Values in 0 Level Node it creates group as follows Node 0 (1-15) Node 0 (16-20) and So on...
- Thu Mar 14, 2013 7:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Log Files to Excel Conversion via VBA Macros In Excel
- Replies: 2
- Views: 2497
Re: Log Files to Excel Conversion via VBA Macros In Excel
Hi
Thanks a lot for your Auspicious Reply
But I have posted this Question on TM1 Forum as Some of the People May have faced this issue for Log Files and created a code
Thanks
Amit
Thanks a lot for your Auspicious Reply
But I have posted this Question on TM1 Forum as Some of the People May have faced this issue for Log Files and created a code
Thanks
Amit
- Thu Mar 14, 2013 5:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Log Files to Excel Conversion via VBA Macros In Excel
- Replies: 2
- Views: 2497
Log Files to Excel Conversion via VBA Macros In Excel
Hi All, I need one help about Log File to Excel Conversion via VBA Macro Following will be the criteria for Creation of Excel via VBA 1. .log Text File to .xls file Conversion 2. Designated Path for .Log and .xls File 3.It will Automatic Append the .log File in Same Excel 4. Excel To be Named as Cur...
- Thu Mar 14, 2013 5:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Export to PDF Error
- Replies: 6
- Views: 5235
Re: Export to PDF Error
Hi Lotsaram, In TM1 9.5.2 if we need to Export to PDF from Tm1Web we need to Set the Page Orientation in PDF Cam Driver in Control Panel of Windows Where only 3 Options are available which are as follows 1. Portrait 2. Landscape 2. Landscape Reversed After Working on all possible things i have asked...
- Sun Mar 10, 2013 11:12 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Export to PDF Error
- Replies: 6
- Views: 5235
Re: Export to PDF Error
Thanks a lot All the Errors Solved
But i need a help can we Export to Page in "Fit to Selection Mode"
Please do let me know for the same
Thanks
Amit
But i need a help can we Export to Page in "Fit to Selection Mode"
Please do let me know for the same
Thanks
Amit
- Sat Mar 09, 2013 5:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Export to PDF Error
- Replies: 6
- Views: 5235
Re: Export to PDF Error
Hi, Thanks a lot for your Help Now i am able to Export the cube view to PDF but i am getting another error after exporting to PDF while opening the PDF File Following is the Snapshot for the same PDF Camp after Print Error.jpg Following are the System Configuration 1. TM1 10.1.1 2. Adobe Reader 10 D...
- Fri Mar 08, 2013 12:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Export to PDF Error
- Replies: 6
- Views: 5235
Export to PDF Error
Hi,
I have Installed TM1 10.1.1 on my Machine for Windows 7 64 Bit
Whenever i am trying to export to PDF from TM1 Web i am getting following Error
Thanks
Amit
I have Installed TM1 10.1.1 on my Machine for Windows 7 64 Bit
Whenever i am trying to export to PDF from TM1 Web i am getting following Error
Thanks
Amit
- Wed Mar 06, 2013 5:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rolling Average for Quarters
- Replies: 11
- Views: 9528
Re: Rolling Average for Quarters
Hi,
I want to achieve this with the help of Rules
Please guide me for the same
Thanks
Amit
I want to achieve this with the help of Rules
Please guide me for the same
Thanks
Amit
- Tue Mar 05, 2013 12:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Export to PDF in Landscape
- Replies: 2
- Views: 3211
Export to PDF in Landscape
Hi,
Want to know in TM1 can we export reports to PDF in Landscape Mode ?
Waiting for your urgent Reply
Thanks
Amit
Want to know in TM1 can we export reports to PDF in Landscape Mode ?
Waiting for your urgent Reply
Thanks
Amit
- Tue Mar 05, 2013 11:28 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rolling Average for Quarters
- Replies: 11
- Views: 9528
Re: Rolling Average for Quarters
Hi James,
Thanks a lot for your help
but this will not work out for solution which i need for Rolling Average Calculation
Thanks
Amit
Thanks a lot for your help
but this will not work out for solution which i need for Rolling Average Calculation
Thanks
Amit
- Tue Mar 05, 2013 10:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rolling Average for Quarters
- Replies: 11
- Views: 9528
Re: Rolling Average for Quarters
Following is the Example for the Rolling Average 1 Q3 2008 27980 2 Q4 2008 10054 3 Q1 2009 53762 4 Q2 2009 49638 5 Q3 2009 69453 6 Q4 2009 72014 7 Q1 2010 23292 8 Q2 2010 87890 9 Q3 2010 47597 10 Q4 2010 98952 11 Q1 2011 74982 12 Q2 2011 28498 13 Q3 2011 96301 14 Q4 2011 35430 15 Q1 2012 91058 16 Q2...
- Tue Mar 05, 2013 9:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rolling Average for Quarters
- Replies: 11
- Views: 9528
Rolling Average for Quarters
Scenario :- 1 When we are calculating we need to go back to first 20 quarters for e.g. from Q1 2013 to last 20 Quarters for Rolling Average 2.while calculation condition must be satisfied of having at least 75% Values not Null out of 20 Quarters 3. if 20 Quarters doesn't have null Value then i will...
- Fri Sep 21, 2012 8:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Negative Weight Issue
- Replies: 10
- Views: 6977
Re: Negative Weight Issue
Hi
In my scenario
A is parent of B and C and where B is also a parent of some Elements and weight for B is -1
C with the weight of +1
so the formula will be A = B(-1 weight) + C(weight 1)
formula is correct but it is not working in some of the calculation as mentioned above
In my scenario
A is parent of B and C and where B is also a parent of some Elements and weight for B is -1
C with the weight of +1
so the formula will be A = B(-1 weight) + C(weight 1)
formula is correct but it is not working in some of the calculation as mentioned above
- Fri Sep 21, 2012 8:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Negative Weight Issue
- Replies: 10
- Views: 6977
Re: Negative Weight Issue
hi Sorry i cannot post a screenshot as it is confidential Following is the example A B C -170554 153056 323610 433093 433093 804006 -31603 937297 968899 236871 588224 351353 -70891 382619 453511 646378 646378 361722 480696 480696 520925 marked bold are some examples which are not working for this i ...
- Fri Sep 21, 2012 7:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Negative Weight Issue
- Replies: 10
- Views: 6977
Re: Negative Weight Issue
Hi
No Rule is not attached for this consolidation
they have done is they have added the weight as -1 for Consolidation
No Rule is not attached for this consolidation
they have done is they have added the weight as -1 for Consolidation
- Fri Sep 21, 2012 7:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Negative Weight Issue
- Replies: 10
- Views: 6977
Re: Negative Weight Issue
Hi
It was wrongly quoted
My Question is quite simple as in my Formula is A = B-C
where B is Consolidated value
so the Formula will be A = B(1+2+3+4+5) - C
so this formula is not working everywhere in my Cubeview
Please do let me know for the same
It was wrongly quoted
My Question is quite simple as in my Formula is A = B-C
where B is Consolidated value
so the Formula will be A = B(1+2+3+4+5) - C
so this formula is not working everywhere in my Cubeview
Please do let me know for the same

- Thu Sep 20, 2012 9:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Negative Weight Issue
- Replies: 10
- Views: 6977
Re: Negative Weight Issue
Hi All, I got some issue about consolidation in my TM1 Application as I have to put the weight as Negative for one Consolidation,I want put the formula is A = B - C Where in Formula B is Consolidation with the weight of -1 So the issue comes up is somewhere the formula is working properly but somew...
- Thu Sep 20, 2012 8:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Negative Weight Issue
- Replies: 10
- Views: 6977
Negative Weight Issue
Hi All, I got some issue about consolidation in my TM1 Application as I have to put the weight as Negative for one Consolidation,I want put the formula is A = B - C Where in Formula B is Consolidation with the weight of -1 So the issue comes up is somewhere the formula is working properly but somewh...
- Wed Jan 18, 2012 11:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Want to retrieve all element in Dimension
- Replies: 6
- Views: 6677
Want to retrieve all element in Dimension
Hi,
I want to retrieve all the elements in Dimension to use it for CellputS function
please help me in the same
Thanks
Amit
I want to retrieve all the elements in Dimension to use it for CellputS function
please help me in the same
Thanks
Amit
- Tue Jan 17, 2012 11:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Data Validation
- Replies: 4
- Views: 3413
Re: Data Validation
Thank you for your reply. but what i need is top management put in some numbers for lower level and it get transferred to respective version and after that respective version will put in their figures after agreeing or not agreeing on the same which is being provided by top management so what i need...