TM1 Forum

Late but still a relevant response! I have not completed the Cubewise evaluation but I've been developing for about 4 years. I stepped into the mire of IBM's big shifts to their business model and development for Planning Analytics. It is fascinating to observe the product's evolution. The surface-l...

It was my programming background that led me to assume the processor aborted after a false condition. I should've written these rules more cautiously! I'll scoot the conditions within a nested IF or stagger them into separate IFs with CONTINUE. Thanks for the responses!

Examine the example rule below: [ 'Output Value' ] = N: IF ( DB ( 'ExampleCubeA' , 'ExampleElementA' ) = 0 % DB ( 'ExampleCubeB' , 'ExampleElementB' ) = 0 , 0 , CONTINUE ) ; There are two conditions to be evaluated. If the first condition evaluates FALSE, does the second condition get tested or does...

The documentation on VBA with PAfE is sparse but it does lay out a baseline to work from. It is not intended for users that rely on macro-recording to write their VBA. You'll need to know all those dirty details like procedures, object variables, scope, binding, etc… ¯\_(ツ)_/¯ That aside, you CAN wr...

You can barely imagine all the singing and dancing when working on the file. Beers and confetti all around. You should have seen it to believe. </20 ton squirrel mode=OFF> It would seem I'm getting a reputation on this forum. Meh, I'm shameless anyway. I'll own it. «attempts to </20 Ton Squirrel Mo...

You are correct. I use it if I need to find the last row that may be in use the work upwards, instead of settling on a constant e.g. 5000 rows. Your DCountA combined with this is what I was thinking to give you your last row. That's pretty clever for non-contiguous data, actually. Thanks, George!

My company's IT is the worst. Figures I'm two years behind and screwed for it. >__<

@GTonkin: If I recall correctly, xlCellTypeLastCell returns the very last cell in the worksheet's used range, even if you're calling that on a defined range it will return OUTSIDE of it. This would be useful if your data is isolated on the worksheet but might return unexpected results if you have da...

I don't have some of these functions like MAKEARRAY so the workbook "breaks" on me.

I run Office 365, Excel is version 2002 (build 14931.20274). I see everyone on the internet gabbing about MAKEARRAY and LAMBDA functions but I don't have 'em. Now I'm jealous.

I hadn't known about the SpillRange property, that's pretty awesome. Thanks, Wim! VBA is one of my most beloved and detested skills, I can't help but offer another tidbit for the situation. When dealing with ranges where I'm not sure about the size, I occasionally use COUNTA across what I know to be...

Thanks very much for this, Wim. I'll peek into it and give some feedback this week.

Thanks for taking a stab at this, ascheevel. The rational to use a List instead of TM1ELLIST was… My advisor is a veteran of TM1 but not of VBA, so he couldn't directly debug. I am the only VBA expert in my company, it is a tragically underrated skill. My steps seemed rational but the behavior was i...

«emits a high-pitched joyful squeal that shatters windows for miles around» THAT LINK IS EXACTLY WHAT I NEEDED. Holy carps, I should've searched further here. THANK YOU. I did, indeed make a long-winded post about the whole TM1ELLIST/refresh thing. I'd love to see your take on it, honestly. Thanks ...

Thanks for the response, ascheevel! I appreciate the link to the PAW API, that is now bookmarked. Based on what you describe, it doesn't seem calling the set editor from VBA is a good option. I'll just have the user manually click around to call it up. I was originally attempting to make a userform ...

Let's say I threw down a List object in a workbook linked to a dimension. To edit the set normally, one would activate the worksheet the list resides on and interact with the PAfE pane by clicking the wee arrow, then select Edit Set . Is it possible to call the set editor with VBA? I'm not seeing an...

I bounced this issue against someone with far more experience than myself, I will share this sage advice… Do not use TM1ELLIST, use the PAfE List object instead. This hamstrings the idea of using custom MDX to populate that list, however, it also eliminates the need for me to develop a custom VBA in...

You could also set up a number of subsets beforehand, just name each subset according to their selection. A TI process could do a one-time automation of that tedium.

Declan's response is far more efficient, though, I must admit.

I have completed the Cubewise Developer credential. As a team leader, if I were recruiting right now, I would choose someone that had completed this credential. @FlyingMum, would you take the Cubewise credential over the IBM credential? I'm curious how valuable the "baseline" credential i...

Have you tried calling RefreshSheet from the sheet with the TM1ELLIST? Sounds like it but just confirming. I do remember having an issue where objects did not refresh as it did not see the sheet as dirty. I *think* I may have dirtied the sheet through VBA. Try dirty the sheet manually then run the ...

Thanks, Wim & GTonkin, for your replies! (Sorry in advance for the TLDR response) Can you .Activate the sheet, refresh and .Activate back the original sheet ? It's not the nicest solution but might probably work. I haven't tested it. I attempted the Worksheet.Activate solution but my results wer...