Search found 587 matches
- Thu Dec 08, 2022 3:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX escape special character
- Replies: 7
- Views: 4704
Re: MDX escape special character
After reading the link Wim provided, I have to say it makes a good point about not using the shortcut. I have used both the cube query and the short cut although most of the time I've used the shortcut syntax. Will probably adjust that going forward as it is more clear using the cube query. Also on...
- Tue Dec 06, 2022 10:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX escape special character
- Replies: 7
- Views: 4704
Re: MDX escape special character
Thanks PavoGa, for my own MDX I rarely use the ".CurrentMemember.Properties", can you advise when it should be used? After reading the link Wim provided, I have to say it makes a good point about not using the shortcut. I have used both the cube query and the short cut although most of th...
- Tue Dec 06, 2022 3:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX escape special character
- Replies: 7
- Views: 4704
Re: MDX escape special character
If you're filtering by an attribute string, you don't need to use StrToMember, the below should work assuming no typos on my part. FILTER( TM1SubsetAll([investmentID]), [investmentID].[creation_date] = [SysParameters].([Parameters].[sCurrentYear], [sysParameterMSR].[sDate] ) This can be refined and...
- Thu Jul 14, 2022 4:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX oddity on }Cubes dimension
- Replies: 6
- Views: 1202
Re: MDX oddity on }Cubes dimension
Hi, I tried on a later version (11.8.1200) and on a completely different windows server, and on a complex model, and it still works fine for me. Maren Thank you again for confirming it does work. Just do not know why it is not working here for me. :roll: ***UPDATE*** Okay, I have been sleep walking...
- Thu Jul 14, 2022 1:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX oddity on }Cubes dimension
- Replies: 6
- Views: 1202
Re: MDX oddity on }Cubes dimension
Same. I spun up a PA model that only has four cubes in additional to the control ones. Forget the fragment with the filter, the GENERATE code does not work either and it is dealing strictly with the two dimensions. It fails in both a 10.2 instance and in a PA one. The PA is the most recent version a...
- Thu Jul 14, 2022 7:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX oddity on }Cubes dimension
- Replies: 6
- Views: 1202
Re: MDX oddity on }Cubes dimension
Thanks, Maren.
The test in PA was against a very simple model. What client did you test with? Wonder if that could be the problem as I was using Architect?
The test in PA was against a very simple model. What client did you test with? Wonder if that could be the problem as I was using Architect?
- Thu Jul 14, 2022 1:33 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX oddity on }Cubes dimension
- Replies: 6
- Views: 1202
MDX oddity on }Cubes dimension
I ran into this problem and a search did not turn up anything quite like it. In short, I use copies of }Cubes and }Dimensions to actually work with ( sys.Cubes and sys.Dimensions respectively), and wanted to create an MDX subset on sys.Cubes that filtered out cubes that were flagged <> YES for "...
- Thu Jun 09, 2022 3:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Numeric parameter in TI MDX
- Replies: 7
- Views: 1686
- Wed Jun 01, 2022 5:26 pm
- Forum: Useful code, tips and tricks
- Topic: TM1 / Planning Analytics - MDX Reference Guide
- Replies: 11
- Views: 21685
Re: TM1 / Planning Analytics - MDX Reference Guide
Good work, George!
- Wed Jun 01, 2022 4:47 pm
- Forum: Useful code, tips and tricks
- Topic: MDX - Intrinsic Members
- Replies: 12
- Views: 16422
Re: MDX - Intrinsic Members
Good stuff! Some of these I've looked for, especially the MEMBER_ORDINAL.
- Fri May 13, 2022 7:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: The AWS Cloud no good, very bad performance
- Replies: 13
- Views: 3275
Re: The AWS Cloud no good, very bad performance
An update: pay attention to the processor speed. While the RAM and cores were equivalent, switching to another AWS with faster processors resolved the issues. Faster now than the on-prem server was. I was not directly involved with the setup, but did devise several tests measuring performance. Thank...
- Thu May 12, 2022 7:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: The AWS Cloud no good, very bad performance
- Replies: 13
- Views: 3275
Re: The AWS Cloud no good, very bad performance
The AWS server must have slower cores in it then or being throttled in some way? I'm not on the team working on the infrastructure, but I have asked that question as I think George mentioned it earlier. I'm told they do not believe there is any throttling occurring. One other thing: is the "no...
- Wed May 11, 2022 3:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: The AWS Cloud no good, very bad performance
- Replies: 13
- Views: 3275
Re: The AWS Cloud no good, very bad performance
Further update:
Running a TI with a simple loop (1-15,000,000) takes about 45% longer, on average, on the AWS than the on-prem server.
Running a TI with a simple loop (1-15,000,000) takes about 45% longer, on average, on the AWS than the on-prem server.
- Tue May 10, 2022 11:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: The AWS Cloud no good, very bad performance
- Replies: 13
- Views: 3275
Re: The AWS Cloud no good, very bad performance
Got a client looking to go this way too, so jumping in to keep an eye. The one thing I always look to is how your connection is made. From your corporate network vs home (Fibre/4/5G) Have found that corporate IT often throttle traffic they do not know and limp it into lead class, quality of service...
- Tue May 10, 2022 3:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: The AWS Cloud no good, very bad performance
- Replies: 13
- Views: 3275
- Mon May 09, 2022 4:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: The AWS Cloud no good, very bad performance
- Replies: 13
- Views: 3275
Re: The AWS Cloud no good, very bad performance
If the type and number of cores is the same I would suspect hard drive issues, i.e., SAN. Are you sure your drive space is in the same region as your server? Even in cube to cube copies TM1 is going to utilize drive space in the memory temp file. As to Architect, at least from an Admin standpoint, ...
- Mon May 09, 2022 3:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: The AWS Cloud no good, very bad performance
- Replies: 13
- Views: 3275
The AWS Cloud no good, very bad performance
We have just moved our development from on-prem servers to the AWS Cloud. The performance is, to be kind, lacking. The processes that move data from one slice of a cube to another are taking roughly double or more the amount of time to perform the same tasks. Running TIs side-by-side for the two env...
- Fri Apr 08, 2022 8:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dependent dynamic picklist not recalculating
- Replies: 12
- Views: 2279
Re: Dependent dynamic picklist not recalculating
Yeah, I've got my doubts on this one...Wim Gielis wrote: ↑Fri Apr 08, 2022 8:43 pm
It has been suggested before to have a kind of MDX option in SUBNM and picklists but alas, it's not there.
Still very interested whether Ty can make this work in MDX only !
- Fri Apr 08, 2022 3:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dependent dynamic picklist not recalculating
- Replies: 12
- Views: 2279
Re: Dependent dynamic picklist not recalculating
Hi all, I am working on a loan model. The goal is to create a dropdown for end month, containing only periods later than the start date (see screenshot). I have a loan cube with two dimensions: loan name and Loan Input Parameters. I have a picklist cube where I reference the below subset. {FILTER(T...
- Thu Apr 07, 2022 8:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Assigning alias to subsets?
- Replies: 8
- Views: 2169
Re: Assigning alias to subsets?
The issue will be that the list of subsets down in the data tree and in the set editor will show the principal/technical name. Users would want to see the friendly name when working in views/sets. At least that is how I understood the OP’s issue. Yes, two subsets would not be optimal for sure. We h...