Way to solve the Chasm trap

Question

Explain how the Chasm trap is solved?

Answer 1

It’s detected through the visual analysis of the schema. A chasm trap is generally solved in the following way:

a) Using the Multiple SQL statements for every Measure

b) Creating the Context

c) Creating the Multiple Universes (WEBI)