Datawarehouse Architect

Sum Calculates the sum obtained by adding up all values satisfying the numeric expression argument.   Syntax Sum(numExpr) Where: numExpr Any expression that evaluates to a numerical value.

  TopN Ranks the highest n values of the expression argument from 1 to n, 1 corresponding to the highest numerical value. The TOPN function operates on the values returned in the result set. A request can contain only one TOPN expression.   Syntax TopN(Expr, integer) Where: Expr Any expression that evaluates to a numerical value. integer Any positive integer. Represents the bottom number of rankings displayed in the result set, 1 being the highest rank.

  Using Nonsystem Session Variables The procedure for defining nonsystem session variables is the same as for system session variables. A common use for nonsystem session variables is setting user filters. For example, you could define a nonsystem variable called SalesRegion that would be initialized to the name of the user's sales region. You could then set a security filter for all members of a group that would allow them to view only data pertinent to their region. NOTE:   When you use these variables for Oracle BI Presentation Services, preface their names with NQ_SESSION. For example, to filter a column on the value of the variable SalesRegion set the filter to the Variable NQ_SESSION.Sales Region .

  Using System Session Variables   System session variables are session variables that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes. System session variables have reserved names, that cannot be used for other kinds of variables (such as static or dynamic repository variables and nonsystem session variables).   NOTE:   When you use these variables for Oracle BI Presentation Services, preface their names with NQ_SESSION. For example, to filter a column on the value of the variable LOGLEVEL set the filter to the Variable NQ_SESSION.LOG LEVEL. Table 34  describes the available system session variables.

To create a repository variable From the Administration Tool menu bar, choose Manage > Variables. In the Variable Manager dialog box, from the menu bar, choose Action > New > Repository > Variable. In the Variable dialog box, type a Variable name. Names for all variables should be unique. The names of system session variables are reserved and cannot be used for other types of variables. In the Variables dialog box, select the type of variable: Static or Dynamic. The name of the dialog box changes to reflect the type of variable that you select. (Dynamic repository variables) Use the Initialization Block drop-down list to select an existing initialization block that will be used to refresh the value on a continuing basis. (Dynamic or static variables) To add a Default initializer value, perform one of the following steps: To use the Expression Builder, click the ellipsis button to the right of the Default initializer work space. Type the value in...

  Creating Session Variables Use this task to create a session variable. To create a session variable From the Administration Tool menu bar, choose Manage > Variables. In the Variable Manager dialog box, from the menu bar, choose Action > New > Session > Variable. In the Session Variable dialog box, type a variable name. Names for all variables should be unique. The names of system session variables are reserved and cannot be used for other types of variables. For session variables, you can select the following check boxes: Check box that allows you to set the session variables after the initialization block has populated the value (at user login) by calling the ODBC store procedure NQSSetSessionValue(). For example, this allows non-Oracle BI Administrators to set this variable for sampling. Check box that identifies the variable as sensitive to security for virtual physical databases (VPD). When filtering cache table matches, the Oracle BI...

Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Analytics Cloud (OAC) are both business intelligence (BI) platforms developed by Oracle. However, there are some key differences between the two platforms. Deployment OBIEE is an on-premises BI platform, while OAC is a cloud-based BI platform. This means that OBIEE must be installed and maintained on your organization's own servers, while OAC is hosted and managed by Oracle in the cloud. User experience OAC has a more modern and user-friendly interface than OBIEE. It also has a wider range of self-service features, making it easier for business users to create and share insights without relying on IT. Data visualization OAC has a wider range of built-in visualizations than OBIEE, as well as the ability to create custom visualizations. OAC also has more advanced data visualization capabilities, such as interactive charts and graphs. Data preparation OAC has a more powerful data preparation tool than OBIEE. This tool ...