Search found 2516 matches

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

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

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: 7
Views: 140

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

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

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

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

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

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

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

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

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

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

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

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

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

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.
by tomok
Thu Dec 13, 2018 5:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 SAP Connector on 10.2.2 and PAX
Replies: 2
Views: 460

Re: TM1 SAP Connector on 10.2.2 and PAX

I'm pretty sure the TM1 SAP Connector is no longer a product offered by IBM. I think that is part of the TM1 Package Connector, which I have never used.
by tomok
Thu Dec 13, 2018 2:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Holds via a Ti
Replies: 7
Views: 307

Re: Holds via a Ti

Yes, I can confirm that I thought the user was talking about a lock and not a hold, which is why I gave that example. My mistake. I wasn't being presumptuous, just guilty of not paying complete attention to the user's question.
by tomok
Wed Dec 12, 2018 7:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Holds via a Ti
Replies: 7
Views: 307

Re: Holds via a Ti

Of course you can do this via TI. You just need to CELLPUTS the name of the ID to hold the lock to the }ElementProperties cube, like this:

Code: Select all

CUBELOCKOVERRIDE(1);
CELLPUTS('admin', sPropertiesCube, pElement, 'LOCK');
by tomok
Tue Dec 11, 2018 6:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Notepad++ 7.6 for TM1 process and Rules
Replies: 17
Views: 893

Re: Notepad++ 7.6 for TM1 process and Rules

The fact that you have to bounce the server in order to use any of the TI code changes you make in Notepad++ make it a non-starter for me. That negates any benefit you get from a better search and replace, etc. I haven't seen the new TI editor in PA but it can't possibly be worse than what has been ...