Search found 260 matches

by PavoGa
Wed Nov 07, 2018 11:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules for multiple hierarchies
Replies: 0
Views: 52

Rules for multiple hierarchies

I need to be able, via rule, retrieve the value of a consolidation(s) in an alternate hierarchy for given elements. The consolidations may change their components over time. The component reference is stored as an attribute for the base element. The "current" hierarchy for a given version is stored ...
by PavoGa
Tue Nov 06, 2018 8:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchies and element attributes
Replies: 4
Views: 129

Re: Hierarchies and element attributes

Just noticed I failed to say thank you. Much appreciated, Paul.
by PavoGa
Wed Oct 31, 2018 12:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut with Hierarchies in PA2.0
Replies: 17
Views: 392

Re: ViewZeroOut with Hierarchies in PA2.0

Agree with everything you said Paul. I've already dealt with multiple hierarchies in the manner you discussed with prior TM1 versions on a limited basis. In this model, the business wanted to, as I indicated, maximize their flexibility. While some of the dims/hierarchies will change very little over...
by PavoGa
Tue Oct 30, 2018 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchies and element attributes
Replies: 4
Views: 87

Re: Hierarchies and element attributes

Is Alabama a leaf element? Leaves aren't unique and I think the values are actually stored against the Leaves hierarchy in the background to be shared between all hierarchies. Same named C elements however should be able to have different definitions and attribute values between different hierarchi...
by PavoGa
Tue Oct 30, 2018 12:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchies and element attributes
Replies: 4
Views: 87

Re: Hierarchies and element attributes

Hi Try HierarchyAttrPutS and see if that works better. I haven't tried it myself though. I am still sticking with the approach of having the same value in all hierarchies for the same element. Having different attributes for the same element in different hierarchies seems to me like it could cause ...
by PavoGa
Tue Oct 30, 2018 12:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchies and element attributes
Replies: 4
Views: 129

Re: Hierarchies and element attributes

Obviously you can build your own cube as a workaround... And that is pretty much the conclusion we reached as well, although we may consider adding attributes in the form of hiername_TheRealValue . We can easily enough, I think, handle that construction instead propagating numerous cubes to manage ...
by PavoGa
Tue Oct 30, 2018 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut with Hierarchies in PA2.0
Replies: 17
Views: 392

Re: ViewZeroOut with Hierarchies in PA2.0

Hi From my thinking, I tend to agree with lotsaram. I cannot see why you would want to have leaf level elements that only exist in a Hierarchy. I am genuinely interested to know what advantage that gives you? Long story short: the users want/need the ability to have a Wild, Wild West scenario with ...
by PavoGa
Tue Oct 30, 2018 11:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchies and element attributes
Replies: 4
Views: 129

Hierarchies and element attributes

It seems another issue has popped up where the hierarchy functionality is long on promise and wee bit short on delivery. I thought that ElementAttrInsert would generate an attribute that is managed/stored by hierarchy. For instance, say an attribute is created in dimname:hiername1 for Element X, I w...
by PavoGa
Mon Oct 29, 2018 7:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchies and element attributes
Replies: 4
Views: 87

Hierarchies and element attributes

It seems another issue has popped up where the hierarchy functionality is long on promise and wee bit short on delivery. I thought that ElementAttrInsert would generate an attribute that is managed/stored by hierarchy. For instance, say an attribute is created in dimname:hiername1 for Element X, I w...
by PavoGa
Mon Oct 29, 2018 7:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut with Hierarchies in PA2.0
Replies: 17
Views: 392

Re: ViewZeroOut with Hierarchies in PA2.0

What I don't understand is why you have leaf elements that don't exist in the "main" (same named) hierarchy. Even if they roll up to "Other" or "Unallocated" my 2c it's always best to have all leaves present in the main hierarchy. Long story as to why this is designed this way and too long to expla...
by PavoGa
Mon Oct 29, 2018 1:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut with Hierarchies in PA2.0
Replies: 17
Views: 392

Re: ViewZeroOut with Hierarchies in PA2.0

Hi I am not sure why you need to build an Other Elements consolidation. If you can identify the base level elements of the hierarchy, then you can just use those elements to directly build a subset on the main dimension and use that in ViewZeroOut. Exactly what Steve said. Due to some of the busine...
by PavoGa
Fri Oct 26, 2018 8:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HierarchySubsetElementDelete odd behavior
Replies: 4
Views: 184

Re: HierarchySubsetElementDelete odd behavior

By the way, HierarchySubsetElementDelete does work with this: sMDX = EXPAND('UNION({[%dimAccountsMaster%].[%hierAccountsForecast%].currentmember}, TM1FILTERBYLEVEL(TM1SUBSETALL([%dimAccountsMaster%].[%hierAccountsForecast%]), 0), ALL)'); HierarchySubsetCreate(dimAccountsMaster, hierAccountsForecast,...
by PavoGa
Fri Oct 26, 2018 6:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut with Hierarchies in PA2.0
Replies: 17
Views: 392

Re: ViewZeroOut with Hierarchies in PA2.0

I've got a workaround. Not pretty, but it is promising. Got a process that "syncs' the Leaves hierarchy to the master dimension by putting any leaf elements that exist in just the alternate hierarchies in a consolidation "Other Elements" in the dimension. Then, we build the subset we want off of an ...
by PavoGa
Fri Oct 26, 2018 6:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HierarchySubsetElementDelete odd behavior
Replies: 4
Views: 184

HierarchySubsetElementDelete odd behavior

Have the following subset with hundreds of elements: All Accounts 100-100-100 200-100-101 ... This code fails with "Unable to delete element at position "0" from dimension:subset": sMDX = EXPAND('UNION({[%dimAccountsMaster%].[%hierAccountsForecast%].currentmember}, TM1FILTERBYLEVEL(TM1SUBSETALL([%di...
by PavoGa
Fri Oct 26, 2018 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule file mismatch in architect and .rux file
Replies: 9
Views: 221

Re: Rule file mismatch in architect and .rux file

I generally use architect, could you please suggest how to fix this When you migrate, IF you shutdown the target server, removal all .blb files before restarting. I've never seen that fail. Or, if using the editor, paste in the correct rule file and save. I want to say that may not work all the tim...
by PavoGa
Fri Oct 26, 2018 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut with Hierarchies in PA2.0
Replies: 17
Views: 392

Re: ViewZeroOut with Hierarchies in PA2.0

Thanks, Lotsa.

Well, for now...ugh...this is going to ugly.

Got a couple of idea, but if anyone has a recommended methodology for achieving this, it would be nice to know. Got a couple of ideas, none of which seem all that appetizing.

Thanks again!
by PavoGa
Thu Oct 25, 2018 9:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut with Hierarchies in PA2.0
Replies: 17
Views: 392

Re: ViewZeroOut with Hierarchies in PA2.0

Agreed.

But that still begs the question: how does one use hierarchies and be able to clear out a target view before loading/reloading data?
by PavoGa
Thu Oct 25, 2018 9:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Some MDX functions not allowed in Workspace?
Replies: 0
Views: 82

Some MDX functions not allowed in Workspace?

This MDX subset errors in Workspace: {StrToMember("[Version].["+[}elementAttributes_sys.Clients].(StrToMember("[sys.Clients].["+username+"]"), [}elementAttributes_sys.Clients].[Default Version])+"]")} We've used this for years to default the Version dimension's title element in our views. Works in w...
by PavoGa
Thu Oct 25, 2018 8:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut with Hierarchies in PA2.0
Replies: 17
Views: 392

ViewZeroOut with Hierarchies in PA2.0

Cannot assign a subset created using HiearchySubsetCreate to a view using ViewSubsetAssign . Have tried: HierarchySubsetCreate(dimName, hierName, subName); HierarchySubsetMDXSet(dimName, hierName, subName, sMDX); ViewCreate(cubName, vwName); ViewSubsetAssign(cubName, vwName, dimName, subName); # Pro...
by PavoGa
Thu Oct 25, 2018 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element Security Override
Replies: 4
Views: 147

Re: Element Security Override

In my humble the easiest way of doing this is to use a clone of the dimension in the other cubes. There are processes in the Bedrock library which can handle the cloning (including attributes) and which can be scheduled as chores. What about Data Reservations? They seem simple enough to apply and m...