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.