cancel
Showing results for 
Search instead for 
Did you mean: 

BO4 - Idt tool when a context is shown/not shown at report runtime

former_member272336
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

wmarcy
Contributor
0 Kudos

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,


former_member272336
Participant
0 Kudos

Thanks for confirming

Answers (0)