Search found 2520 matches

by tomok
Wed Mar 13, 2019 6:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help with IntegratedSecurityMode 2/3
Replies: 8
Views: 706

Re: Help with IntegratedSecurityMode 2/3

In this case users are .com and all lower case. Sadly that doesn't work Don't use anything after the domain. If your full ID is fred.smith@mycompany.com then your TM1 ID would be "fred.smith" and the value in the unique ID field would be "fred.smith@mycompany". Note we are not including the ".com".
by tomok
Wed Mar 13, 2019 4:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help with IntegratedSecurityMode 2/3
Replies: 8
Views: 706

Re: Help with IntegratedSecurityMode 2/3

Not sure what the ".x" is after the domain but it has to be just the domain. If your user id is userid@mycompany.com then then the user ID in TM1 would be user@mycompany. It is also case sensitive, both ID and domain.
by tomok
Thu Mar 07, 2019 11:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteProcess not setting ProcessExitWithMessge return code correctly
Replies: 10
Views: 1258

Re: ExecuteProcess not setting ProcessExitWithMessge return code correctly

Writing an entry to the server log in and of itself is not an error condition. I do this in all my dimension maintenance processes (to list out all the new members added from Oracle) and it does not create an error condition. Use Global Variables like Wim suggested. I use them all the time to do thi...
by tomok
Wed Feb 27, 2019 8:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBCOutput Failure
Replies: 2
Views: 120

Re: ODBCOutput Failure

Guys, As far as I can tell (and experienced in the past) ODBCOutput does not return any kind of error code when executing a query. The IBM documentation only mentions the 255 character limit. I plan on writing a sub process to validate the DB after the query has executed but if there's a better way...
by tomok
Wed Feb 20, 2019 2:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Edit TI Process without first Executing it?
Replies: 16
Views: 2436

Re: How to Edit TI Process without first Executing it?

Hello, I am not able to open/edit the TI since this TI process source as SQL query, When i try to open the TI it will loading for long time after then it went not responding mode. Any suggestion here Could you Please help me . Thanks Did you even bother to read the posts in this topic or did you ju...
by tomok
Wed Feb 20, 2019 2:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA TM1 Web difference on Scale Divisor
Replies: 2
Views: 112

Re: PA TM1 Web difference on Scale Divisor

If you don't care about the footings at the bottom (i.e., no rounding) then you can also do the same with conditional numeric formatting in your report. Have the conditional formatting change based on your selector drop-down. I've done the same thing a few times before and it works fine.
by tomok
Wed Feb 20, 2019 2:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temp View difference to Perm Views
Replies: 14
Views: 437

Re: Temp View difference to Perm Views

If using Temp Views you need to use something along the following lines IF( ViewExists( vCube , vView ) = 1 ) ; ViewDestroy( vCube , vView ) ; ENDIF ; ViewCreate( vCube , vView , 1 ) ; ViewSubsetAssign( vCube , vView , vMeasDim, vMeasSub ) ; FWIW, this is exactly what I've been doing in all my TI's...
by tomok
Wed Feb 20, 2019 2:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to rename a cube
Replies: 1
Views: 103

Re: How to rename a cube

The reason is that TM1 is not case sensitive for TM1 objects so it does not recognize your renamed cube as different. Why is this important? Because TM1 modifies the }Cubes dimension every time the server is restarted, taking out old and adding new. If you have renamed your cube then the old cube na...
by tomok
Fri Feb 15, 2019 8:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Basic Question - Tm1 service
Replies: 3
Views: 290

Re: Basic Question - Tm1 service

Each TM1 server service will be listed separately in Control Panel, Services. If you only stop one of them all of the others will still be running.
by tomok
Thu Feb 14, 2019 4:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Report in TM1web
Replies: 6
Views: 240

Re: Active Report in TM1web

kavitha2002 wrote:
Thu Feb 14, 2019 2:55 pm
Thanks tomok, for understanding my problem. I am not a expert in MDX, so writing a MDX in TM1RPTRow help to solve this problem?
What part of "There is no way around that" did you not understand?
by tomok
Thu Feb 14, 2019 1:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Report in TM1web
Replies: 6
Views: 240

Re: Active Report in TM1web

First off I wish you would dispense with the "one-sided" versus "two-sided" talk. That is not a TM1 concept and it is just making it hard to understand your problem. They are just some elements you created in a dimension. Looking at your screen shot from above I don't see a single row where every co...
by tomok
Sat Feb 09, 2019 11:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX StrToMember Error
Replies: 13
Views: 568

Re: MDX StrToMember Error

Is Write_Flag a text or numeric attribute? If it is numeric try changing it to a text attribute. STRTOMEMBER expects a string value.
by tomok
Mon Jan 28, 2019 6:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 42
Views: 4706

Re: Planning Analytics using twice the memory of 10.1

I'm guessing the css change is only going to be available to on-premise installations? We're going PA on the cloud this year and I would love to be able to alter the stylings for TM1web after we migrate.
by tomok
Mon Jan 28, 2019 6:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Focus when clicking an Excel file in Applications
Replies: 2
Views: 362

Re: Focus when clicking an Excel file in Applications

That issue didn't just crop up in PA. I've also seen it in 10.2.2 FP4. I've never heard of a TM1 setting you, meaning the customer, can alter to change this behavior. I'm not surprised that no else has an answer for you.
by tomok
Mon Jan 28, 2019 6:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Rule - Feeders for Current Rule
Replies: 1
Views: 281

Re: Tm1 Rule - Feeders for Current Rule

All a feeder does is flag a rule calculated cell as being non-empty so it doesn't matter how you derive the feeder as long as the end result is cells being fed where they should be. I would feed from Ending Rate:

Code: Select all

['Ending Rate'] => ['AverageCFYTDRate']
by tomok
Mon Jan 21, 2019 1:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sorting consolidations dynamically
Replies: 4
Views: 174

Re: Sorting consolidations dynamically

In the Dimension Editorovw the elements in the correct order. Then set the order of the indexes by clicking the last icon of the menu bar. This only works when you intend to maintain the dimension manually. If it is maintained by TI this will not work. Realistically, it's not practical unless these...
by tomok
Wed Jan 09, 2019 6:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing object access after copy from Prod to Dev
Replies: 8
Views: 426

Re: Missing object access after copy from Prod to Dev

I didn't say DELETE them. I said EXCLUDE them from the copy so that those two objects on dev will not be touched during the copy down. You can't copy prod client to dev because you're using native TM1 for one and CAM for the other. Leave the CAM users alone and it should work fine, although you may ...
by tomok
Wed Jan 09, 2019 3:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing object access after copy from Prod to Dev
Replies: 8
Views: 426

Re: Missing object access after copy from Prod to Dev

I have system A that have: 1) TM1 native login in Prod 2) Cognos authentication method in Dev Given these facts, I don't see how you can expect to copy from Prod to Dev and have it work UNLESS you specifically EXCLUDE the }Clients dimension and the }ClientGroups cube because the clients in a native...
by tomok
Mon Dec 17, 2018 4:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives - Prompt when closing Excel?
Replies: 6
Views: 326

Re: TM1 Perspectives - Prompt when closing Excel?

Closing all open Excel workbooks does not cause open TM1 boxes to close. I just verified that. Closing Excel itself does cause all open TM1 objects to close. What do you expect? Perspectives is an Excel ad-in. No Excel then no Perspectives. Also, if you have changed a view, or subset, then you will ...
by tomok
Fri Dec 14, 2018 5:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to import a CSV file to a cube with two extra dimensions
Replies: 5
Views: 914

Re: How to import a CSV file to a cube with two extra dimensions

Whoever made the decision to load to all the members of the non-represented dimensions does not understand TM1 and the consequences of that. Standard practice is to create a member in each of these dimensions called "No account", or "No Cost Center", etc., and load the data there.