Search found 247 matches

by Mark RMBC
Thu Jun 10, 2021 10:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Mdx to get 2 years date
Replies: 5
Views: 968

Re: Mdx to get 2 years date

Hi, If you held these start and end timeperiods in say an Admin cube, then something like the following mdx should work (I assume an admin cube with 2 dimensions), FILTER({TM1FILTERBYLEVEL({TM1SUBSETALL([Timeperiod])}, 0)}, [Timeperiod].Currentmember.Properties('fiscalyearno') >= [Admin].([Versions]...
by Mark RMBC
Fri Apr 16, 2021 11:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Break function
Replies: 8
Views: 768

Re: Break function

Hi Wim,

so the code below also leads to an endless loop?

Code: Select all

 c = 1;
 While( c > 0 );

	If( 'X' @= 'Y' );
           Sleep(100);
	   Break;
	EndIf;

	c = c + 1;

	If( c > 3 );
	   Break;
	EndIf;
 End;

Interesting it doesn't for me.

Mark
by Mark RMBC
Fri Apr 16, 2021 9:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Break function
Replies: 8
Views: 768

Re: Break function

Hi Wim,

I use Break too, so this is good to know.

If you put Sleep (100) before the first Break does this resolve it?

Interestingly adding an asciioutput into both IF statements outputs 2 files if a break statement is there.

regards,

Mark
by Mark RMBC
Wed Mar 17, 2021 9:12 am
Forum: Useful code, tips and tricks
Topic: Checkboxes for "flag" measures in TM1
Replies: 8
Views: 3749

Re: Checkboxes for "flag" measures in TM1

Hi, I use checkboxes a lot in TM1 web for filtering views, confirmations before running TI's and sending data back to cubes. I was also struck that in PAW this was not available. I was thinking along the lines of a new set of shape objects called Control Shapes or something, but actually a data form...
by Mark RMBC
Thu Mar 11, 2021 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX question
Replies: 10
Views: 1381

Re: MDX question

This gets a thumbs up from me too. Just to illustrate what Declan said about the trick being tm1member and Tail, this would work too: LASTPERIODS(99, TM1MEMBER( TAIL( FILTER( [Manad].[Total Year].children, NOT(ISEMPTY([cubename].([z.TestRowEntryList].[R01])))), 1).item(0), 0)) But I would certainly ...
by Mark RMBC
Thu Feb 11, 2021 1:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IIF statement in MDX
Replies: 1
Views: 311

Re: IIF statement in MDX

Hi, I will be honest I couldn't quite tell what you are looking for, as your post confused me a little. However if I focus on this line: What I want to do is show up elements of Type A if they existenet f they dont show up elemnt of type B if they exist else show up In which case something like the ...
by Mark RMBC
Thu Dec 24, 2020 10:24 am
Forum: General
Topic: For anyone who has been depressed by the train wreck that was 2020...
Replies: 4
Views: 3299

Re: For anyone who has been depressed by the train wreck that was 2020...

Merry Christmas to all!

And hopefully a Happy New Year
by Mark RMBC
Thu Nov 19, 2020 11:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form rebuild removes MDX in subset
Replies: 2
Views: 526

Re: Active form rebuild removes MDX in subset

Hi, Like Tomok this makes little sense to me without more information. One thing I would point out is that I notice in your MDX you have a cube name, RC_UBZ_PC and a dimension with exactly the same name. I have seen where a cube and dimension have the same name it messes with MDX, however it usually...
by Mark RMBC
Thu Sep 10, 2020 3:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form hell
Replies: 29
Views: 3092

Re: Active form hell

Hi Wim,

All I can say is it wasn't me!

regards, Mark
by Mark RMBC
Thu Sep 10, 2020 3:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form hell
Replies: 29
Views: 3092

Re: Active form hell

Hi Wim, No because you only have one year in each example. In your original rolling 13 you had 2 years in the columns. Try 2 years and put the value in a month that you don't include on the report, so have Y1 and Y2, Jan and Feb but put 5999 in March. That way you sort of replicate your original pro...
by Mark RMBC
Thu Sep 10, 2020 2:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form hell
Replies: 29
Views: 3092

Re: Active form hell

Hi Wim, your original had only 13 rolling months, so if some there was data in any month in the same year but not part of the 13 months then you would see extra rows, even though the months were not in the columns. But in your new example you have 2 years worth of data and every month, and because t...
by Mark RMBC
Thu Sep 10, 2020 1:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form hell
Replies: 29
Views: 3092

Re: Active form hell

Hi Wim, But it worked surely because those rows are the only rows to have values in any month in the years selected (i.e. 2020, 21 and 22)? the other rows disappear because they have no values in any of those months? Which is why your post 2 up just confused me and I didn't respond! This bit really ...
by Mark RMBC
Fri Sep 04, 2020 8:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form hell
Replies: 29
Views: 3092

Re: Active form hell

Hi Wim, I am not aware this has ever worked differently, though happy to be corrected. So not sure if I would say you have been lucky, more possibly you have not had a form set up which exposes this limitation? But as I said if you create your view in the cube viewer and supress zero rows you would ...
by Mark RMBC
Fri Sep 04, 2020 8:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form hell
Replies: 29
Views: 3092

Re: Active form hell

Hi Wim, Not sure I follow you, the 24 column workaround does not involve deleting any columns. That workaround basically throws the 13 rolling period out of the window and settles for 24 columns each and every time. Because what you are trying to do can only, as far as I know, be achieved by followi...
by Mark RMBC
Fri Sep 04, 2020 8:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form hell
Replies: 29
Views: 3092

Re: Active form hell

Hi Wim, Tomok is correct of course. One dimension would solve this. Or forgetting 13 periods and settling for any given 2 years, possibly conditional formatting the columns you want to focus on. I.e. some other workaround. The reason you are seeing Product 1,2 and 3 must be because there is a value ...
by Mark RMBC
Mon Jul 13, 2020 5:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Reports ver 2.0.9 - data misaligned
Replies: 3
Views: 1012

Re: Active Reports ver 2.0.9 - data misaligned

Hi, I have found that if the TM1RPTROW column order on the report does not follow the column order of the cube then it gets misaligned. Appears to be a bug in later releases. It should be noted that it does work ok on the web even if it doesn't work in excel. If you do need to work within excel then...
by Mark RMBC
Mon Jul 13, 2020 4:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Expand function with numbers
Replies: 13
Views: 2745

Re: Expand function with numbers

Hi Wim, I feel like you have pulled the 5 card trick here, in your first comment you reference nStart but never expand nStart but in your latest example you expand N both times. So the issue with your original problem has nothing to do with decimal places and expand does it? The problem is you cant ...
by Mark RMBC
Fri Jul 10, 2020 12:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculate minutes
Replies: 10
Views: 1863

Re: Calculate minutes

Hi Orlando, Well, assuming you want to calculate the difference in minutes between 2 dates, then TIMVL isn't going to help you as far as I can see. Though maybe you could have put something like that in the topic title :D Here is how I would approach it: I would break the value down between the date...
by Mark RMBC
Tue Jul 07, 2020 7:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: STR(Num, len, dec) with only one argument
Replies: 11
Views: 2396

Re: STR(Num, len, dec) with only one argument

I am more from the Treble Ctrl C, as I always think you need an extra one for luck! :)
by Mark RMBC
Mon Jul 06, 2020 12:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: STR(Num, len, dec) with only one argument
Replies: 11
Views: 2396

Re: STR(Num, len, dec) with only one argument

Whilst you are making the RFE could you suggest they change the function name to something a bit longer as I don't have enough typing to do? lol! I have always wanted some function aliases in TM1 but was too afraid to ask! So NumberToString could be NTS for example. That would have saved soooo much...