In the NQSConfig.ini file use ENABLE under CACHE Section for System Level for tables. How will you enable or disable caching in the system level and table level?
Oracle business intelligence applications for free#
Interested in mastering OBIA Training? Enroll now for FREE demo on OBIA Training. (system reserved variable).Įxamples of non-system variables are user defined filters etc. Non-system variable: system variable uses NQ_SESSION. Session variable: Session variable can be system variable Repository variable: This variable is for the whole repository. There are two types of variables in obiee.
What are the different types of variables in OBIEE? Explain How will you Port changes for dashboards,reports,rpd from development to production?įor the rpd use the Merge option in Admin Tool and for dashboards and reports use Content Accelerator Framework.
but the options are limited for combining like union etc. How will you create report from two subject areas?įrom the Criteria Pane of the Report Created from First Subject AreaĬome to the bottom of the page and click combine request. How will you execute Direct SQL in OBIEE?īy clicking Direct Database Request below the subject area in Answers. In Reports of Answer you can give a column as updateable and then view the reports, this option is called write back. How will you create Interactive Dashboards?īy clicking Administration and Manage dashboards and by adding column selector also by using view selector etc. How will you do different types of narrative Reports in OBIEE?īy clicking modify request and Narrative View and by giving for the first column result and for the 2nd column and son on and we can also give a heading for No Results by clicking the Narrative view. How will you do sort in Reports in OBIEE Answers?Ĭlick modify and then click sort (order by icon) on the relevant column in the criteria pane. In the Create Report Window –> Click Request SQL and save the sql to the physical path in your PC.Įnable Loglevel to 2 in the OBIEE Admin Tool from Mange-> Security and enable the log level to 2 by clicking properties for the user, then go to the NQQuery.log in BI_HOME/OracleBI/Server/Logs.You will find the SQL for that User.īy clcking Administration->Manage sessions-> view sql Are you Looking for Oracle Apps Finance Functional Training? Please Enroll for Demo Oracle Apps Finance Functional.! In the catalog Manager click Tools –>Create Report.
Oracle business intelligence applications code#
Modify the request and click Advanced in that you get xml code and the actual sql. OBIEE Consists of Presentation Services(Web), Oracle BI (Analytics Engine) Server.The client (Answers) constructs sql and passes it to the Analytic Engine and then the Oracle BI (Analytic Engine) parses the physical sql to the Datasources and retrieve the data back to the Engine and presents to the presentation Services. Specifically, sections in a dashboard page can be set up and only appear when there is interesting information of the data.Įxplain the Architecture of OBIEE and what each component do? Guided navigation is a feature of Oracle BI Interactive Dashboards that enables the content and layout of Oracle BI Interactive Dashboard to change dynamically based on changes in the information being analyzed.
0 kommentar(er)
