how to make a drillthough on a virtual hierarchy element?
-
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
how to make a drillthough on a virtual hierarchy element?
Hi,
Iam trying to use new function Virtual Hierarchy on PAW
I have some virtual hierarchy with the element consolided diffirent.
I need to make a drillthrough but i realize that i can not drillthough on an element consolided of virtual hierarchy because this element consolided is not exist in architect ==> it return the default element "ND"
How i can make a drillthrough for 1 element consolided of virtual hierarchy?
Thanks a lot for help !
Iam trying to use new function Virtual Hierarchy on PAW
I have some virtual hierarchy with the element consolided diffirent.
I need to make a drillthrough but i realize that i can not drillthough on an element consolided of virtual hierarchy because this element consolided is not exist in architect ==> it return the default element "ND"
How i can make a drillthrough for 1 element consolided of virtual hierarchy?
Thanks a lot for help !
-
- MVP
- Posts: 3121
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: how to make a drillthough on a virtual hierarchy element?
Are you sure that drillthroughs are supported in alternate hierarchies ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Community Contributor
- Posts: 288
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: how to make a drillthough on a virtual hierarchy element?
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.
-
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
Re: how to make a drillthough on a virtual hierarchy element?
this is the first time i use a alternative hierarchies, so, i dont knowWim Gielis wrote: ↑Fri Nov 04, 2022 6:32 pm Are you sure that drillthroughs are supported in alternate hierarchies ?
Thanks for your reponse very clear Ascheevel, i will try it the next week and give you a feedback later !!!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.
-
- MVP
- Posts: 3656
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
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
Note: this refers to having alternate hierarchies as the TARGET of a drill-through. Having alöternate hierarchy elements as part of the slice from which a drill through is defined (i.e. the SOURCE of a drill-through) shouldn't be a problem. This is just a matter of defining a rule in the drill cube.
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
Note: this refers to having alternate hierarchies as the TARGET of a drill-through. Having alöternate hierarchy elements as part of the slice from which a drill through is defined (i.e. the SOURCE of a drill-through) shouldn't be a problem. This is just a matter of defining a rule in the drill cube.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
Re: how to make a drillthough on a virtual hierarchy element?
hi Ascheevel,
i dont really understand the idea. can you give a an exemple for this?
Thanks !
i dont really understand the idea. can you give a an exemple for this?
Thanks !
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.
-
- Community Contributor
- Posts: 288
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: how to make a drillthough on a virtual hierarchy element?
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.
-
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
Re: how to make a drillthough on a virtual hierarchy element?
hi,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.
i can not map with an element in the base hierarchy because the alternate hierarchy consolidation doesn't exist in the base dim, what i need to do to "specify something"?
thanks your reponse!
-
- Community Contributor
- Posts: 288
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: how to make a drillthough on a virtual hierarchy element?
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?
-
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
Re: how to make a drillthough on a virtual hierarchy element?
I can not map to different selectios based on what's selected in the alternate hierarchy because all the alternate hierarchy is very diffrent than the base hierarchy.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?
I will wait for the solution in the next update. maybe TM1 will support drill through for alternaty hierarchy in the future.
For now, i will try to do another way.
Thanks for your reponse!
-
- Community Contributor
- Posts: 288
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: how to make a drillthough on a virtual hierarchy element?
I think this is the best course of action for you at this time, hopefully the wait isn't too long. Cheers.