Hi,
I have got a "geographical" dimension with 5 levels but my query just return a report with 3 (the first and second one and the last one).
I want to show a report with a 'sorted ASC' [sales values] but I can not use Order Function (with 'BASC' first level members are at the top, and with 'ASC' last level members maintain the hierarchy order with previous level - that is not in the report-).
I know I need a special function (maybe external), any idea.
With a dimension-levels like : State, region,zone,city,neighborhood;
I want to mantain the hierarchy between state-region and region-neighborhood -excluding zone and city-
I hope is clear, Thanks in advance.
I have got a "geographical" dimension with 5 levels but my query just return a report with 3 (the first and second one and the last one).
I want to show a report with a 'sorted ASC' [sales values] but I can not use Order Function (with 'BASC' first level members are at the top, and with 'ASC' last level members maintain the hierarchy order with previous level - that is not in the report-).
I know I need a special function (maybe external), any idea.
With a dimension-levels like : State, region,zone,city,neighborhood;
I want to mantain the hierarchy between state-region and region-neighborhood -excluding zone and city-
I hope is clear, Thanks in advance.