adspace
Can you please clarify the difference between compatible and incompatible objects?
Answer Posted / krishnamohan32
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
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers