I have a data source having data in calweek, fiscal period level. I have only fiscal period in my cube and load the from that source system. The issue is the data doesnt get aggregated up at Fiscal Period level. The added and trasnferred records are exactly the same where as it should be nearly 1/4th of the transferred.
I check for each characteristic but data in cube appears exactly the same as in PSA just without calweek column.
Any help will be appreciated with points.
Message was edited by: