Search found 292 matches

by Mark RMBC
Mon Oct 23, 2023 12:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW How to make View Filters work together
Replies: 9
Views: 9133

Re: PAW How to make View Filters work together

Hi, I ran into this issue in 2021, as per this link on the IBM forum: https://community.ibm.com/community/user/businessanalytics/discussion/workspace-dynamic-mdx-in-dimension-dragged-outside-cube-view I was hoping for a synchronisation solution by now! having said that when you say, Sometimes simple...
by Mark RMBC
Wed Jun 28, 2023 7:56 am
Forum: Enhancements
Topic: DefineCalc Support in Websheets
Replies: 0
Views: 16669

DefineCalc Support in Websheets

Hi, I have started to use DefineCalc in custom reports and to my dismay they cannot be used in websheets, which means that for most of the organisations I know, where reporting is done via PAW and everything is done formally, DefineCalc is next to useless. It seems to have been designed with an acco...
by Mark RMBC
Mon Jun 19, 2023 1:47 pm
Forum: Enhancements
Topic: Enable ViewZeroOut against asymmetric MDX views.
Replies: 7
Views: 9959

Re: Enable ViewZeroOut against asymmetric MDX views.

Hi Steve, Oh agreed, the IBM solution is so simple as to be useless but it does give the starting point to try and come up with some clever looping/cube solution. Obviously your RFE is the not only desirable but pretty essential given how Planning Analytics has developed over the last few years. reg...
by Mark RMBC
Fri Jun 16, 2023 2:17 pm
Forum: Enhancements
Topic: Enable ViewZeroOut against asymmetric MDX views.
Replies: 7
Views: 9959

Re: Enable ViewZeroOut against asymmetric MDX views.

Hi Steve, Sorry missed your reply from the 30th May: Something that's not clear in the explanation I had or your one, is if it is actually possible to refactor the MDX such that what we want to do is possible? I think not but would be happy to be wrong.... Well, I would say yes and no. No in that yo...
by Mark RMBC
Mon May 15, 2023 12:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Virtual Machine configuration and PA
Replies: 7
Views: 2179

Re: Virtual Machine configuration and PA

Hi, I raised a case (TS012607330) recently re the Planning Analytics Admin agent and high cpu usage on some of our environments (but not all environments). They advised us after providing all relevant logs and other information, to check "Power setting in OS , BIOS and Hypervisor (if this is VM...
by Mark RMBC
Fri May 12, 2023 4:21 pm
Forum: Enhancements
Topic: Enable ViewZeroOut against asymmetric MDX views.
Replies: 7
Views: 9959

Re: Enable ViewZeroOut against asymmetric MDX views.

Hi, I raised an issue view ViewCreateByMDX and ViewZeroOut with IBM some time ago. After a long and protracted period of time, this was their ultimate response: After discussing this with my internal team I would like to provide you an explanation that this works by design. Due to the current way th...
by Mark RMBC
Fri Jul 01, 2022 10:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: mdx replace value with excel coordinate
Replies: 5
Views: 1673

Re: mdx replace value with excel coordinate

Cheers Wim, I wasn't aware of the mystery 3rd parameter, and useful to know.

I should have read George Tonkin's MDX guide a bit more closely! That one went right over my head.
by Mark RMBC
Fri Jul 01, 2022 9:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: mdx replace value with excel coordinate
Replies: 5
Views: 1673

Re: mdx replace value with excel coordinate

Hi,

Just for info, I have moved away from using TM1FILTERBYPATTERN because it can't handle aliases.

The following topics describe the issues, and the workarounds using the INSTR function.

regards,

Mark
by Mark RMBC
Wed Jun 08, 2022 4:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Numeric parameter in TI MDX
Replies: 7
Views: 1654

Re: Numeric parameter in TI MDX

Hi keith,

I deleted my comment as I knew it was wrong. It has been a long day!

I was going to suggest you numbertostring pPayrollPeriodNumber but I think you are now saying it works ok.

regards,

Mark
by Mark RMBC
Wed Apr 27, 2022 8:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX in ActiveForm with "INSTR" does not work
Replies: 11
Views: 13123

Re: MDX in ActiveForm with "INSTR" does not work

Hi Wim,

the more relevant topic is this one, as this is the topic that I think triggered George's post on the community:

https://www.tm1forum.com/viewtopic.php?t=16193

regards,

mark
by Mark RMBC
Wed Apr 27, 2022 8:02 am
Forum: Useful code, tips and tricks
Topic: MDX - Using VAL instead of StrToValue
Replies: 2
Views: 9587

Re: MDX - Using VAL instead of StrToValue

Hi George,

Another wow from me! Just wished you had shared this like 5 years ago!

I knew about all the others except the VAL, though I don't see much need to use UCASE and LCASE since you pointed out the 4th parameter of INSTR could be used to turn off case sensitivity!

regards,

Mark
by Mark RMBC
Thu Apr 21, 2022 8:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX wildcard filter based on cube value
Replies: 9
Views: 2160

Re: MDX wildcard filter based on cube value

Hi, You could also skip the additional excel cell and just put lcase around A2 also (in the MDX formula) - just for the benefit of keeping all of the "logic" in 1 place. Oh yeah! ;) Just did a quick test. You are right, PAW is completely case insensitive and accepts upper or lower case for...
by Mark RMBC
Thu Apr 21, 2022 8:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX wildcard filter based on cube value
Replies: 9
Views: 2160

Re: MDX wildcard filter based on cube value

Hi, One small wrinkle though if the lookup cell value is bob (lower case) instead of Bob this doesn't work. I'd have to account for users typing in either I imagine. for PAX sheet, imagine cell A1 contains the search text, e.g. Bob To cater for lower or upper or any case input by the users you can d...
by Mark RMBC
Thu Apr 14, 2022 2:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Learning TM1 / Planning Analytics
Replies: 10
Views: 3262

Re: Learning TM1 / Planning Analytics

Hi, I am going to play slight devils advocate in response to Tomok, even though I generally agree with his points. I tend to regard finance as the low hanging fruit when it comes to Planning Analytics. However, in my experience, and depending on the organisation, there is plenty of scope for utilisi...
by Mark RMBC
Fri Apr 08, 2022 11:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dependent dynamic picklist not recalculating
Replies: 12
Views: 2233

Re: Dependent dynamic picklist not recalculating

Hi, You may have to rethink this and create a subset for each New Loan, so let us say for each new loan you create a subset prefixed with EndMonths_ and then the name of the loan, e.g. New Loan 1 subset would = EndMonths_New Loan 1 The MDX in the EndMonths_New Loan 1 would be: {FILTER(TM1FILTERBYLEV...
by Mark RMBC
Fri Mar 25, 2022 9:59 am
Forum: Useful code, tips and tricks
Topic: Displaying custom error messages after running a process in PAW
Replies: 4
Views: 36315

Re: Displaying custom error messages after running a process in PAW

Hi,

Yes a very belated nice one from me too, except, as per the discussion below, the messages only display to Admin users.

https://www.tm1forum.com/viewtopic.php?p=79545#p79545

So really, about as useful as a chocolate fireguard!

regards,

Mark
by Mark RMBC
Thu Mar 24, 2022 8:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: FP&A Business Knowledge for TM1
Replies: 4
Views: 1586

Re: FP&A Business Knowledge for TM1

Hi, I worked in a finance business partnering service, where the main role was to actually do the budgeting and forecasting. As Ty said, no course can really beat that. I also worked in a finance systems section, where we had to look after/adminster the chart of accounts, among other things. This pr...
by Mark RMBC
Fri Mar 11, 2022 10:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Approaching project complexity
Replies: 15
Views: 3380

Re: Approaching project complexity

Hi, Just to keep you entertained until lotsaram shows up, here are my thoughts: I assume your questions relate to internal developers within an organisation (external consultancy firms would have differences) How do you take on TM1 projects initially? One of 2 ways: Boss informs you of a new require...
by Mark RMBC
Mon Feb 21, 2022 10:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW: Enable random selection of members to be passed to a TI
Replies: 6
Views: 1441

Re: PAW: Enable random selection of members to be passed to a TI

Hi John, You were not crystal clear but I am assuming you mean potentially multiple element selections from dimensions. For example, user might select product A, Year 2021 etc or they might select Product A, B, C and D and Year 2021 etc. Assuming this is your issue, I would normally tackle something...