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