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

Dashboard List for specific User

What are the Dashboards list permission having for each user.

I want to show on a dashboard page  what are the dashboards list  having access in logged user.

Step 1:

I'm using a javascript in a text object in a dashboard page, which generates the list of dashboards.

Copy the below java script and go to Dashbaord--> Page--> Add Text --> paste the below code and Check the HTML option.

<img id="loading" src="/analytics/res/sk_blafp/catalog/loading-indicator-white.gif" />
<div id="dash_list"></div>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js"></script>
<script type="text/javascript">
$.ajaxSetup({
    beforeSend:function(){
        $("#loading").show();
    },
    complete:function(){
        $("#loading").hide();
    }
});

$.ajax({
url: "saw.dll?getDashboardList"
}).done(function( data ) {
    var start = data.indexOf('[');
    var end = data.lastIndexOf(']');
    var len = end-start+1;
    var json_str = data.substr(start,len);
    var json_obj = jQuery.parseJSON(json_str);
    var str = 'You have access to the following dashboards:<br/>';
    $.each(json_obj, function() {
        if (this.folderName!=='Welcome'){
            str += '<div style="float:left;margin:5px 10px;";><b>' + this.folderName + '</b><br/>';
            $.each(this.portals, function() {
                    str += '<a href="saw.dll?Dashboard&PortalPath=' + this.portalPath + '">' + this.portalName + '</a><br/>';
            });
            str += '</div>';
        }
    });
$('#dash_list').html(str);
});
</script>