TM1 Forum

Wim Gielis wrote: ↑Fri Nov 04, 2022 6:32 pm Are you sure that drillthroughs are supported in alternate hierarchies ?

ascheevel wrote: ↑Fri Nov 04, 2022 6:54 pm It's been a while since I did this with alternate hierarchies, but you can parse the hierarchy selection, build the view manually in the prolog, and return that instead of the wizard-defined view. To be clear, the view you're returning is one without alternate hierarchies present. You'll need to parse the string parameter for whichever dim has the multi-hierarchy intersection in the drill-source. With two hierarchies from the same dim in the source view, the string parameter will look like this "^[base dim element selection]^[hierarchy name]:[hierarchy element selection]", three hierarchies would look like "^[base dim element selection]^[hierarchy1 name]:[hierarchy1 element selection]^[hierarchy2 name]:[hierarchy2 element selection]". If you only have 1 hierarchy for the dim in the view and it's an alternate hierarchy, the element name will be passed to the parameter like any normal drill view. You then would simply need to add all leaf children of that rollup in the alternate hierarchy to a subset or static list and attach that to the dynamic view you're creating in the prolog to be returned with ReturnViewHandle in the epilog.

ascheevel wrote: ↑Fri Nov 04, 2022 6:54 pm It's been a while since I did this with alternate hierarchies, but you can parse the hierarchy selection, build the view manually in the prolog, and return that instead of the wizard-defined view. To be clear, the view you're returning is one without alternate hierarchies present. You'll need to parse the string parameter for whichever dim has the multi-hierarchy intersection in the drill-source. With two hierarchies from the same dim in the source view, the string parameter will look like this "^[base dim element selection]^[hierarchy name]:[hierarchy element selection]", three hierarchies would look like "^[base dim element selection]^[hierarchy1 name]:[hierarchy1 element selection]^[hierarchy2 name]:[hierarchy2 element selection]". If you only have 1 hierarchy for the dim in the view and it's an alternate hierarchy, the element name will be passed to the parameter like any normal drill view. You then would simply need to add all leaf children of that rollup in the alternate hierarchy to a subset or static list and attach that to the dynamic view you're creating in the prolog to be returned with ReturnViewHandle in the epilog.

ascheevel wrote: ↑Wed Nov 16, 2022 7:58 pm What element in the base hierarchy do you want the consolidation from the alternate hierarchy to map to? If the alternate hierarchy consolidation doesn't exist in the base dim, you'll need to specify something, otherwise it will use a default which you're seeing with the "ND" selection.

ascheevel wrote: ↑Thu Nov 17, 2022 3:14 pm Exactly, it's well understood already that the consolidation in the alternate hierarchy doesn't exist in the base hierarchy, so the question is, "what do you want to do for the base hierarchy/dim?". Your drill-through view is going to need some element/subset selection for the base hierarchy, are you going to map to different selections based on what's selected in the alternate hierarchy or will you simply want to map to a standard default regardless of the drill source selection?

mrdauduong wrote: ↑Thu Nov 17, 2022 3:48 pm I will wait for the solution in the next update