Hi Guru's
I have 4 Tables
Table 1:
Business Unit
Date,
Chart of account name,
Code Combination ID
Table 2:
Business Unit
Date,
Chart of account name,
Code Combination ID
Table 3:
Business Unit
Date,
Chart of account name,
Code Combination ID
where as the 4th Table ,data is on Month year wise Account balance
Table 4:
Business Unit
Period name---Date field name with MMM-YY Format
Chart of account name,
Code Combination ID
Account balance
First 3 tables are concatenated and join with Master calendar
Now i want to add 4th table to existing concatenated data model to bring in Business Unit wise ,Year,Month wise Account balance.
How to achieve this with out changing concatenated data model
Thanks,
Rajiv
