Working with hierarchies

[Anonymous]

Hi

I have created a hierarchie like that:

Jerarquia_pais:
Hierarchy(cod_geo, cod_padre, desc_geo, desc_padre, desc_geo, jerarquia_geografica , '|', profundidad) LOAD
cod_geo,
cod_padre,
desc_geo
FROM

(ooxml, embedded labels, table is Hoja1); Hoja1);

My source date are:

then I make a treeview in a listbox that allow me to select values makinf drll-down in the hierarchie:

My question is:

I have a chart of sales using a typical sales fact table. That chart has members of this hierarchie as dimension. I would like to select the dimension in the chart and doing drill-down if there is a lower level in the hierarchie (for example: Europe -> Spain -> Madrid).

That is to use the hierarchie in the selecctions in my chart.

Is that posiible using my hierarchie table linked with the fact sales table.

I know that I can make a hierarchical group, but it is not simple for this hierarchie and I prefer to use the hierarchie table.

Thanks in advance.

[#2]

Hi,

If you link your sales fact table to your hierarchy using the cod_geo field you can then use field desc_geo1,desc_geo2,desc_geo3… in your drill down group dimension

[#3]

thanks

[#4]

Did you manage to get this working?