BI Journey

OBIEE : Interesting analysis on Usage Tracking Below is some interesting analysis you can do Usage tracking data Total No of users used the system at least once :- Select distinct user_name from s_nq_acct; Maximum concurrent queries fired at a time in the selected duration :- select   max( distinct_users ) as max_concorent_users from ( SELECT TO_CHAR( start_ts , 'YYYY-MM-DD HH24:MI' ) AS start_ts_min ,         COUNT(DISTINCT user_name )                AS distinct_users FROM    s_nq_acct where start_dt Between date1 and date 2 GROUP   BY TO_CHAR( start_ts , 'YYYY-MM-DD HH24:MI' ) )   Maximum concurrent sessions fired at a time in the selected duration :- select   max( distinct_users )     as max_concorent_users , max( distinct_reports )   as max_concorent_repo...