Load for same column name of different tables
Posted: Thu Jul 17, 2014 11:45 am
Hi,
I have two consolidations in the measure dimension. i.e. L1, L2 and which are related to differenet dept tables in database. I have the same column name present in both LOB tables and I have to load for these two same column name measures which are present in different hierarchies. I have created two separate processes for the load as these from different tables. How should I map the dimension while loading? Should I have to create dimension alias for the these elements and load on alias value? In Ti process, creating a variable and mapping with the dimension alias will work?
Thanks in advance
I have two consolidations in the measure dimension. i.e. L1, L2 and which are related to differenet dept tables in database. I have the same column name present in both LOB tables and I have to load for these two same column name measures which are present in different hierarchies. I have created two separate processes for the load as these from different tables. How should I map the dimension while loading? Should I have to create dimension alias for the these elements and load on alias value? In Ti process, creating a variable and mapping with the dimension alias will work?
Thanks in advance