Search found 1519 matches

by declanr
Thu Jul 19, 2018 10:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Datasource Path
Replies: 43
Views: 10407

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.
by declanr
Tue May 22, 2018 4:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error on view creation
Replies: 7
Views: 363

Re: Error on view creation

Hi, i've tried that but I face the same problem. The type error is different, but didnot work too. Thanks What was the different error message that it gave you? When you tried Pauls idea to copy from your dev environment, did you only copy the vue file? If the vue relied on subsets that didnt exist...
by declanr
Tue May 22, 2018 6:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error on view creation
Replies: 7
Views: 363

Re: Error on view creation

Or create the view in TM1 Web so you dont have to perform the migration.
by declanr
Mon May 21, 2018 9:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Block TM1 usage during upgrade / migration
Replies: 3
Views: 274

Re: Block TM1 usage during upgrade / migration

I had a similar requirement at one point that meant users needed to “lose” access during certain super user tasks, basically so they didnt see the work in progress that was a super uaer setting up the system - it was a long time ago but I basically had 2 TIs. One ran at the start which copied the }C...