Physical Layer
1. Enable DB features
2. Push the calculation to DB
3. Set up the no of connection in efficient manner based on the Oracle recomended way.
4. Physical Table "Select" Type i.e Opaque views can be avoided and introduce Materalised Table provided if ROLAP is oracle.
BMM layer
1. Set the aggregation Level proper level in each LTS of the Logical Table.
2. Set the estimation level for each level in Dimension. To calculate the estimation level, right click and run the Estimation level or Specify the ration between the levels.
Presentaion layer.
1. Rule of seven, each of the presentation table shows only seven columns (oracle recomendation) if it is possible.
2. Limit theno of the facts on each SA avoid user to link the fact which is not intended to link.
1. Enable DB features
2. Push the calculation to DB
3. Set up the no of connection in efficient manner based on the Oracle recomended way.
4. Physical Table "Select" Type i.e Opaque views can be avoided and introduce Materalised Table provided if ROLAP is oracle.
BMM layer
1. Set the aggregation Level proper level in each LTS of the Logical Table.
2. Set the estimation level for each level in Dimension. To calculate the estimation level, right click and run the Estimation level or Specify the ration between the levels.
Presentaion layer.
1. Rule of seven, each of the presentation table shows only seven columns (oracle recomendation) if it is possible.
2. Limit theno of the facts on each SA avoid user to link the fact which is not intended to link.
No comments:
Post a Comment