Calling Database Analytics Functions in OBIEE

OBIEE 11g introduces a new function called EVALUATE_ANALYTIC that can ship analytic functions from Answers back to the database. In 10g we had EVALUATE which could ship only normal functions. Analytics functions were not supported. But with 11g, Analytics Functions are supported as well. There are a lot of database analytics functions that can be…

Downgrading RPD in OBIEE

to downgrade the rpd we need to use the utility nqgenoldverrpd.exe which can normally be found at path: %OBIEE_HOME% / bifoundationserver / bin / nqgenoldverrpd.exe syntax: nqgenoldverrpd [-P repo_pass] -I input_path -O output_path -V version         nqgenoldverrpd -P pwd -I rp1.rpd -O rp1_downgrd.rpd -V 318

Adding a Redirect Page for instance when OBIEE Presentation Service Is Down

Similar steps can be implemented on Unix Create a working folder called work in C: Create 2 sub-folders under it called ear_extract and war_extract. Copied analytics.ear from MW_HOME\Oracle_BI1\bifoundation\jee to c:\work. Run the command from c:\work\ear_extract folder – MW_HOME\Oracle_BI1\jdk\bin\jar -xvf MW_HOME\Oracle_BI1\bifoundation\jee\analytics.ear Run the command from c:\work\war_extract folder – MW_HOME\Oracle_BI1\jdk\bin\jar -xvf c:\work\ear_extract\analytics.war Add the following lines (error-page…

OBIEE Variables

You can reference variables in several areas of OBIEE, like analyses, dashboards, KPIs, actions, agents, and conditions. For example, suppose that you wanted to create an analysis whose title displays the current user’s name. You can do this by referencing a variable. OBIEE has 4 types of variables: Session Repository Presentation Request Session Variables: A session variable is…

Time Series functions in OBIEE

Ago () calculates aggregated value for a measure as of time period ( a month ago, or a year ago) from the current time. ToDate () aggregates a measure from a beginning of a specified time period to the currently displayed time. PeriodRolling () allows to create a aggregated measure across a specified set of query grain period, rather than within a fixed time series grain.…