Question { 2408 }
Can you please clarify the difference between compatible and incompatible objects?
Answer
Hi,
We set compatible and incompatible objects in aggregate navigation.
In your fact table contains sales revenue,That sales revenue is aggregated by yearly table,quarterly table,monthly table.
Ex:yearly_sales revenue,quarterly_sales revenue,monthly_sales revenue.
yearly_sales revenue contain (year) dimension,quarterly_sales revenue contain (year,quarter) dimensions and monthly_sales revenue contain (year,quarter,month)
Here
year and quarter dimension is incompatible with monthly_sales revenue,year dimension is incompatible with quarterly_sales revenue.
Like this way we set compatible and incompatible objects for tables.
Hope u understand.
Thanks
Krishna Mohan