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
Search found 92 matches
- Mon Feb 12, 2018 4:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }StatsByRule
- Replies: 4
- Views: 3803
- 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: 6100
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...
- Tue Aug 02, 2016 12:53 am
- Forum: Cognos Planning and BI
- Topic: Join problem in FM
- Replies: 4
- Views: 59434
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...
- 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: 7775
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...
- Wed Apr 06, 2016 2:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Create Contributor application through TI
- Replies: 2
- Views: 2450
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...
- 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: 4844
Re: Business Intelligence 11 Upgrade Fix Packs
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!lotsaram wrote:Oh cr@p I guess this applies to good ol table manager 1 as well. Another thing to remember.
- 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: 4844
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 ...
- 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: 68585
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...
- 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: 10875
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...
- 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: 3715
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...
- 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: 5977
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...
- 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: 8746
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 ...
- Mon Oct 19, 2015 6:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: tm1s-log.properties - timezone
- Replies: 18
- Views: 15336
Re: tm1s-log.properties - timezone
Have you tried raising a case with support to address this issue?
- Mon Oct 19, 2015 6:28 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pro & Rux file searcher
- Replies: 10
- Views: 8218
Re: Pro & Rux file searcher
May I make suggestion to include CellIncrementN a part of the search routine as well?
- Sat Oct 17, 2015 5:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: tm1s-log.properties - timezone
- Replies: 18
- Views: 15336
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 ...
- Sun Aug 16, 2015 5:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Element level security not working
- Replies: 5
- Views: 4694
Re: Element level security not working
Can you post screen which shows,
I could be wrong, however my suspect is that, Cognosuser5 is also mapped to "EveryOne" group; which must have higher permission.
- The groups Cognosuser5 belongs to?
- 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.
- Fri Jul 24, 2015 5:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Invalid key dimension error
- Replies: 5
- Views: 6621
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...
- Fri Jul 17, 2015 5:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1_Archived Models
- Replies: 5
- Views: 4481
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...
- Mon Jul 13, 2015 11:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 process
- Replies: 2
- Views: 3254
Re: TM1 process
http://bedrocktm1.org/resources/files/B ... e2222.htmlhimanshurai420 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.
- 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: 7229
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...