Search found 2496 matches

by tomok
Fri Dec 07, 2018 4:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dropdown list in Chrome for TM1 Web not responding
Replies: 10
Views: 472

Re: Dropdown list in Chrome for TM1 Web not responding

As ridiculous as it sounds, as we approach 2019, Internet Explorer is still the gold standard in the corporate world. Companies feel that as long it works in IE they are OK as far as browser compatibility is concerned.
by tomok
Thu Dec 06, 2018 8:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: issues with moving TI processes
Replies: 7
Views: 308

Re: issues with moving TI processes

FYI, the bedrock processes call each other recursively. Changing names is going to break that unless you went into the code of each process and changed it there too.
by tomok
Tue Dec 04, 2018 5:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: One vs Two Time Dimensions
Replies: 8
Views: 511

Re: One vs Two Time Dimensions

Just as a heads up, if you're going from 10.2.2 to PA2.0+ then expect a significant increase in RAM consumption. We are moving to the cloud and our production server uses about 50GB or RAM. When we moved it to the cloud at 64GB it wouldn't even come up. We are having to upgrade our cloud environment...
by tomok
Mon Dec 03, 2018 9:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: setting up a new application on Architect
Replies: 2
Views: 235

Re: setting up a new application on Architect

Rtel wrote:
Mon Dec 03, 2018 8:25 pm
copying TM1 config file
You changed the port number in the following setting, correct?

Code: Select all

PortNumber=
by tomok
Fri Nov 30, 2018 1:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How Do I Protect Password on ODBCOpen
Replies: 14
Views: 2436

Re: How Do I Protect Password on ODBCOpen

Are there any solution to this problem with Oracle DB? The only thing I know that you can do is store the Oracle and ID and password in a text file in a share that only the TM1 service account has access to. You have a wrapper process that uses this file as a data source that reads the ID and passw...
by tomok
Tue Nov 20, 2018 6:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives on Network vs Stand-Alone
Replies: 9
Views: 522

Re: TM1 Perspectives on Network vs Stand-Alone

You own TM1 (which is quite expensive BTW) and no one in your organization knows how to use it nor has any documentation? You can just Google, it will give you plenty of links to online docs.
by tomok
Tue Nov 20, 2018 5:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives on Network vs Stand-Alone
Replies: 9
Views: 522

Re: TM1 Perspectives on Network vs Stand-Alone

As I suspected, you have created a local set of dimensions and cubes. You can't really "share" these. You can copy the contents of your C:/Users/itsupport.CFB/Desktop/CFB folder to a network share and then point your Data Directory there. Others can point their TM1 to the same place but only one per...
by tomok
Tue Nov 20, 2018 3:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Work-around for granting access when there is no admin??
Replies: 5
Views: 198

Re: Work-around for granting access when there is no admin??

Are you talking about a CUBE or a SERVER? It sounds like you are confusing the two.
by tomok
Tue Nov 20, 2018 3:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives on Network vs Stand-Alone
Replies: 9
Views: 522

Re: TM1 Perspectives on Network vs Stand-Alone

Are you talking about adding a new TM1 service to the TM1 server or are you talking about local cubes and dimensions you have built on your local PC? You need to show us two things; 1) a screen shot of the settings for Perspectives/Architect and 2) a screen shot of the Architect/Perspectives tree on...
by tomok
Sat Nov 17, 2018 1:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Websheet function: find the Group of a user
Replies: 7
Views: 1420

Re: Websheet function: find the Group of a user

Thank you Tomok. So the only way, is to look into the cube and see if the intersection between the user and the group is non empty? I want to do it in a spreadsheet. it becomes a little cumbersome. But yes, I can do it this way. Micheline A zero-suppressed active form with }Clients as title dimensi...
by tomok
Thu Nov 15, 2018 7:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX using OR
Replies: 5
Views: 358

Re: MDX using OR

Create a rollup on your time dimension called "Current and Prior Year" and reference that in the MDX.
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: 1878

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: 1878

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: 1036

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: 1878

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: 329

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: 392

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: 296

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: 230

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.