Search found 587 matches

by PavoGa
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...
by PavoGa
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...
by PavoGa
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...
by PavoGa
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...
by PavoGa
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...
by PavoGa
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?
by PavoGa
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 "...
by PavoGa
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

Re: Numeric parameter in TI MDX

gtonkin wrote: Wed Jun 08, 2022 5:26 pm This is sometimes a good case for the Expand() function.
No need to use NumberToString and fiddle with quotes.
Potentially easier to read too.
You beat me to it.
by PavoGa
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.
by PavoGa
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...
by PavoGa
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...
by PavoGa
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.
by PavoGa
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...
by PavoGa
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

Re: The AWS Cloud no good, very bad performance

lotsaram wrote: Tue May 10, 2022 7:47 am What type of AWS instance are you using?
I am not conversant on AWS instance types, but does x1e.2xlarge answer your question?
by PavoGa
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, ...
by PavoGa
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...
by PavoGa
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

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 !
Yeah, I've got my doubts on this one...
by PavoGa
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...
by PavoGa
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...