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

Sunday, July 7, 2013

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>