How to create dynamic table reference

[Anonymous]

Hi All,

I have a fact table and various Dimension tables. Please find attached files for model reference.

I want to have a dynamic environment where my Drilldown values(Tables and fields to be looked up) from Fact are picked and as a reference from Dim_Drilldown tables.

Then refer the Dim_Entity or Dim_Description table and find appropriate values from it via joins.

Incase if more clarification is required then please let me know.

Wish you a Merry Christmas and Happy New year !!

[prieper]

The dynamic is inside the QV-logic, i.e. selected fields are green, possible white and not avail in gray.

Can you describe a bit more precise, please?

Peter

[Anonymous]

Hi Peter ,

On basis of Dim_Drilldown The table should  looked up. Dim_Drilldown has information of which table to be looked up and which column data to be picked. Refer attached image.

The tables data should look up dynamically or be mapped accordingly to pick the right data.

Thanks in Advance

Wish You happy new year !!

[Anonymous]

gwassenaar swuehl

Legends, I will be obliged for the help !!