Dynamic column Name In BI studio

[Anitivirus]

Hi All,

I have a particular situation where I need to set some column names dynamic (from another table) in my cube.



The Scenario:

1.Fact table with column names "column1" , '"column2"

2. Column_name table with two fields "Identifier" and "Name" , the "Name" field values are changing time to time. The table looks like this ....



Identifier Name

1 Admin Fees

2 Other fees



Now while displaying cube I need to display the Column name "Column1" as "Admin Fees"(when Identifier =1) and "Column2"(when identifier = 2) as "Other fees"



Is there any workaround to get the task done Sql Server ?





Any Help will be appreciated.