Search found 8 matches

by AlvinPresley
Fri Jun 10, 2016 9:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reopen the same Sheet/Application after closing it
Replies: 1
Views: 1897

Reopen the same Sheet/Application after closing it

Hello People! Is there any way I could close an application and reopen it as a new application automatically? I used the Action button to do that.But the issue I'm facing is; If I select something on a subnm function in the web and then click the action button(which has rebuild sheet and replace the...
by AlvinPresley
Fri Jun 10, 2016 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Border every 7th row
Replies: 5
Views: 4546

Re: Border every 7th row

Hello People! Thank you for your suggestions! I had to change the entire formatting area to set things right! Thanks to Ardi..It did work..that is what i did..I was just looking for a workaround though. Anyways, figured that this way was much simpler and a straight forward approach! Thanks again! Ch...
by AlvinPresley
Thu May 26, 2016 11:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Border every 7th row
Replies: 5
Views: 4546

Border every 7th row

Hi, Is there anyway in which we can put a different border for every 7th row and a different border for the first 6 rows? Every 7 rows have the same rptrow value! I've tried to use the conditional formatting in the format section but that doesnt seem to work. May be because i have another condition ...
by AlvinPresley
Thu May 12, 2016 4:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Two cubes with multiple RPT Rows and format error
Replies: 0
Views: 1451

Two cubes with multiple RPT Rows and format error

Hello Folks! Here is the issue: I have created an active form with two cubes. I have 5 RPT Rows , one below the other with a couple of calculations below each. I have set one format range with one Data format column and 5 data ranges for the rpt rows, one for each.I am getting the proper output in t...
by AlvinPresley
Fri Apr 29, 2016 1:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Recurring Calculations per RPTROW Value
Replies: 6
Views: 3892

Re: Recurring Calculations per RPTROW Value

Hey Thank you very much declanr!! That trick definitely worked for me!

Cheers!
by AlvinPresley
Fri Apr 22, 2016 5:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Recurring Calculations per RPTROW Value
Replies: 6
Views: 3892

Re: Recurring Calculations per RPTROW Value

Thank you David and Steve. Steve,I'll get back to you on that after testing it.

Cheers!
by AlvinPresley
Thu Apr 21, 2016 9:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Recurring Calculations per RPTROW Value
Replies: 6
Views: 3892

Re: Recurring Calculations per RPTROW Value

Also I cannot add VBA code to it because it doesnt work on TM1 web.Tm1 web is the place where i have to disply the report. Thanks again!
by AlvinPresley
Thu Apr 21, 2016 8:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Recurring Calculations per RPTROW Value
Replies: 6
Views: 3892

Recurring Calculations per RPTROW Value

Hello there! I'm new to TM1 and I have been working on this particular report on TM1 Perspectives where in I have to display calculations based on the DBRW below each RPTRow output. For Example, Bucket Item Jan Feb Mar April May June July...Dec (First Rptrow Value) 1. Apple 10 20 30 20 5 40 12 ...50...