Posted On: Feb 22, 2018
It represents the particular join path that can be between the tables or between the specific group of joins for an individual query. The object created on a column table from a specific context is compatible with all the objects from the same context by default. If the objects of different contexts are used, then to avoid any incorrect results or loopholes, separate SQL statements are used and the result from all statements is combined in a micro cube.
Creation of Context: Contexts can be generated manually or by the features available in the Context called as detect Context. In general, the contexts are created on the basis of business requirements or logical calculations, so detect context has not much use. To do manually follow the following steps:
Your Context is ready. If you are creating Universe Context, then all the joins must fall in at least one context but shortcut joins can be excluded from the list
Never Miss an Articles from us.