Search found 1522 matches

by declanr
Sun Aug 27, 2017 5:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Applying 2 rules to one item
Replies: 4
Views: 683

Re: Applying 2 rules to one item

TM1 rules apply in order, so if the first (more specific rule) is higher up in the rule sheet - that is the one that will apply. The second rule will only apply to cells that are not effected by the first rule statement.
by declanr
Sun Aug 27, 2017 1:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Applying 2 rules to one item
Replies: 4
Views: 683

Re: Applying 2 rules to one item

Your first rule applies to N level elements only but you have consolidated elements selected in your view (such as all storage locations) that means the cell in question is not N level so the second rule which applies to N and C level takes effect instead. If you change your view so all elements are...
by declanr
Thu Aug 24, 2017 5:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule consolidation Issue
Replies: 6
Views: 728

Re: Rule consolidation Issue

Your rule is pulling from prior month so you need to alter your feeder to push to the next month. Currently you are feeding the same month.
by declanr
Tue Aug 15, 2017 5:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Coppy data within a cube
Replies: 3
Views: 582

Re: Coppy data within a cube

Some of your viewsubsetassigns have quotes around the subset variable, remove them and it should work. With quotes it is trying to use the literal string instead of evaluating it to the subset name.
by declanr
Sat Aug 12, 2017 5:13 pm
Forum: Useful code, tips and tricks
Topic: TM1Web Websheet Charts / Graphs not rendering
Replies: 9
Views: 2096

Re: TM1Web Websheet Charts / Graphs not rendering

Haven't had a chance to do a proper test but had a look at a sheet I created for one of the models I am working with at the moment, when Infirst created it they were on an early FP of 10.2.2 (1 or 2) now they are on FP7 and it still works ok. The part I had incorrectly remembered was that you do nee...
by declanr
Thu Aug 10, 2017 9:19 pm
Forum: Useful code, tips and tricks
Topic: TM1Web Websheet Charts / Graphs not rendering
Replies: 9
Views: 2096

Re: TM1Web Websheet Charts / Graphs not rendering

To add to this I have seen a similar thing but in my experience you can get away with some hiding but you need a good but varying number of visible rows. So I have had it work where there is a chart (or charts) a number of hidden rows of data (that the chart is based on) then say 20 visible but empt...
by declanr
Thu Aug 10, 2017 6:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Size
Replies: 11
Views: 1501

Re: Cube Size

Well the syntax would be: ['Price'] => DB (IF(['Price'] > 0 , 'Destination Cube', ''), !Dim1, !Dim2, !Dim3, 'Price'); But if price is zero it wouldn't trigger a feeder anyway so it doesn't need to be conditional. Also you normally wouldn't feed to or from price as you don't need them to add up and i...
by declanr
Fri Aug 04, 2017 10:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form and read only element
Replies: 9
Views: 633

Re: Active form and read only element

I have used cell security a fair few times without any noticeably terrible performance impacts but that being said I only ever need to put them on planning cubes and I very rarely have "large" planning cubes, as I tend to design away from that as much as possible.
by declanr
Fri Aug 04, 2017 9:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form and read only element
Replies: 9
Views: 633

Re: Active form and read only element

Active forms can have security applied in 2 ways; the first is through standard TM1 security, this one will also apply in cube views. The second less used option is simple excel cell protection; I wouldn't recommend this but if you changed your formula in column A to include something like; if these...
by declanr
Thu Aug 03, 2017 10:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding element to a dimension at run time in TI
Replies: 7
Views: 654

Re: Adding element to a dimension at run time in TI

Are you sure about that Declan ? If an element exists as C and you try to insert the same element as N, nothing happens. Sorry you are correct about this, a dimensionelementinsert statement is completely ignored if the element already exists. I should have said if you do dimensionelementdelete and ...
by declanr
Thu Aug 03, 2017 9:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding element to a dimension at run time in TI
Replies: 7
Views: 654

Re: Adding element to a dimension at run time in TI

I always just use dimensionelementcomponentadd without first doing an insert when it's for n level elements. TM1 will always make an element be an N level if it is put through a dimensionelementcomponentadd and doesn't already exist. The only time it will be a C level is if it already existed before...
by declanr
Tue Jul 25, 2017 9:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders for Rules
Replies: 6
Views: 785

Re: Feeders for Rules

['Global Margin', Currency:'USD'] =N: ['Full Revenue'] - ['INC Standard Cost']; If you feed a rule that is a subtraction, you will have to feed from both parts of the subtraction. I dint understand here , all i know is if there is a value for full revenue then feed global margin . How to feed from ...
by declanr
Fri Jul 21, 2017 9:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Concatenated string with Expand Function
Replies: 16
Views: 2211

Re: Concatenated string with Expand Function

Wim's suggested code should work well. I used the code ,no error on saving the TI , but when I run the process I get an error, the element vrollingroup1 Dimension element not found. What is the exact error you received? It may be a typo in the forum rather than the code but your variable suggests it...
by declanr
Thu Jul 20, 2017 9:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives hang when performing a slice or snapshot to Excel
Replies: 17
Views: 2995

Re: Perspectives hang when performing a slice or snapshot to Excel

Does the user have any other excel add-ins loaded? If so try disabling them all and then testing again.
I remember TM1 having issues with certain other add-ins previously but I can't really remember the exact issues experienced or which add-ins caused it.
by declanr
Wed Jul 19, 2017 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX which takes Value from Cube
Replies: 3
Views: 671

Re: MDX which takes Value from Cube

Code: Select all

{StrToMember("[Periods].[" + [CubeA].([Dim1].[Element1],[Dim2].[Element2],...) + "]" )}
by declanr
Mon Jul 10, 2017 7:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset present but with no code in its dimension process
Replies: 6
Views: 867

Re: Subset present but with no code in its dimension process

Just to add an extra thought to rule out the simplest answers; are you definitely deleting the subsets prior to running the TI and then it creates them? If not it could just be that they were created manually at some point in time. Sorry if this seems a stupid question to ask but we all miss the obv...
by declanr
Mon Jul 10, 2017 6:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CELLPUTN
Replies: 20
Views: 2734

Re: CELLPUTN

Jules, thank you so much for coming onto the forum on my request, I appeciate all the help you've given me. I have done both solutions and they both work. Again, thank you so much. Happy to hear that your problem has been solved. Just to offer an alternative to the rule approach to any future users...
by declanr
Fri Jul 07, 2017 6:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CELLPUTN
Replies: 20
Views: 2734

Re: CELLPUTN

Rules are a possible option but if it needs to be fed then doing so will at best be annoying and at worse a huge memory drain (due to likely over feeding.) On the TI approach I would avoid using the dimension index due to the issues mentioned above, even if the order is correct now it is easy for so...
by declanr
Thu Jun 29, 2017 9:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Default Element on TM1 Web Reports
Replies: 5
Views: 601

Re: Default Element on TM1 Web Reports

First of all it shouldn't "bomb out" if they don't have access; that's something worth looking at in more detail. But as to your actual question, for active forms you can make the title elements SUBNMs where instead of referencing an element it references an index number, so a 1 would return the fir...
by declanr
Thu Jun 22, 2017 6:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Web Form Date Format
Replies: 6
Views: 1060

Re: Web Form Date Format

Excel should be fine; this is something I first started implementing a while ago... think the express customer is still using excel 2007 or 2010 due to the whole awful process of installing CX back then meaning it had a hissy fit if it didn't detect what it deemed to be the correct version of excel ...