Search found 92 matches

by sachin
Mon Feb 12, 2018 4:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }StatsByRule
Replies: 4
Views: 3665

Re: }StatsByRule

What version of TM1 are you on? My understanding is that, this feature is available from the initial release of PA (see below link)
http://public.dhe.ibm.com/software/data ... m1_nfg.pdf
by sachin
Thu Nov 30, 2017 7:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 cube not showing data in Analysis/Report studio
Replies: 6
Views: 5853

Re: TM1 cube not showing data in Analysis/Report studio

You could try is to turn on the debugger for view generation in your tm1s-log.properties file log4j.logger.TM1.ViewArray=DEBUG Create your report in Report Studio, run it and look into your tm1server.log. You will see the view requested by BI engine, which in turn gets sent to TM1 server. Is this al...
by sachin
Tue Aug 02, 2016 12:53 am
Forum: Cognos Planning and BI
Topic: Join problem in FM
Replies: 4
Views: 57241

Re: Join problem in FM

Hi, Anyone caould help me with a possible loop join issue ? Thanks in advance to anyone willing to at leats advice something, Yes, alias shortcut is a way to address the join traps you see in the FM model. In the (g)olden days of Impromptu, we had the ability to define join weights and that was one...
by sachin
Thu Jun 30, 2016 6:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ProcessError - How to output custom Error in the Logfile?
Replies: 7
Views: 7666

Re: ProcessError - How to output custom Error in the Logfile?

I've read around the " LogOutput " Command but cant get that working on our 10.2.2 Server... https://everanalytics.wordpress.com/2015/07/23/write-to-tm1server-log-file-from-turbo-intergrator-ti-process-in-cognos-tm1/ Any hints would be very appreciated! Thanks Daniel LogOutput function wa...
by sachin
Wed Apr 06, 2016 2:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create Contributor application through TI
Replies: 2
Views: 2422

Re: Create Contributor application through TI

Hi all, is there a way to create Contributor applications through TurboIntegrator or prompt command? I did an application who self create cubes, rules, views and subsets. I can do a lot of things through TI such as manage objects and contributor security, assign TI process for Commit and Submit act...
by sachin
Tue Mar 01, 2016 8:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Business Intelligence 11 Upgrade Fix Packs
Replies: 6
Views: 4787

Re: Business Intelligence 11 Upgrade Fix Packs

lotsaram wrote:Oh cr@p I guess this applies to good ol table manager 1 as well. Another thing to remember.
Hi, this is only for Cognos BI (transitioned to Cognos Analytics). TM1 will be wrapped under Planning Analytics. In the end, they (BI + PM) are all part of Analytics!
by sachin
Tue Mar 01, 2016 7:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Business Intelligence 11 Upgrade Fix Packs
Replies: 6
Views: 4787

Re: Business Intelligence 11 Upgrade Fix Packs

Cognos Analytics is the product family you are looking for. It was Cognos BI until 10.2.2 ... with advent of 11, it has been re-branded to Analytics. So when you head over to fix central https://www-933.ibm.com/support/fixcentral/ look for Cognos Product and Sub product as Analytics. This is hardly ...
by sachin
Mon Feb 29, 2016 5:04 pm
Forum: Enhancements
Topic: RFE 82432-Picklists based on Subset to have an option to display an Alias but return Principal Name
Replies: 8
Views: 65780

Re: RFE 82432-Subset Picklists to allow option to display an Alias

Picklists based on Subset to have an option to display an Alias but return Principal Name May be I am missing something here; however I did not quite get the use case. Let's say we display the alias name in the picklist, then user makes a selection and that value is stored in the cube. If working w...
by sachin
Sun Jan 17, 2016 4:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to run ExecuteCommand() from TI
Replies: 16
Views: 10730

Re: Unable to run ExecuteCommand() from TI

Initially, I save the batch file in D:\ but got error when execute because it needs to run a winzip program. Saving in C:\ solved the batch file error. I had done some further troubleshooting below: 1. Assign the domain user account (which runs the TM1 model service) to Administrator group in serve...
by sachin
Wed Dec 09, 2015 4:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query in TI with multiple databases
Replies: 4
Views: 3668

Re: SQL Query in TI with multiple databases

What is the underlying server? Are they with the same provider? Are the 2 DBs on the same server? I never encountered this in TM1. However, I have written queries for reconciliation that span across DBs (but they were all on same MS SQL Server). You just use the syntax Select T1.*, T2.* FROM DB1.dbo...
by sachin
Wed Dec 09, 2015 5:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Keep Dimension Elements as part of TI Process
Replies: 9
Views: 5917

Re: Keep Dimension Elements as part of TI Process

What we are trying to create is an update process to the client dimension so that when we move clients around to different parents in a master CSV file, we will run the Update process to recreate the dimension, we want to keep the Unassigned Clients level in place. Right now when we run the process...
by sachin
Mon Nov 23, 2015 9:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1s-log.properties for Process Parameters
Replies: 7
Views: 8655

Re: tm1s-log.properties for Process Parameters

If you are on 10.2.2 then you can use LogOutput function to write to tm1server.log. Check the below post https://everanalytics.wordpress.com/2015/07/23/write-to-tm1server-log-file-from-turbo-intergrator-ti-process-in-cognos-tm1/ Unlike tm1s-log entry, this approach however requires you to write the ...
by sachin
Mon Oct 19, 2015 6:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1s-log.properties - timezone
Replies: 18
Views: 15203

Re: tm1s-log.properties - timezone

Have you tried raising a case with support to address this issue?
by sachin
Mon Oct 19, 2015 6:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pro & Rux file searcher
Replies: 10
Views: 8110

Re: Pro & Rux file searcher

May I make suggestion to include CellIncrementN a part of the search routine as well?
by sachin
Sat Oct 17, 2015 5:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1s-log.properties - timezone
Replies: 18
Views: 15203

Re: tm1s-log.properties - timezone

We also have this problem, the timestamps in the tm1server.log file are in GMT time. .... I'm assuming based on this no one actually found a way to resolve this? Further to this thread, it's not just TimeZone logger that refuses to work. I have recently added log4j.logger.TM1.Cube.Stargate = DEBUG ...
by sachin
Sun Aug 16, 2015 5:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element level security not working
Replies: 5
Views: 4641

Re: Element level security not working

Can you post screen which shows,
  1. The groups Cognosuser5 belongs to?
  2. Those groups' rights on the dimension in questions?

I could be wrong, however my suspect is that, Cognosuser5 is also mapped to "EveryOne" group; which must have higher permission.
by sachin
Fri Jul 24, 2015 5:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Invalid key dimension error
Replies: 5
Views: 6523

Re: Invalid key dimension error

What will be the resolution to these type of errors? In the row of your datasource, which your Data tab is processing, it encountered an element which does not exist in the corresponding dimension, yet. In your case it could be that you have data for Aug 2015, while Aug 2015 does not exist in the d...
by sachin
Fri Jul 17, 2015 5:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1_Archived Models
Replies: 5
Views: 4418

Re: TM1_Archived Models

Hi Below code I have written in my prolog and when Iam not using parameter variable then it is taking a correct size backup fine i.e 360KB but when Iam using this parameter vatiable i.e model in below code then it is not taking correct size backup its showing as 1KB which is wrong. sDataDir='\\bowt...
by sachin
Mon Jul 13, 2015 11:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 process
Replies: 2
Views: 3225

Re: TM1 process

himanshurai420 wrote: Could you please help me in creating a TM1 process which extract data from a cube and gave output as a .csv or excel file.
http://bedrocktm1.org/resources/files/B ... e2222.html
by sachin
Thu Jul 24, 2014 11:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Send mail when submit application in cognos TM1 version 10.2
Replies: 6
Views: 7169

Re: Send mail when submit application in cognos TM1 version

I have problem send email when user click submit application approval hierchy. .... I am using cognos TM1 version 10.2 Since you are on 10.2, there is functionality to achieve this. Please refer to this link from IBM information center: http://pic.dhe.ibm.com/infocenter/ctm1/v10r2m0/topic/com.ibm.s...