TM1 Forum

Hi thanks for the advice. the following works TM1SubsetToSet([dim01] , IIF(StrToMember("[dim02].["+[dim02].CURRENTMEMBER.PROPERTIES("att1")+"]").PROPERTIES("att2") = "xxx" , "subset_a" , IIF(StrToMember("[dim02].["+[dim02].CURRENT...

Thanks. I've tried that as well - since it says invalid MDX expression I thought of just putting the simplified version which represents the idea. TM1SubsetToSet([dim01] , IIF(StrToMember([dim02].CURRENTMEMBER.PROPERTIES("att1")).PROPERTIES("att2") = "xxx" , "subse...

Hello, I need help on getting this MDX to work In a cube view, I'm trying to set the values to be displayed for dim01, subjected to selection of dim2 element and attributes of the selected dim2 element CURRENTMEMBER.PROPERTIES work fine but CURRENTMEMBER.PROPERTIES().PROPERTIES() doesn't work. TM1Su...

Compared with formatting using NumberToStringEx which is rounding properly, wouldn't it make sense to not use ROUNDP? That would surely depend on the specifics, wouldn't it? Or did someone make you the rounding overlord? The format requested is two decimal. Given this real number 4283.775, may I as...

Thanks for the explanation. I pointed this out as interesting because the fact that TM1 is storing the value slightly higher or lower in float is what is causing the inaccuracy of rounding using ROUNDP. Well perhaps it is a no-brainer and I am guessing this is known to everyone (because I can't seem...

Guys, found out something earlier Try this: nNumber = 4283.775 nRounded = ROUNDP(nNumber, 2); sRounded = NumberToStringEx(nRounded, '#.00', '.', ''); ASCIIOUTPUT('D:\TM1\Log\test.txt', NumberToString(nNumber), NumberToString(nRounded), sRounded); You will get 4283.775, 4283.77, 4283.78 A colleague o...

PAW version: 2.0.53 Trying to find a way to make subset selection more user friendly. First thing first there are a lot of manually created subsets in this dimension, and as well as TI generated subsets. Users are ought to only select the TI generated ones, on top of that for each PAW book tab, they...

Thank you guys,
It works just fine!

Is it possible to create a picklist for element in }ElementAttribute_dim? For example, customer dim has string element attribute called 'gender', I want to control the input by allowing only 'F' or 'M' Its like element attribute of element attribute. I've tried creating a static one. a new dimension...

Thank you both. Will check with support and see if they patch this in any later version

That's the version for my personal use only.
This specific client having issue is using the stable version 2.0.9 with Excel 2013 - however, could not find any related fix on 2.0.9.5

Thanks,

I'm amending an active form to add row dimension (DimC) via TM1RPTROW. There are already two existing TM1RPTROW in the report. Things I have performed: 1. Remove TM1RPTTITLE for DimC out from TM1RPTVIEW 2. Adding TM1RPTROW before the two existing ones 3. Manually delete all the rows under TM1RPTROW ...