Search found 2484 matches

by tomok
Tue Nov 13, 2018 1:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 mode 2 or 3 with SSO
Replies: 9
Views: 1170

Re: Tm1 mode 2 or 3 with SSO

No, your understanding is not correct. Both Mode 2 and 3 would be considered integrated login with authentication to AD. The difference between 2 and 3 is that 2 allows EITHER AD authentication OR native TM1 security, based on the client's choice, while 3 only accepts AD authentication. All that stu...
by tomok
Fri Nov 09, 2018 4:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 mode 2 or 3 with SSO
Replies: 9
Views: 1170

Re: Tm1 mode 2 or 3 with SSO

What is the different between mode 5 and mode2?? May be cloud support in mode=5? Mode 2 is integrated login (using Kerberos or NTLM) OR native security, client's choice. Mode 5 is CAM (Cognos Access Manager). They are not the same thing although they both can utilize your AD for authentication. Rea...
by tomok
Fri Nov 09, 2018 11:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to programmatically open files from Application folder
Replies: 9
Views: 489

Re: How to programmatically open files from Application folder

Those .blob files are not the Excel workbooks, they are the application objects and only contain information about them. The actual Excel files are in the }Externals folder which is in the Data folder like all the other TM1 objects (like .dim, .cub, etc., files).
by tomok
Tue Nov 06, 2018 10:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 mode 2 or 3 with SSO
Replies: 9
Views: 1170

Re: Tm1 mode 2 or 3 with SSO

Which client are you referring to? It makes a difference.
by tomok
Thu Nov 01, 2018 4:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Case Sensitive vs. TM1 10.2 not case sensitive
Replies: 6
Views: 198

Re: PA Case Sensitive vs. TM1 10.2 not case sensitive

I think they mean PA is case sensitive for TM1 objects like cubes, dimensions, elements, attributes, etc. Not variable names inside a TI process.
by tomok
Tue Oct 30, 2018 11:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: subnm with variable overriden
Replies: 7
Views: 231

Re: subnm with variable overriden

I think I know what you are talking about. Sometimes I like to have the subset parameter of the SUBNM formula point to a cell instead of a literal value in order to make the subset used dynamic. This works great the first time you actually use the SUBNM formula to pick an item from a subset but once...
by tomok
Fri Oct 26, 2018 1:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule file mismatch in architect and .rux file
Replies: 9
Views: 223

Re: Rule file mismatch in architect and .rux file

But why does this happen, Is it TM1 problem? The only time I've experienced the issue is because of a mistake made in the migration of objects from one server to another. Let's say you have a cube called MyCube, that has rules. This means there are two files pertaining to the rules: MyCube.rux and ...
by tomok
Thu Oct 25, 2018 12:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element Security Override
Replies: 4
Views: 148

Re: Element Security Override

Another option is to create a CellSecurity cube for those cubes that use the department dimension differently and apply your security there.
by tomok
Wed Oct 17, 2018 9:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Removing user when using CAM security
Replies: 4
Views: 249

Re: Removing user when using CAM security

To a certain extent, if the user is removed from AD, then they will not be able to sign in to TM1 anyway. However, it is tidier to remove the user from TM1 as well. Thanks for the info Paul. I agree with you and to me it isn't an issue for a disabled ID to stay in TM1 but the auditors see it differ...
by tomok
Tue Oct 16, 2018 10:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Removing user when using CAM security
Replies: 4
Views: 249

Removing user when using CAM security

I've never really spent time with CAM other than to work with a TM1 system where it has already been set up. I understand that users automatically get created in TM1 when a CAM user logs in the first time. My question is about removing users when they leave the company. Are users automatically remov...
by tomok
Fri Oct 12, 2018 11:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 pax DBRW() function
Replies: 5
Views: 312

Re: Tm1 pax DBRW() function

kavitha2002 wrote:
Fri Oct 12, 2018 7:36 am
Is it possible with the conditional formatting to set "" empty string for #VAlUE, so that my problem will be solved. I hope its not possible.
Ever hear of the ISERROR function??????
by tomok
Wed Oct 10, 2018 3:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: attributes in data tab
Replies: 4
Views: 236

Re: attributes in data tab

In database terms metadata represents the structure in the tables; columns, indexes, etc. Data is the rows in the table. Since attribute values are data it is be done in the Data tab. If you were adding an attribute to a dimension, meaning the structure, and not actually adding the values for the at...
by tomok
Tue Oct 09, 2018 12:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }ElementAttributes_ not updated with attributes
Replies: 6
Views: 470

Re: }ElementAttributes_ not updated with attributes

By chance are the alias attribute values missing the same as the element name? Whenever you have an alias set on a dimension and you have one or more alias values that are the same as the elements then TM1 will not accept those values in the }ElementAttributes_ cube. There were still be a value for ...
by tomok
Wed Oct 03, 2018 7:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleting elements from dimension
Replies: 8
Views: 463

Re: Deleting elements from dimension

Obviously, the DimensionElementDelete function is quite simple. What is not so simple, and what I think the OP is after, is how to filter to just the elements that match the criteria he specified, namely those invoices create/posted/??? after a specific date. The first requirement is going to be som...
by tomok
Wed Oct 03, 2018 4:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process - Meta Data Behavior
Replies: 2
Views: 151

Re: TI Process - Meta Data Behavior

Go back to the person that is creating the file and ask them to use something else as the delimiter.My personal preference is the pipe character, "|", as that is rarely in data. They could also use tabs, or any other character that is unlikely to be embedded in the data.
by tomok
Fri Sep 28, 2018 3:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX query using more than one cube.
Replies: 8
Views: 245

Re: MDX query using more than one cube.

Here's what I would do: 1) Create a zero-suppressed active form report on Cube A. This would give you the rows where the IsActive value is 1. Add a VIEW statement for Cube B. For the rest of the report use DBRW formulas that point to Cube B and the new VIEW statement. The caveat is this is really on...
by tomok
Thu Sep 27, 2018 6:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [Postman] Unexpected token : yes but where ?!
Replies: 9
Views: 247

Re: [Postman] Unexpected token : yes but where ?!

Is TM1 so difficult for newbies ? I have worked for 15 years on webapps and Java developments... To be fair, you are not really using TM1. You are using Postman to access data from TM1 via the REST API. Almost no one, except app developers like yourself, would ever dream of using the REST API. TM1 ...
by tomok
Thu Sep 06, 2018 7:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Saves not completing and retriggering 10.2.2 FP4
Replies: 13
Views: 447

Re: Data Saves not completing and retriggering 10.2.2 FP4

You really should NEVER have any other processes running when a Save Data is taking place, it's just going to cause problems. Turning on PI is not going to help because Save Data saves the entire cube at once, not just the area you changed. You need to go back and create a schedule that ensures that...
by tomok
Tue Sep 04, 2018 3:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Dimension Elements to Subset in Tm1 REST api
Replies: 4
Views: 541

Re: Copy Dimension Elements to Subset in Tm1 REST api

Hi Everyone, Is it possible to copy the Dimension Elements into subset using Tm1 rest api? Will it leads to performance drawback? suggest me some direction. Thanks Have you even attempted to look any of this up in the documentation? I've never used the REST API before but I found what you were look...
by tomok
Wed Aug 29, 2018 6:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Order of Cube-Processing
Replies: 10
Views: 435

Re: Order of Cube-Processing

Okay, got it. Thx. But, to stay with my example. I tested that A is processed before C. So can I say that all C's are processed before another A is selected or is this mixed? If you really want know what order you are going to get just take your view, use it as a data source, and instead of writing...