Friday, July 19, 2013

OBIEE HLD and LLD


OBIEE HIGH LEVEL DESIGN AND LOW LEVEL DESIGN


Yesterday, I got the chance to prepare HLD document in current project. Here am contributing my experience and knowledge.


HLD document preparation you need to cover below things


1. Scope of the project
2. Source database design
3. High level warehouse design ( Star schema /snowflake schema) structure
4. Fact tables and Dimension tables and relation between the tables
4. Oracle BI Distributed architecture
5. Authorization and Authentication Details (User and group)
6. Standard Guidelines


LLD document preparation you need to cover below things.
1. Scope of the project
2. Data source system structure which includes all columns and its details
3. Repository details (Physical layer details, tables and join between tables, BMM Layer details and Presentation Layer Details) and variables and user group details
4. Report Details
5. Users and Security details


Template you have to maintain below points.

1.Document Control
2.Reviewers
3. Introductio
4. Intended Audience
5. Related Documents
6. Environment
7. Glossary – Project Terms
8. Applicable Requirements
9. BI Apps Architecture
10. Analytics (OBIEE) Repository Star schemas     
11.Assumptions
12.Dependencies
13.Issues
14.Risks
15.Open items
16.Closed item


Thanks,
Satya Ranki Reddy

1 comment:

  1. Hi Satya,

    Could you please share "High Level" and "Low Level" design templates to my mail id: anilragas@gmail.com

    Thanks
    Anil

    ReplyDelete