Search found 116 matches

by vinnusea
Mon Mar 14, 2016 9:32 pm
Forum: Useful code, tips and tricks
Topic: Flow TM1 Rule Editor
Replies: 6
Views: 12895

Re: Flow TM1 Rule Editor

Hi Ricky,
Any updates on when you are planning make CAM security compatible ? Unless the editor connects through CAM not many developers can really use it. we love the tool but can't use it.

THanks,
Vinsea
by vinnusea
Tue Nov 24, 2015 10:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Insert delay in TI process
Replies: 13
Views: 15680

Re: Insert delay in TI process

Hi,
Am trying to use Blat to send emails from TM1. Would you please send me the syntax that i can use in TI ?.
Greatly appreciate for the help...

THanks,
Pat
by vinnusea
Sat Oct 24, 2015 12:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Restrict user to submit the node in TM1 web (contributor)
Replies: 1
Views: 1785

Restrict user to submit the node in TM1 web (contributor)

Hi, Problem: We have forecasting cube for users to forecast units & ASP by quarter and region for products and we calculate $Value from it. Few users sometimes put some units and forget to input ASP which results in $0's but when we look at consolidation level like yearly, then TM1 consolidates ...
by vinnusea
Thu Apr 02, 2015 11:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Color Formats in TM1 Contributor
Replies: 7
Views: 5175

Re: Color Formats in TM1 Contributor

Websheets in contributor is a brilliant idea which gives us more flexibility and functionality by building active forms but only down side is dimension on rows missing subset editor which is crucial and making whole idea as a "No GO". Hope IBM include subset editor in active forms through ...
by vinnusea
Wed Apr 01, 2015 8:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Color Formats in TM1 Contributor
Replies: 7
Views: 5175

Re: Color Formats in TM1 Contributor

Websheets; Yes 10.2 supports websheets in contributor but i dont think we can copy and paste multiple inputs at consolidation level to use breakback functionality. This is the primary reason to use Tm1 cube views there. I know we can input at C level with spread prefix's but can't do for multiple ce...
by vinnusea
Wed Apr 01, 2015 6:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Color Formats in TM1 Contributor
Replies: 7
Views: 5175

Re: Color Formats in TM1 Contributor

Thanks for the idea. Problem with the websheet is we will lose the workflow. We use cell security for only certain periods ( Actual periods) to make the product hierarchy consolidations to Read. The uncommitted data is sitting at consolidation level in product dim for actual QTR's which could not be...
by vinnusea
Wed Apr 01, 2015 6:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Color Formats in TM1 Contributor
Replies: 7
Views: 5175

Color Formats in TM1 Contributor

Hi, Is there any way to Gray out cells in cube views for consolidations in contributor for actual QTR's with out adding 'Read' security Our Scenario We have TM1 sales forecast cube views used in contributor and inputs are done at product consolidation and they breakback to 0levels. WE have rules to ...
by vinnusea
Tue Mar 11, 2014 1:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through are good in Architect but not in web
Replies: 0
Views: 1679

Drill Through are good in Architect but not in web

Hi Friends, I have created a drill through process which drills from high level cube to a detail level cube by passing time ,product & measure values. It is working in Architect but not in the web. What i mean is , example if i drill at Q1-13 i get a view opens up with Q1-13 in the detail cube.....
by vinnusea
Mon Feb 03, 2014 11:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Increment Output Txt or CSV file
Replies: 7
Views: 5980

Re: Increment Output Txt or CSV file

Hi Rodger, I created batch files to merge all the versions output txt's into single file and its working. To keep everything in TM1 side , are you advising to dump my output data into a 2D cube? and just export this 2D cube out?. Looks cleaner.. My output could be about 9Million rows ... taking the ...
by vinnusea
Mon Feb 03, 2014 9:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Increment Output Txt or CSV file
Replies: 7
Views: 5980

Re: Increment Output Txt or CSV file

Thanks that sounds a doable solution.. Appreciate for quick response...

Thanks
Vinnusea
by vinnusea
Mon Feb 03, 2014 9:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Increment Output Txt or CSV file
Replies: 7
Views: 5980

Re: Increment Output Txt or CSV file

Hi declanr,
Thanks for the reply. Ya i thought so but the file i generate is used by other ETL tools to load it to other systems. So i should be keeping my file name constant. Any other alternatives i can try off?

Thanks
by vinnusea
Mon Feb 03, 2014 9:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Increment Output Txt or CSV file
Replies: 7
Views: 5980

Increment Output Txt or CSV file

Hi all, I have a process (B) which is called from Process (A). Process (A) have a while loop which is calling Process(B) for each iteration and passes single version each time it was called. Process(B) is creates a view for passed version and exports that view to a TXT file. Issue: When ever the pro...
by vinnusea
Thu Dec 05, 2013 8:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multicommit Chore runtime issue
Replies: 7
Views: 5278

Re: Multicommit Chore runtime issue

Yes, I have disabled the savedata chore and still the issue continues. Tomorrow am planning to split the chore into 2

Chore1:
updating actuals to cube A

Chore2:
1.Update actuals from Cube A to B
2.Update forecast numbers from Cube F to Cube B

Hope this helps.
by vinnusea
Tue Dec 03, 2013 4:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multicommit Chore runtime issue
Replies: 7
Views: 5278

Multicommit Chore runtime issue

Hi, I have a chore with 3 process (below). If i run Process 1 and process 2 separately they are running fine but it i put them in a chore and make it multicommit they are running for hours (22-33hrs) . Total time of chore should be not more than 16min. (process1 6min, Process2 10min ). I noticed the...
by vinnusea
Mon Jun 17, 2013 2:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data change in tm1
Replies: 11
Views: 6694

Re: Data change in tm1

One more point to check is METADATA. Moving of Metadata could cause this issue too... Means you have your numbers in place and nothing got changed at transaction level but what if your consolidation elements gets moved? Example : If your numbers at product hierarchy got changed at higher level when ...
by vinnusea
Thu May 24, 2012 1:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Restrict from Data spreading_pros and cons
Replies: 4
Views: 4032

Re: Restrict from Data spreading_pros and cons

Yes.Even after speaking to IBM they too suggested to put C level = Read in cell security cube.....Thank you everybody...
by vinnusea
Wed May 23, 2012 1:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Restrict from Data spreading_pros and cons
Replies: 4
Views: 4032

Re: Restrict from Data spreading_pros and cons

Yes , Giving Read access to C level and write access to N level of a cube intersection is doing the job. Typing into consolidations and spreading data is disabled. But not data spreading is disabled. Still if a user writes "p950" at C level then it does the data spreading ,which is fine fo...
by vinnusea
Tue May 22, 2012 1:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Restrict from Data spreading_pros and cons
Replies: 4
Views: 4032

Restrict from Data spreading_pros and cons

Hi, Our TM1 server is having mainly two cubes and rest all control cubes and few variables cubes..Our users not liking data spreading feature in TM1 web cube views. When they click on an consolidation cell in a cube view when opened in TM1 web and type a number and press enter the data is spread pro...
by vinnusea
Tue Apr 10, 2012 11:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Values in TM1 Web and architect cube are different
Replies: 5
Views: 5265

Re: Values in TM1 Web and architect cube are different

Yes , It is not caching . Active form is created from the same cube view but in excel i have done lot of calculations and also converted period structure to show month names and a lot of stuff. Some how excel formula got disturbed and only December pulled data from different year.Sorry for posting.
by vinnusea
Wed Apr 04, 2012 9:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Values in TM1 Web and architect cube are different
Replies: 5
Views: 5265

Values in TM1 Web and architect cube are different

Hi, I have a issue with data showing in cube (architect ) and same intersection in Active form both are not same. Behaving like active form is caching data. I restarted server but no luck.Even i double checked the DBRW formula to see which intersection the cell is referring . For same intersection t...