Search found 1522 matches

by declanr
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: 420

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 ...
by declanr
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: 906

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.
by declanr
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: 906

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...
by declanr
Thu Jul 19, 2018 10:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Datasource Path
Replies: 43
Views: 10830

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...
by declanr
Mon Jul 16, 2018 7:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drop Down Calendar Selection
Replies: 21
Views: 6304

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...
by declanr
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: 726

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 ...
by declanr
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: 726

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" ) )}
by declanr
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: 126

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...
by declanr
Sun Jun 24, 2018 5:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Retrieving member name by alias
Replies: 10
Views: 466

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?
by declanr
Thu Jun 21, 2018 6:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with feeders
Replies: 7
Views: 346

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.
by declanr
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: 1000

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.
by declanr
Fri Jun 15, 2018 10:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Public Subset Alias Turned Off After Dimension Rebuild
Replies: 4
Views: 450

Re: Public Subset Alias Turned Off After Dimension Rebuild

Just rebuilding a dimension should not remove aliases from that dimensions subsets, if that is happening without any other actions then it would be a bug. What i expect is happening is that the TI to rebuild the dimension also destroys and recreates the MDX subset from scratch, in which case TM1 wou...
by declanr
Wed Jun 13, 2018 11:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Applications Custom Views
Replies: 4
Views: 488

Re: TM1 Applications Custom Views

You can have an attribute in the product dimension that holds the name of the BU that you want to show it for and then put MDX like below in the product dimension: {Filter({[Product].members},[Product].[BU]= [BU].currentmember.name )} In that example I have shown the Product dimension as being calle...
by declanr
Wed Jun 06, 2018 6:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process taking too much time to create a subset
Replies: 18
Views: 1622

Re: TI process taking too much time to create a subset

Ok, then I would do a bit of trial and error testing on 2 things: 1/ just create your subset with a simple while loop in your actual TI instead of bedrock 2/ just create the subset with MDX in your actual TI instead of bedrock - make static in the prolog as well 3 / leave the dimensions aith no subs...
by declanr
Tue Jun 05, 2018 9:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Same rules within the cube
Replies: 1
Views: 157

Re: Same rules within the cube

Do you mean that the cells in question now have no rules applied to them? As in the cell can be edited by typing into it? If so and the rule has only changed as you show to pull from 1 account instead of another then I would expect it is due to its position in the rule file and there is probably a S...
by declanr
Tue Jun 05, 2018 7:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process taking too much time to create a subset
Replies: 18
Views: 1622

Re: TI process taking too much time to create a subset

Assuming that your source view has skip consolidations enabled just dont create a subset and for that dimension leave the cube view with no subset assigned, it will default to just taking every element and due to having skip consolidations ticked it would only be n level elements.
by declanr
Wed May 30, 2018 8:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to set TM1 Perspectives to use Excel 2010
Replies: 1
Views: 172

Re: How to set TM1 Perspectives to use Excel 2010

If you navigate to the tm1p.xla file in the TM1 bin directory (you can get there by right clicking on your perspectives shortcut, "open file location" and then selecting "properties" on the file it takes you to - this will show the bin directory and file path.) On the tm1p.xla file right click and s...
by declanr
Wed May 30, 2018 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filter based on element value
Replies: 2
Views: 261

Re: MDX filter based on element value

You have a couple of issues here: 1/ [cbm_year] in the filter is something that it doesn't know what to do with - you would need to specify that it is the name from the currentmember you are wanting to use. 2/ Even then you would be comparing string with a number You could easily do it if you had a ...
by declanr
Mon May 28, 2018 6:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filtering by attribute for current user
Replies: 3
Views: 375

Re: MDX filtering by attribute for current user

You got pretty close and had all the constituent parts ready, the the below: {Filter( {[version].members}, [version].[created by user] = StrToMember ( "[}Clients].[" + UserName + "]" ).name ) } Edit - a second thought on how you are actually populating the attribute; maybe the attribute held against...
by declanr
Fri May 25, 2018 5:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Import data from SQL table into TM1 cube with user input
Replies: 4
Views: 331

Re: Import data from SQL table into TM1 cube with user input

Just have different measures for the user inputs as compared to the data load, then when the TI runs you just zero out the part it will load to and leave the rest of the cube alone.