Best Practice BI Admin tool

Best Practice at presentation layer .
1.       Catalogue to map to one business layer and one BMM layer only .
2.       Use Parent folder and sub folder to group fact and similar dimension together .
3.       Avoid use of alias while adding new column in Presentation layer .
4.       The column should be shorter alphabetically .
5.       Get customer sign off about the column before building reports
6.       Make proper use of permission  in the PPL .
7.       Don’t use “ in column .
8.       PPL column name should not have same name as table name
9.       Limit number of object in folder to 10 t0 12 .
10 Use object description
11-Remove the primary key column and other column 

Best Practice at BMM layer .

1.       Always use Start schema and minimize snow flex .

2.       Create dimension hierarchies for every  dimension in BMM

3.       Define Key at each level of hierarchies

4.       Combined all the attribute that describe single entity  into single logical table.

5.       Never delete logical column that map to key of physical DIM table

6.       Do not keep unwanted phycal column  in logical tables

7.       Whenever do necessary consistency check  right click on the changed business  modal instead of going for full to avoid time.

8.       Fix the warning if any don’t ignore 

Best Practice at Physical layer .

1.       Try to always import table instead of creating to avoid data type and name issue

2.       For each DIM only one primary key is must but for fact no need.

3.       If only composite key is available create a single physical key and add all the composite into it

4.       Avoid using complex join in PH layer . 

5.       Always use number – number join

6.       Facts should not be joined .