What is a Chasm Trap

What is a Chasm Trap

Simply put: A chasm occurs when a series of joins crosses a many >- one -<>

A >- B -<>

If I were to write a query that spanned all three of those tables the data from table A and C would be duplicated and measure values would be inflated. The inflation factor can be determined by counting the number of rows from the left that match a particular key and multiplying by the number of rows on the right....... for more details

Read more »

What is a Chasm Trap

What is a Chasm Trap

Simply put: A chasm occurs when a series of joins crosses a many >- one -<>

A >- B -<>

If I were to write a query that spanned all three of those tables the data from table A and C would be duplicated and measure values would be inflated. The inflation factor can be determined by counting the number of rows from the left that match a particular key and multiplying by the number of rows on the right....... for more details

Read more »

Business Objects Repository Basics

• One security domain
• Multiple document and universe domains allowed
• All domains may be located on a single database (monolithic)
• Document and universe domains may be located across different databases (distributed)

Key required to access the repository

• Can be located on the users workstation (LocData) or in ashared folder (ShData)
  

- Pdac.lsi or pdac.ssi defines personal connections to the database
- Sdac.lsi or Sdac.ssi defines shared connections to the database
- All other .lsi and .ssi files are user login files. These files contain the security
information needed to run Business Object when not connected to the repository

• Security domain maps actors to resources via resource links
  

-Actors can be a user or a group
-Resources include documents, universes and domains
- Access to a resource may be linked directly to the user or inherited from further up the security hierarchy

Read more »