03 PRESENTATION LAYER
1. Presentation layer is the only layer visible to end users (Report Developer or clients).
2. In presentation layer we have 4 types of objects.
1. Subject area.
2. Presentation table.
3. Presentation columns.
4. Hierarchy object.
3. Subject area in 11g is called as presentation catalog in 10g.
4. Hierarchy object is newly introduced in 11g
5. Single Subject Area must be populated with content from a single business model; cannot span business models.
6. Multiple Subject Area can reference the same business model.
Step 1: Creating Subject Area
1. Right click on presentation layer -><- new subject area -><- name it as supplier sales-><- click on ok.
2. From sales business model select all the tables drag and drop on to supplier sales..
3. Similarly create one more subject area with the name of supplier sales DM. drag and drop periods,products and salesfacts tables.
Step 2: Reorder Columns
· Double click on sales presentation tables.
· Click on columns.
· Select .dollars ,unitord, unitship
· Click on up arrow mark and make sure these are in first,second and third positions respectively
Step 3 : Reorder Tables
· Double click on .supplier sales subject area
· Select sales fact table and make sure it is available in bottom.
Step 4 : Create Nested folders (or) nested tables
• Prefix the name of the presentation folder to be nested with a hyphen and a space or type -> in description of table
• Place it after the folder in which it nests.
Process:
· Double click on supplier sales subject area.
· Click on presentation tables tab.
· Click on add (+).
· Name it as keys and in the description type -> stores key columns and click on ok.
· Again click on add (+).
· Name it as - measures (prefix the table name with hyphen and a space)
· Click on ok
· Make sure these two tables are available under sales fact tables .
1. Presentation layer is the only layer visible to end users (Report Developer or clients).
2. In presentation layer we have 4 types of objects.
1. Subject area.
2. Presentation table.
3. Presentation columns.
4. Hierarchy object.
3. Subject area in 11g is called as presentation catalog in 10g.
4. Hierarchy object is newly introduced in 11g
5. Single Subject Area must be populated with content from a single business model; cannot span business models.
6. Multiple Subject Area can reference the same business model.
Step 1: Creating Subject Area
1. Right click on presentation layer -><- new subject area -><- name it as supplier sales-><- click on ok.
2. From sales business model select all the tables drag and drop on to supplier sales..
3. Similarly create one more subject area with the name of supplier sales DM. drag and drop periods,products and salesfacts tables.
· Double click on sales presentation tables.
· Click on columns.
· Select .dollars ,unitord, unitship
· Click on up arrow mark and make sure these are in first,second and third positions respectively
Step 3 : Reorder Tables
· Double click on .supplier sales subject area
· Select sales fact table and make sure it is available in bottom.
Step 4 : Create Nested folders (or) nested tables
• Prefix the name of the presentation folder to be nested with a hyphen and a space or type -> in description of table
• Place it after the folder in which it nests.
Process:
· Double click on supplier sales subject area.
· Click on presentation tables tab.
· Click on add (+).
· Name it as keys and in the description type -> stores key columns and click on ok.
· Again click on add (+).
· Name it as - measures (prefix the table name with hyphen and a space)
· Click on ok
· Make sure these two tables are available under sales fact tables .
No comments:
Post a Comment