What he said.
It doesn't matter if an area statement on the LHS uses an alias, when !dimension is used on the RHS it will always evaluate as the principal name. This is how it has always been and will always be.
At least you understand that using aliases on the LHS is a bad idea. Don't do this.
Search found 3504 matches
- Thu Dec 15, 2022 5:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Alias doesn't work in rule right hand side
- Replies: 4
- Views: 1764
- Wed Dec 07, 2022 9:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX escape special character
- Replies: 7
- Views: 4736
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 Nov 29, 2022 6:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Drill down in only a row
- Replies: 9
- Views: 3928
Re: Drill down in only a row
This kind of thing should be configurable and left in the hands of the user. FWIW I agree. Ideally there should be a toggle in the row dimensions area for symetric vs asymetric drill-down. As a user this is what I would want. But if I have to choose between one and the other then I would take asyme...
- Tue Nov 29, 2022 2:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Creating indented snapshots from cube views
- Replies: 6
- Views: 1042
Re: Creating indented snapshots from cube views
I think the short answer is that indenting to indicate parent/child relationships when exporting from TM1Web wasn't considdered necessary as part of the MVP and it has never been an important enough missing feature to revisit. That's probably unlikely to change.
- Tue Nov 29, 2022 2:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Drill down in only a row
- Replies: 9
- Views: 3928
Re: Drill down in only a row
How can I achieve the old Architect-behaviour in a PAW cube view? By default, a consolidation is just extended in the row I click. What if I want to extend it in all rows? You have chosen to wake up quite an old thread. Short answer, you can't. PAW only does asymetric drill-down. In general I think...
- Wed Nov 23, 2022 11:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Prop. Spread on calculated C-Element
- Replies: 6
- Views: 1263
Re: Prop. Spread on calculated C-Element
Spreading over a rule does work as long as at the leaf level there is only 1 independent variable. As you have more than one potential input to flex spreading can't be done.
- Mon Nov 14, 2022 9:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ATTRS rules in }ElementAttribute cube causes a TI to load data slowly in 2.0.9.15
- Replies: 6
- Views: 1726
Re: ATTRS rules in }ElementAttribute cube causes a TI to load data slowly in 2.0.9.15
We are experiencing a similar issue after applying 2.0.9.15 meaning we can't load attributes into our control cubes with rule files attached. A TI process that took a few seconds now takes so long it doesn't finish after running for several hours. Looks like this has already been reported to IBM. T...
- Mon Nov 14, 2022 8:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX view dimension order when used as a source to a TI
- Replies: 11
- Views: 2147
Re: MDX view dimension order when used as a source to a TI
(Just thinking out loud about solutions, not trying to say it isn't a problem....) For a certain level of complexity of MDX you could probably have a TI whose only job was to parse an MDX statement and figure out the contents. Can certainly see how this would be challenging / impossible for all pos...
- Mon Nov 14, 2022 8:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ATTRS rules in }ElementAttribute cube causes a TI to load data slowly in 2.0.9.15
- Replies: 6
- Views: 1726
Re: ATTRS rules in }ElementAttribute cube causes a TI to load data slowly in 2.0.9.15
Search for
[PH50635] TI process updating attributes has significant performance degredation if attribute cube contains rules
It might apply in your case.
I'm skipping 2.0.9.15 until this is fixed.
[PH50635] TI process updating attributes has significant performance degredation if attribute cube contains rules
It might apply in your case.
I'm skipping 2.0.9.15 until this is fixed.
- Thu Nov 10, 2022 6:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX view dimension order when used as a source to a TI
- Replies: 11
- Views: 2147
Re: MDX view dimension order when used as a source to a TI
I've not tried but can see how this could be generalised for any dimensioned cubes. All well and good if you can dictate the format of the query. If you can control the way the query is constructed then you can control the order of the variables. But what if the content of the MDX statement is unkn...
- Thu Nov 10, 2022 7:19 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX view dimension order when used as a source to a TI
- Replies: 11
- Views: 2147
Re: MDX view dimension order when used as a source to a TI
I can confirm that it is not fixed and certainly not ready to be used in anything generic where you cannot know upfront the variables that you will get in what order. This is very bad since cube views with PA alternate hierarchies are not accessible using traditional views. In a generic process I a...
- Wed Nov 09, 2022 5:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX view dimension order when used as a source to a TI
- Replies: 11
- Views: 2147
Re: MDX view dimension order when used as a source to a TI
Well it was discussed at length here https://www.tm1forum.com/viewtopic.php?p=73332&sid=ba5cbd3e85205d0af84de89c32557426#p73332 But I wouldn't call that recently. Well yeah this is my APAR https://www.ibm.com/support/pages/apar/PH24729 ... and according to IBM yes this was closed as "fixed&...
- Mon Nov 07, 2022 9:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: how to make a drillthough on a virtual hierarchy element?
- Replies: 10
- Views: 1407
Re: how to make a drillthough on a virtual hierarchy element?
You can only access alternate hierarchies through MDX views not traditional views. At this time drill-through only supports traditional views as the target and not MDX views. You can vote for the RFE to support MDX views in drill-through here https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOC-I-393 No...
- Thu Nov 03, 2022 1:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Subset Filter Elements By List of Attributes From Another Dimension
- Replies: 8
- Views: 1060
Re: Subset Filter Elements By List of Attributes From Another Dimension
Ah, I got it! I should be looping through the second dimension like such... GENERATE(FILTER(TM1FILTERBYLEVEL(TM1SUBSETALL([MMAP Versions]) , 0) , [MMAP Versions].CURRENTMEMBER.PROPERTIES("Vintage") <> "") , {STRTOMEMBER("[MMAP Vintages].[" + [MMAP Versions].CURRENTMEMB...
- Thu Nov 03, 2022 9:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Subset Filter Elements By List of Attributes From Another Dimension
- Replies: 8
- Views: 1060
Re: Subset Filter Elements By List of Attributes From Another Dimension
Should be possible. But you would need to use the Generate function.
- Tue Oct 18, 2022 10:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: rule line error runtime error :circular reference, evaluation stack
- Replies: 11
- Views: 1725
Re: rule line error runtime error :circular reference, evaluation stack
People usually pay me to fix that kind of problem. I feel like every time you have an issue, you post on this forum. Yeah dude seriously no one is going to read through that much code and provide you with a free answer (not even Declan). A circular reference is exactly what the error says it is. Fi...
- Wed Oct 12, 2022 1:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cases where MDX is a better alternative to cube rules
- Replies: 9
- Views: 2392
Re: Cases where MDX is a better alternative to cube rules
There are functions which MDX can deliver quite easily which TM1 rules either can't deliver unless you go back to 1st principles algebra (e.g. standard deviation) or where it simply isn't worth writing a separate rule for or for things like min/max/count/average where the relevance of the analysis i...
- Mon Oct 10, 2022 7:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cognos Disclosure Management
- Replies: 5
- Views: 1738
Re: Cognos Disclosure Management
CDM still works very well with TM1 as a data source. If you think it would be a good solution then suggest it to the client. Whether to accept the extra cost and licensing versus the benefits of the software is their decision not yours.
- Tue Aug 30, 2022 6:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Blank Rollup for Non-Admin user
- Replies: 3
- Views: 2209
Re: Blank Rollup for Non-Admin user
This looks like you have both element security on the Projects dimension where the users have at least READ access and cell security rules on the cube in question which are giving NONE access to the consolidations in the Projects dimension.
- Tue Aug 02, 2022 2:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Calculation inconsistency after using a DB
- Replies: 16
- Views: 2572
Re: Calculation inconsistency after using a DB
Hi Jorge, I think at some point you hgave transposed some 9s to 6s. Originally you say 4.769999999996 (but from the screenshot it is 4.7700000000999996). But then in a later post you quote 4.7666666669. This number can't be correct and if this is the case the difference (althoug as Wim says only 0.0...