Search found 2538 matches

by tomok
Tue May 14, 2019 2:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: The TM1Web service parameter was not specified or is not one of the configured locations
Replies: 2
Views: 133

Re: The TM1Web service parameter was not specified or is not one of the configured locations

IBM has very specific and detailed instructions on their web site for where the various files should be placed on your Cognos Analytics and Cognos Gateway (if you have one) servers. Did you follow them to the letter? If you did and it still doesn't work I recommend you contact IBM Support and have t...
by tomok
Thu May 09, 2019 4:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Uploading a TM1 Application through the REST API
Replies: 3
Views: 965

Re: Uploading a TM1 Application through the REST API

I'm pretty sure that there aren't any functions in the REST API library for publishing Excel workbooks to the Application tree. I could be wrong. However, you don't have to be an Administrator per se to publish a workbook, you just have to have Admin rights to the spot in the application tree where ...
by tomok
Thu May 09, 2019 4:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Access denied to cells for non admin users in TI Logs
Replies: 3
Views: 146

Re: Access denied to cells for non admin users in TI Logs

Can anyone help me out. Thanks in advance.. All I can tell you is if the users can't see and/or change a value in the cube while an admin can then the user does not have adequate security to do so. I have no idea why because I know nothing about your models, security groups, and how the particular ...
by tomok
Tue May 07, 2019 8:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI - Add new element in alphabetical order under consolidation
Replies: 17
Views: 337

Re: TI - Add new element in alphabetical order under consolidation

Sheesh this ran a little off topic. But while I'm here ... DimensionSortOrder sets properties for a dimension; the dimension is not actually sorted until it is saved on the server. You don't need a SaveDataAll or for that matter CubeSaveData('}DimensionProperties') What the documentation is saying,...
by tomok
Fri May 03, 2019 6:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Analytics 11.0.13
Replies: 12
Views: 886

Re: Cognos Analytics 11.0.13

If the question was "The IBM install instructions aren't very good, does anybody else have a better set?" would you still have been as negative? Actually, no. It would indicate that the poster had made at least some attempt to find it on his own. If you look back at his posting history he asks a lo...
by tomok
Fri May 03, 2019 4:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Analytics 11.0.13
Replies: 12
Views: 886

Re: Cognos Analytics 11.0.13

Really? You don't even bother to search the IBM web site? You just automatically post on here hoping someone else will do it for you?
by tomok
Wed May 01, 2019 2:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Space
Replies: 7
Views: 307

Re: REST API: Space

I don't know the answer to your question but in SQL and MDX when you have blanks you have to encapsulate them in brackets. Maybe try
[Business Unit]???
by tomok
Wed Apr 17, 2019 8:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Days360 Tm1
Replies: 12
Views: 1076

Re: Days360 Tm1

How do you workout the number of full months between jan 10 2016 to jan 9 2021 . Divide the number of days between jan 10 2016 and jan 9 2021 by 30.4 and truncate the remainder. That integer amount will be the number of full months. This will work as long as the number of years between the two date...
by tomok
Wed Apr 17, 2019 1:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Days360 Tm1
Replies: 12
Views: 1076

Re: Days360 Tm1

How do you workout the number of full months between jan 10 2016 to jan 9 2021 . Divide the number of days between jan 10 2016 and jan 9 2021 by 30.4 and truncate the remainder. That integer amount will be the number of full months. This will work as long as the number of years between the two date...
by tomok
Fri Apr 12, 2019 12:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: calculating WTD, YTD and QTD with rules
Replies: 5
Views: 825

Re: calculating WTD, YTD and QTD with rules

What is the best way to calculate this in TM1 cube. Here's your simple answer. Don't. Time period calculations should almost always be done with a hierarchy in the Time dimension and letting the consolidation feature in TM1 take care of it. It will perform light years faster than a rule and you won...
by tomok
Wed Apr 10, 2019 10:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SwapAliaswithPrincipalName old name in sub and vue files
Replies: 3
Views: 146

Re: SwapAliaswithPrincipalName old name in sub and vue files

I'm pretty sure that the function SwapAliaswithPrincipalName is not smart enough to cycle through all your views and subsets and change them. All it does it update the dimension. You're on your own to figure out the best way to update the .sub and .vue files.
by tomok
Tue Apr 09, 2019 10:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel data loads and TM1runTI, Hustle
Replies: 11
Views: 1434

Re: Parallel data loads and TM1runTI, Hustle

Given that Hustle has to be installed on the server is anyone using it on the IBM Cloud?
by tomok
Fri Apr 05, 2019 11:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express Trial - Can someone provide me the installation?
Replies: 9
Views: 777

Re: Cognos Express Trial - Can someone provide me the installation?

IBM does not offer trial software for Planning Analytics, available to the general public. TM1 and Cognos Express, both no longer exist except to licensed users. The fact that those links you are talking about no longer exist should have given you a clue. Also, if you read the fine print in the tria...
by tomok
Fri Apr 05, 2019 1:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express Trial - Can someone provide me the installation?
Replies: 9
Views: 777

Re: Cognos Express Trial - Can someone provide me the installation?

That's just not going to happen from anyone on this board. What you are asking for is illegal BTW.
by tomok
Wed Mar 27, 2019 10:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Text formatting
Replies: 2
Views: 240

Re: Text formatting

orlando wrote:
Wed Mar 27, 2019 7:13 am
Hi spartan,

for TM1Web you are using Excel - so you can use "conditional formatting" for the red letters

regards
orlando
To clarify, this only works in a web sheet. You cannot change the formatting in the cube viewer.
by tomok
Mon Mar 25, 2019 4:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to restrict a user not to enter a value in the active form
Replies: 10
Views: 576

Re: How to restrict a user not to enter a value in the active form

So you have a text field that users can enter text in but there is one specific text string that no one should be allowed to enter???? That is quite a bizzare requirement and not surprisingly, IBM does not give you the capability to do that in an active form. The only way to restrict text input to s...
by tomok
Wed Mar 20, 2019 1:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1WEB 2.0.6 Number Issue
Replies: 7
Views: 320

Re: TM1WEB 2.0.6 Number Issue

I'm sorry about my post. It was actually a reply to a different question and I posted it on the wrong message.
by tomok
Tue Mar 19, 2019 5:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1WEB 2.0.6 Number Issue
Replies: 7
Views: 320

Re: TM1WEB 2.0.6 Number Issue

We have a problem with the websheets on IBM Cognos TM1 Web. After the update to the version 2.0.6 of Planning Analytics all the numeric values of our websheets don't follow anymore the format of the Dimension Editor (from Architect or Perspectives). They follow some regional settings of the browser...
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: 881

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

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.