Search found 1531 matches
- Fri Feb 15, 2019 9:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Basic Question - Tm1 service
- Replies: 4
- Views: 51
Re: Basic Question - Tm1 service
This service runs all of the "standard" web services; TM1 Web, TM1 Applications and Ops Console. It was renamed to this in Planning Analytics and as your question and the previous couple of replies show it is named rather deceptively, that being said it also at one point was called TM1 Excel Service...
- Tue Jan 29, 2019 9:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Workspace - What browser do you use?
- Replies: 1
- Views: 59
Workspace - What browser do you use?
Simple question to those who have been working with workspace, what browser do you use? Have you noticed performance differences between browsers? For the most part all the standard stuff seems to work in IE, Edge, Chrome and Firefox but I decided to have a screen where users input dates - this was ...
- Tue Jan 29, 2019 9:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW TI Editor
- Replies: 6
- Views: 254
Re: PAW TI Editor
I had in fact been thinking of proposing a similar question on here myself, due to the fact I have seen a lot of negative comments in other threads regarding both the TI Editor and Rules Editors available in workspace. My view of it with regards to your actual question is that even though workspace ...
- Sun Jan 27, 2019 5:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Viewer suppress zeroes hiding non-zero cells
- Replies: 11
- Views: 192
Re: Cube Viewer suppress zeroes hiding non-zero cells
There is a bug that one my customers currently has, I believe they are on PA 2.0.5 but not 100% as I don’t have access to install etc in their environment. The issue means that check feeders never shows “not fed” - I tested this with a simple a = b rule on a 2 dim cube. Again due to not having acces...
- Tue Jan 22, 2019 8:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Workspace - Synchronize Selection Widgets
- Replies: 0
- Views: 123
Workspace - Synchronize Selection Widgets
In Planning Analytics Workspace I have a book with multiple cubes that I want to synchronize from a single widget on the front page for store/country. Cubes which contain the store dimension should show the country and its children (stores). Cubes which contain the country dimension should show the ...
- Mon Jan 14, 2019 8:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action button conditional navigation
- Replies: 3
- Views: 263
Re: Action button conditional navigation
Does the action button also need to run a process? And does the user need to be able to change the value in the dbrws in the source? If the answer to both questions is no, then you can use the url api to make the dbrws hyperlinks - use the excel hyperlink formula - show the value as the display name...
- Sat Dec 01, 2018 11:26 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: One vs Two Time Dimensions
- Replies: 8
- Views: 738
Re: One vs Two Time Dimensions
What version are you on? If you have access to workspace I would go with a single time dimension but use alternative hierarchies so you can view it by 2 as well. Best of both worlds then. (Admittedly with a bit of extra maintenance but it’s theoretically easy enough when you get your head around tha...
- Fri Nov 30, 2018 8:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Database Insert
- Replies: 4
- Views: 737
Re: Database Insert
This isn't a TM1 thing as such, it's a SQL thing. If you try and do an insert statement in SQL directly you need to use a double apostrophe e.g. MEN''S STYLE in the insert statement and it will get into the database as you want it displayed MEN'S STYLE. This is particularly common with names etc - t...
- Sun Oct 21, 2018 1:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Applications Slow Performance
- Replies: 2
- Views: 347
Re: TM1 Applications Slow Performance
Setting up the web applications to run on a separate machine is fairly common in most companies and you certainly shouldn’t experience significant performance issues as a result of it. The most likely issue is simply that the machines you are using have a latency between them, have you tried to test...
- Wed Aug 15, 2018 1:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1RPTRow with MDX Expression that Returns zero elements
- Replies: 8
- Views: 938
Re: TM1RPTRow with MDX Expression that Returns zero elements
And users like to filter employees of a certain class or certain pay cycle ( and a few other text measures). So I have drop downs to allow to apply filters. Another option I have employed previously is to have each of these drop downs being driven by MDX themselves that only allow the user to pick ...
- Tue Jul 24, 2018 6:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to achieve the first login to TM1web to modify the personal password?
- Replies: 13
- Views: 1494
Re: How to achieve the first login to TM1web to modify the personal password?
The action button to set the password is also used to navigate to another web page if the process completes successfully.
So they don’t need to login again but instead just carry on with the normal homepage etc that they would have seen anyway.
So they don’t need to login again but instead just carry on with the normal homepage etc that they would have seen anyway.
- Mon Jul 23, 2018 2:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to achieve the first login to TM1web to modify the personal password?
- Replies: 13
- Views: 1494
Re: How to achieve the first login to TM1web to modify the personal password?
Due to there not being a way to force users to change their password on login automatically I have previously set up my own system when we were using mode 1 security and most users only had access to TM1 web. A process would run every night and copy the encrypted password to an attribute against the...
- Thu Jul 19, 2018 10:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic Datasource Path
- Replies: 43
- Views: 12826
Re: Dynamic Datasource Path
TIs don’t accept xls or xlsx etc rules as a source, it needs a flat file to read (CSV, CMA, TXT etc.) I believe performance modeller could accept excel files but I think that just had an additional program that converted it to a CSV first, you can do something similar yourself by having VBS executed...
- Mon Jul 16, 2018 7:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Drop Down Calendar Selection
- Replies: 21
- Views: 7488
Re: Drop Down Calendar Selection
UPD: The calendar picker works by default (for "date" number format) in PA 2.0, but only in PAW :( In TM1web, you still need to use picklists Hi Elessar, haven’t had a chance to check this but I know I’ve had it working in tm1 websheets - do you mean it doesn’t work in the cube viewer in TM1 web or...
- Wed Jun 27, 2018 9:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Is it possible to choose between subsets with IIF-statement in a MDX-subset?
- Replies: 5
- Views: 959
Re: Is it possible to choose between subsets with IIF-statement in a MDX-subset?
To be able to use currentmember you need the dimension that it refers to to be a title element, so you can only have 1 “business” selected at a time. I assume from your last comment you are trying to have the dimensions nested in which case it won’t work as each dimension can only apply 1 subset at ...
- Tue Jun 26, 2018 9:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Is it possible to choose between subsets with IIF-statement in a MDX-subset?
- Replies: 5
- Views: 959
Re: Is it possible to choose between subsets with IIF-statement in a MDX-subset?
Code: Select all
{TM1SubsetToSet ( [AT_Comparison], IIF ( [AT_Business].CurrentMember.Name = "Wholesaler", "Wholesales", "Store" ) )}
- Tue Jun 26, 2018 5:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: more generic style for rule area
- Replies: 1
- Views: 348
Re: more generic style for rule area
In terms of not having to manually enter element names on the LHS of your rule Inwould just have an if statement that says if the attribute is blank then continue else do what you need it to do. In terms of feeders and the actual rule it would largely be dependent on the real world application and w...
- Sun Jun 24, 2018 5:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Retrieving member name by alias
- Replies: 10
- Views: 985
Re: Retrieving member name by alias
A dimix enclosed within a dimnm should work across all interfaces, what interface are you using?
TI, rules, perspectives etc?
TI, rules, perspectives etc?
- Thu Jun 21, 2018 6:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Issue with feeders
- Replies: 7
- Views: 783
Re: Issue with feeders
I think there used to sometimes be an issue if the time stamp on the blb? generated by the advanced rules editor came out of sync with the rux file. It’s been ages since I have seen it so it’s a long shot but I do think I saw it on site with you guys so might be worth a look.
- Mon Jun 18, 2018 7:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using dimension PickList to filter data on import to cube
- Replies: 9
- Views: 1425
Re: Using dimension PickList to filter data on import to cube
In TM1 picklists are purely a user interface restriction, TI and/or rules can ignore them.
The only way around it is to place logic in the TI that performs the same function, so as its a dimension picklist you have mentioned you would have an If Dimix in the TI.
The only way around it is to place logic in the TI that performs the same function, so as its a dimension picklist you have mentioned you would have an If Dimix in the TI.