Page 1 of 1
Child Elements are not visible under consolidations
Posted: Mon Oct 30, 2017 1:48 pm
by vishalpoddar90
Dear All,
I am creating a dimension with C level elements as last 5 week, last 10 week and last 13 week through TI.
Now when I open the Dimension I am not getting all the elements under consolidations. but as soon as i click collapse and reexpand the same consolidated element then I get all the elements under it.
Kindly help me to resolve this issue.
Re: Child Elements are not visible under consolidations
Posted: Mon Oct 30, 2017 1:53 pm
by Steve Rowe
Hi this is not an issue but expected behaviour.
The no-named subset view of a dimension you get when you open the subset editor is the natural underlying order of the dimension, which by default is I think the order in which the elements were added.
You can fix the natural order of the dimension in the dimension properties cube or using a TI command (DimensionSortOrder)
Re: Child Elements are not visible under consolidations
Posted: Mon Oct 30, 2017 2:00 pm
by vishalpoddar90
Steve Rowe wrote: ↑Mon Oct 30, 2017 1:53 pm
Hi this is not an issue but expected behaviour.
The no-named subset view of a dimension you get when you open the subset editor is the natural underlying order of the dimension, which by default is I think the order in which the elements were added.
You can fix the natural order of the dimension in the dimension properties cube or using a TI command (DimensionSortOrder)
I used DimensionSortOrder(DimensionName, 'ByInput', 'Ascending', 'ByHierarchy','Acending'); but it didnt nade any difference.
i have created a subset with mdx expression hierarchize but still getting the same results.
Re: Child Elements are not visible under consolidations
Posted: Mon Oct 30, 2017 2:02 pm
by declanr
What tab did you run the dimensionsortorder on?
Re: Child Elements are not visible under consolidations
Posted: Mon Oct 30, 2017 2:03 pm
by vishalpoddar90
declanr wrote: ↑Mon Oct 30, 2017 2:02 pm
What tab did you run the dimensionsortorder on?
I have tried with Prolog, metadata and epilog. Same result with all three tabs.
Re: Child Elements are not visible under consolidations
Posted: Mon Oct 30, 2017 2:34 pm
by tm123
Subset editor shows elements only once, so if you have multiple hierarchies in the dimension, it will not expand them all.
Re: Child Elements are not visible under consolidations
Posted: Mon Oct 30, 2017 4:20 pm
by vishalpoddar90
tm123 wrote: ↑Mon Oct 30, 2017 2:34 pm
Subset editor shows elements only once, so if you have multiple hierarchies in the dimension, it will not expand them all.
Then how to show all elements. I want to automate it. I have created a dyanamic subset using mdx expression but still getting same results.
Re: Child Elements are not visible under consolidations
Posted: Mon Oct 30, 2017 4:30 pm
by tm123
did you try to use { HIERARCHIZE( YourMDX ) } ?
Re: Child Elements are not visible under consolidations
Posted: Mon Oct 30, 2017 5:29 pm
by vishalpoddar90
tm123 wrote: ↑Mon Oct 30, 2017 4:30 pm
did you try to use { HIERARCHIZE( YourMDX ) } ?
Yes, i tried that also bt still no success.
Re: Child Elements are not visible under consolidations
Posted: Mon Oct 30, 2017 6:26 pm
by tm123
What version of TM1 are you using and also can you please post a screenshot from your Subset Editor, with MDX Expression Windows being displayed
Re: Child Elements are not visible under consolidations
Posted: Mon Oct 30, 2017 6:52 pm
by tomok
What exactly are you expecting to see when you
open the dimension? Are you expecting to see last 5 week, last 10 week and last 13 week, in order, all drilled down to their lowest level? If it is then just use this MDX in a subset:
Code: Select all
{TM1DRILLDOWNMEMBER( {[YourDimName].[last 5 week]}, ALL, RECURSIVE )}+
{TM1DRILLDOWNMEMBER( {[YourDimName].[last 10 week]}, ALL, RECURSIVE )}+
{TM1DRILLDOWNMEMBER( {[YourDimName].[last 13 week]}, ALL, RECURSIVE )}
Re: Child Elements are not visible under consolidations
Posted: Tue Oct 31, 2017 6:27 am
by vishalpoddar90
tomok wrote: ↑Mon Oct 30, 2017 6:52 pm
What exactly are you expecting to see when you
open the dimension? Are you expecting to see last 5 week, last 10 week and last 13 week, in order, all drilled down to their lowest level? If it is then just use this MDX in a subset:
Code: Select all
{TM1DRILLDOWNMEMBER( {[YourDimName].[last 5 week]}, ALL, RECURSIVE )}+
{TM1DRILLDOWNMEMBER( {[YourDimName].[last 10 week]}, ALL, RECURSIVE )}+
{TM1DRILLDOWNMEMBER( {[YourDimName].[last 13 week]}, ALL, RECURSIVE )}
Thanks a lot for expression but still I am getting same result.
Re: Child Elements are not visible under consolidations
Posted: Tue Oct 31, 2017 7:46 am
by Wim Gielis
Can you supply screenshots please ?
Also, the .dim file for the relevant dimension.
Re: Child Elements are not visible under consolidations
Posted: Tue Oct 31, 2017 8:50 am
by AmbPin
This MDX may return the elements you require:-
{
{TM1DRILLDOWNMEMBER( {[YourDimName].[last 5 week]}, ALL, RECURSIVE )}
, {TM1DRILLDOWNMEMBER( {[YourDimName].[last 10 week]}, ALL, RECURSIVE )}
, {TM1DRILLDOWNMEMBER( {[YourDimName].[last 13 week]}, ALL, RECURSIVE )}
}
Re: Child Elements are not visible under consolidations
Posted: Fri Nov 03, 2017 7:47 am
by vishalpoddar90
Wim Gielis wrote: ↑Tue Oct 31, 2017 7:46 am
Can you supply screenshots please ?
Also, the .dim file for the relevant dimension.
As per my organization's restriction I am not allowed to post any files or screenshots.