We created a webi report on universe and when we pull the business date object, it does not work as expected. the date is contiguous and shows multiple records. If we remove the business date, it shows only one record.
This contiguous date means there is a Cartesian product caused due to business date object.
Now when i checked the universe, the definition of this object is something like this @Aggregate_Aware(MAP_TIME.DAY__PERIOD_OF_TIME, MAP_TIME_CA.DAY__PERIOD_OF_TIME) and on parsing it gives error:
Parse failed: Invalid Table name state.
On checking, i cannot find any MAP_TIME_CA in the universe pulled. I can find the table MAP_TIME but not sure if it is an aggregate table. also no aggregation navigation is done.
I am confused on how to look at this issue.Also, i am not the developer of this universe and have min idea about it. Please help!