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...
Posts
OBIEE: Enable/Disable Cache Login to EM using below link http://localhost :7001/em Log in as an administrative user. Typically you use the administrative user name and password provided during the Oracle BI installation. In the left navigation pane of em home screen, expand Business Intelligence and click coreapplication Click the Capacity Management tab and then Click the Performance sub tab Locate the Enable BI Server Cache section. Click Lock and Edit Configuration. Deselect/Select Cache enabled to disable or enable cache. also set the maximum cache entry size and maximum cache entries. Click Apply and Click Activate Changes . click Restart to apply recent changes. Hope it helps
Variables in OBIEE Part 3 Presentation Variable : Presentation variable is the variable available in presentation service. Presentation variable can be initialized from prompts. Presentation can be initialized from Prompt by either creating Presentation prompt or can set variable from column prompt set varaiable option Presentation variable can call in report using below syntax ('@{Variable_name}{variable value}') Below is the syntax to pass multi-select characters to column filter @{varaiable_name} ['@'] {'varaiable value'}
Variables in OBIEE Part 2 Session Variable: Session variable is similar to the dynamic repository variable in that they obtain values from initialization block. The difference is session variable scope is limited to the user session. Session initialization block will run every time if a new user logged in There are two types of session variables available System Session variable Non system session variable System session variable : System variables are OBIEE reserved variable. Example for system session variable is USER. USER variable holds username always. Non System Session Variable: Non system session variable can be initialized using initialization block. Like system session variable the scope of non system session variable is limited to session. Non system variables are commonly used for security implementation. For eg: if we want the region of a user, we can create initialization block to get regi...
Variables in OBIEE Part 1 Below are the major types of variables available in OBIEE 1) Repository variable 2) Session Variable 3) Presentation variable Repository variable A repository variable has a single value at any point in time. Repository variable can be classified into two: a) Static b) Dynamic Static Repository variable: Will contain static value always unless administrator tries to change it. Eg: below is static variable created for Current_date. I have specified the value 2013-11-16 as the current date .The variable will hold this value always and this can be changed only by the administrator. RPD deployment is required after the change. Dynamic Repository variable: Dynamic Repository variab...
OBIEE: Important File Paths File Paths in OBIEE 11g Repository Path :- OBIEE_INSTANCE/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository Webcatlog Path :- OBIEE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog NQS Config File :- OBIEE_INSTANCE/config/OracleBIServerComponent/coreapplication_obis1 Instance Config :- OBIEE_INSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obips1 Application Role xml file :- user_projects/domains/bifoundation_domain/config/fmwconfig system-jazn-data.xml I mportant Logs Paths in OBIEE 11g Weblogic Log :- user_projects/domains/bifoundation_domain/servers/AdminServer/logs/AdminServer.log Managed Server Log :- user_projects/domains/bifoundation_domain/servers/bi_server1/logs//bi_server1.log Node Manager...
OBIEE:Enable Evaluate function Hi all, To enable evaluate function in obiee 11g we have to change the EVALUATE_SUPPORT_LEVEL parameter in NQSConfig file. NQS config file located in OBIEE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn. we can change EVALUATE_SUPPORT_LEVEL to 1,2 and any number. The details of each are available in NQSConfig itself. EVALUATE_SUPPORT_LEVEL: 1: evaluate is supported for users with manageRepositories permission 2: evaluate is supported for any user. other: evaluate is not supported if the value is anything else. Change EVALUATE_SUPPORT_LEVEL to 2 if you want the users to use evaluate function in their report. Restart the server after the change to make it effective. And do mention aggregation rule in edit column formula if you are using evaluate in any report to avoid e...