Context / Alias is best ?

[Former Member]

Hi All.,

I have 9 DImension Table and 1 fact table in my schema, can some one suggest me whether I can go for Alias/ Context to solve my Chasm Trap.

1 Dimension table is connected with 8 other Dimension table and 1 fact table. So I have to resolve chasm Trap in this universe? so i need to have context . so i need to have 9 context having all 8 Dimension table and 1 fact table.

so can i go for alias here?

[Former Member · Accepted solution]

Hi,

Go for context. To solve the chasm trap: define the contexts for each table at the "many" end of joins.

So that it will generate two different sqls for the tables.

Also select the option "Multiple SQL Statements for Each Measure" from the Universe Parameters dialog box

Regards,

Rohit

[Former Member]

Hi,

In my view Context is best for your issue. As rohit said create a

1. context at many end of the joins.

2. Select multiple sqls for each measure check box in universe parameters -> SQl if context is defined on measure so that Bo can generate different SQLs.

Cheers,

Suresh ALuri.