Search found 21 matches

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

Error while Printing from TM1Web for Windows 7
Error while Printing from TM1Web for Windows 7
PDF Camp Print Error.jpg (41.9 KiB) Viewed 5235 times

Thanks
Amit
by amitbehere2002
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
by amitbehere2002
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
by amitbehere2002
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
by amitbehere2002
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...
by amitbehere2002
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...
by amitbehere2002
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
by amitbehere2002
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 ...
by amitbehere2002
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
by amitbehere2002
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 :roll:
by amitbehere2002
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...
by amitbehere2002
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...
by amitbehere2002
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
by amitbehere2002
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...