When does new LTS (Logical Table Source ) gets created?
1. If aggregate tables available for same Logical Fact, create a new LTS and set the level appropriately.
2. If fact tables contains various level of data, each level can be filtered and create as new LTS.
3. If a dimension is snow flaked, then if report requires one of the snowflake. Then create a new LTS.
Good link for Column Hiding
http://nerdsofobiee.wordpress.com/tag/column-level-security/
1. If aggregate tables available for same Logical Fact, create a new LTS and set the level appropriately.
2. If fact tables contains various level of data, each level can be filtered and create as new LTS.
3. If a dimension is snow flaked, then if report requires one of the snowflake. Then create a new LTS.
Good link for Column Hiding
http://nerdsofobiee.wordpress.com/tag/column-level-security/
No comments:
Post a Comment