Search found 292 matches
- 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: 9280
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...
- Wed Jun 28, 2023 7:56 am
- Forum: Enhancements
- Topic: DefineCalc Support in Websheets
- Replies: 0
- Views: 19111
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...
- Mon Jun 19, 2023 1:47 pm
- Forum: Enhancements
- Topic: Enable ViewZeroOut against asymmetric MDX views.
- Replies: 7
- Views: 11161
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...
- Fri Jun 16, 2023 2:17 pm
- Forum: Enhancements
- Topic: Enable ViewZeroOut against asymmetric MDX views.
- Replies: 7
- Views: 11161
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...
- Mon May 15, 2023 12:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Virtual Machine configuration and PA
- Replies: 7
- Views: 2234
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...
- Fri May 12, 2023 4:21 pm
- Forum: Enhancements
- Topic: Enable ViewZeroOut against asymmetric MDX views.
- Replies: 7
- Views: 11161
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...
- 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: 1744
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.
I should have read George Tonkin's MDX guide a bit more closely! That one went right over my head.
- 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: 1744
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
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
- Fri Jun 10, 2022 6:07 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic Reports, Asymmetric Column Headers, Excel and TM1 Web / PAW
- Replies: 9
- Views: 2193
Re: Dynamic Reports, Asymmetric Column Headers, Excel and TM1 Web / PAW
Hi,
think this was discussed in more depth here:
https://www.tm1forum.com/viewtopic.php?t=15488
regards,
Mark
think this was discussed in more depth here:
https://www.tm1forum.com/viewtopic.php?t=15488
regards,
Mark
- Wed Jun 08, 2022 4:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Numeric parameter in TI MDX
- Replies: 7
- Views: 1750
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
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
- 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: 13503
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
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
- Wed Apr 27, 2022 8:02 am
- Forum: Useful code, tips and tricks
- Topic: MDX - Using VAL instead of StrToValue
- Replies: 2
- Views: 10698
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
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
- 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: 2295
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...
- 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: 2295
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...
- Thu Apr 14, 2022 2:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Learning TM1 / Planning Analytics
- Replies: 10
- Views: 3593
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...
- Fri Apr 08, 2022 11:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dependent dynamic picklist not recalculating
- Replies: 12
- Views: 2377
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...
- 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: 37729
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
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
- 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: 1672
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...
- Fri Mar 11, 2022 10:03 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Approaching project complexity
- Replies: 15
- Views: 3639
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...
- 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: 1521
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...