Search found 327 matches

by rkaif
Wed Jun 06, 2012 2:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to connect to TM1 cube from different Cognos BI env
Replies: 7
Views: 9605

Re: Unable to connect to TM1 cube from different Cognos BI e

You need to check the settings in the Cognos Connection. Or would be nice if you can share the screenshots from the Cognos connection. More info on setting up TM1 Data sources on Cognos is explained here: http://www.packtpub.com/article/integrating-ibm-cognos-tm1-with-ibm-cognos-8-bi and http://publ...
by rkaif
Thu May 31, 2012 6:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element not seen by user but only buy admin
Replies: 3
Views: 2169

Re: Element not seen by user but only buy admin

Security might be an issue. Have you checked the security of the new element created?

The other possibility is that the end user may be looking at a static subset and the new element is not part of the Subset. Has the user clicked on the ALL button in the Subset Editor?
by rkaif
Wed May 30, 2012 5:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Record Count in TI process
Replies: 2
Views: 4608

Re: Record Count in TI process

You can also create some "Status" cubes which stores the information related to the number of Records Read, Skipped, Completion time etc. Sending results through emails would be one option but if you are using Cognos in your environment then in that case you can use Event Studio to send al...
by rkaif
Wed May 30, 2012 5:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOUTPUT formate
Replies: 10
Views: 6500

Re: ASCIIOUTPUT formate

anoops81 wrote:If you use the ASCIIOutput function to write to the same file in multiple procedures (tabs) of a TurboIntegrator process, the file will be overwritten each time it is opened for a new procedure.
You are right but it was a joke from Wim Gielis :))
by rkaif
Wed May 30, 2012 5:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CreateCube from csv source, using TI
Replies: 3
Views: 2681

Re: CreateCube from csv source, using TI

CreateCube(CubeName, d1, d2,....n) First of all the the correct function to create the cubes is CubeCreate() - not CreateCube which you have mentioned. Personally I think that creating cubes from the CSV might not be a good idea but yes you can create the cubes using a CSV files. You can have two c...
by rkaif
Wed May 30, 2012 4:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Having different level of element display on different colum
Replies: 4
Views: 3161

Re: Having different level of element display on different c

I thought about this to put all the the level into one attribute but user feels that there should be a proper way around to do it. The user uses powerplay before therefore already had an expectation that the new system that is put in should have identical feature as well. Once you have implemented ...
by rkaif
Tue May 29, 2012 6:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.1 Application Web - what client it is?
Replies: 3
Views: 2960

Re: 10.1 Application Web - what client it is?

It is a web-based client for TM1 and is used for planning.

Read this for details: http://publib.boulder.ibm.com/infocente ... /index.jsp
by rkaif
Tue May 29, 2012 2:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Having different level of element display on different colum
Replies: 4
Views: 3161

Re: Having different level of element display on different c

Another thing if you want to see the Level 3, Level 2 and Level 1 on separate columns in Excel then you can create 3 different attributes and use these attributes in the Active Form (or standard excel sheet) with DBRW() in it.
by rkaif
Tue May 29, 2012 2:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Having different level of element display on different colum
Replies: 4
Views: 3161

Re: Having different level of element display on different c

Winson, You can create an Attribute/Alias for the Dimension. This attribute will hold the Element names concatenated with the Parent names. Your Alias will look like: Level 3 Level 2 Level 1.1 Level 0.1 Level 3 Level 2 Level 1.1 Level 0.2 Level 3 Level 2 Level 1.1 Level 0.3 Then you can use this Ali...
by rkaif
Tue May 29, 2012 2:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error when saving a view in EViewer
Replies: 10
Views: 4988

Re: Error when saving a view in EViewer

Yes, the data source table is in the Catalog Provide which EV uses for its content management.

Refer to this link:

http://publib.boulder.ibm.com/infocente ... t_sou.html
by rkaif
Mon May 28, 2012 8:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Chore best practices
Replies: 4
Views: 3248

Re: Chore best practices

First of all, like everyone I am shocked to see the 400+ which is way too many. I wish it was typo from you - if not then you must be facing some serious performance issues. I have noticed some time- thier may not may new dim available in source(DB) -hence dim update chore is not necessary to run 4 ...
by rkaif
Mon May 28, 2012 8:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error when saving a view in EViewer
Replies: 10
Views: 4988

Re: Error when saving a view in EViewer

This is a weird error.

Have you tried changing the Title Elements in your view? May be there is an element which is an invalid character for the EV Data source table.
by rkaif
Mon May 28, 2012 7:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Toolbar name change
Replies: 1
Views: 1345

Re: TM1 Toolbar name change

'TM1' name in the TM1 toolbar is set through the TM1 add-on which comes with TM1.

There is no built-in option in TM1 which allows you to change it.

You may be able to change it if you can hack into tm1pRibbonX.xlam file :)
by rkaif
Mon May 28, 2012 7:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Limiting View to a Single Server
Replies: 3
Views: 2126

Re: Limiting View to a Single Server

Users will only be able to log to the Service to which they have been given access to. If a user do not have access to the other Services then even if they can see the names of services they will not be able to log on to these other services. There is no such built-in option in TM1 by which you can ...
by rkaif
Fri May 25, 2012 1:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 9.5.2 Perspectives and Excel 2007
Replies: 2
Views: 2159

Re: TM1 9.5.2 Perspectives and Excel 2007

In the Excel Options there is a setting for Move Selection After Enter. You can set its direction to Left, Right, Up and Down. In Excel 2003 this option is in the Edit tab.

Another thing, instead of using a macro you can also use the Active Button to recalc your sheet
by rkaif
Sat May 12, 2012 6:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slice to Excel
Replies: 1
Views: 1783

Re: Slice to Excel

Do a complete uninstall.
Delete the C:\Documents and Settings\Username\Application Data\Applix folder
Make sure you have installed all the per-requisites for TM1 (like .NEt framework etc)
Install TM1 again

These steps resolve most of the install issues.
by rkaif
Sat May 12, 2012 5:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: contributor 9.5_error.
Replies: 3
Views: 2804

Re: contributor 9.5_error.

Try using TomCat for the Contributor

Also make sure you have applied the latest Fix patches
by rkaif
Sat May 12, 2012 4:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 "wizard” approach
Replies: 8
Views: 4433

Re: Tm1 "wizard” approach

Personally I think using Wizard is only for the newbies who just want to very basic stuff. Wizards are also good for the Prototyping but for the 'real-world' projects you need to be good in TI coding.
by rkaif
Sat May 12, 2012 4:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Server Monitoting
Replies: 2
Views: 1965

Re: Tm1 Server Monitoting

Yes tomok is right. If your TM1 server is down then you can not do anything in TM1 - you can not run a TI or do any other TM1 related task. You really need a 3rd party utility to do that. I am not sure but may be there is something in Event Studio (if you have Cognos in your environment) which allow...
by rkaif
Sat May 12, 2012 4:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Display cube data on Excel
Replies: 5
Views: 3137

Re: Display cube data on Excel

I created a cube that contain 3 dimensions and 1 measure, for example for cube data: UserName Year StaffId Salary If I am interpreting your cube design right then you have two separate dimensions for UserName and StaffID. I would advise you to merge these two into same dimension and treat one of th...