on 05-18-2013 11:24 AM
Hi,
We havea unx universe with serverlal contexts - for each of the fact tables.
There are two dimesnion tables which are joined to each other (part of snowflake schema) and this join is present in multiple contexts.
The two tables concerned are directly joined to one another.
If user selects object from dimension1 and dimesnion2 no context is shown (which is good).
I just want to check behaviour of contexts with reagrds the idt tool.
My understanding is that if query can only be staisfied by one join in universe then no contexrt is shown as this is the only join method possible even though the join exists in multiple contexts.
If were a different paths between the two tables and the different join patterns existed in multiple contexts then a context selection would be shown.
This sessm to be the behaviour .
Is this understanding correct?
Thnaks
Hi,
You're right.
Context ensures that joins are not included from different paths within the same SQL query. If the dimensions contained in your query are part of the same context, you won't have any prompt selection.
Remember that a context is a list of joins that define a path for a query. The tables involved in the joins are included in the context. The context is used to resolve problems in the query results (Loops or other specific modeling).
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.