tag:blogger.com,1999:blog-65311820468218162972026-01-23T12:09:12.351-08:00kashifhttp://www.blogger.com/profile/06630970419124115441noreply@blogger.comBlogger720125tag:blogger.com,1999:blog-6531182046821816297.post-40800456713402150432023-11-11T11:14:00.003-08:002023-11-11T11:14:30.558-08:00

Week_Of_Year Returns a number (between 1 and 53) corresponding to the week of the year for the specified date.   Syntax Week_Of_Year(dateExpr) Where: dateExpr Any expression that evaluates to a date.

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-73084344560997867432023-11-11T10:14:00.001-08:002023-11-11T10:14:18.718-08:00

 Bit_Length Returns the length, in bits, of a specified string. Each Unicode character is 2 bytes in length, which is equal to 16 bits.   Syntax Bit_Length(strExpr) Where: strExpr Any expression that evaluates to a character string.   Practical Usage in Answers Using the Paint Business Area SELECT Markets.Region saw_0, bit_length(Markets.Region) saw_1, bit_length('C

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-83581386842794252332023-11-11T10:13:00.001-08:002023-11-11T10:13:40.435-08:00

Percentile Calculates a percentile rank for each value satisfying the numeric expression argument. The percentile rank ranges are between 0 (0th percentile) to 1 (100th percentile). The percentile is calculated based on the values in the result set.   Syntax Percentile(Expr) Where: Expr Any expression that evaluates to a numerical value.

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-85170553691447998762023-11-11T07:41:00.007-08:002023-11-11T07:41:52.757-08:00

Upper Converts a character string to uppercase.  Syntax Upper(strExpr) Where: strExpr Any expression that evaluates to a character string.

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-84266563882368990422023-11-11T07:41:00.002-08:002023-11-11T07:41:08.351-08:00

Rank Calculates the rank for each value satisfying the numeric expression argument. The highest number is assigned a rank of 1, and each successive rank is assigned the next consecutive integer (2, 3, 4,...). If certain values are equal, they are assigned the same rank (for example, 1, 1, 1, 4, 5, 5, 7...). The rank is calculated based on the values in the result set.   Syntax Rank(Expr)

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-51251905009421798742023-11-11T07:40:00.002-08:002023-11-11T07:40:37.440-08:00

Count Calculates the number of rows having a nonnull value for the expression. The expression is typically a column name, in which case the number of rows with nonnull values for that column is returned. Syntax Count(numExpr) Where: numExpr Any expression that evaluates to a numerical value.

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-46842318774930405492023-11-11T07:39:00.001-08:002023-11-11T07:39:47.390-08:00

Current_Time Returns the current time. The time is determined by the system in which the Oracle BI Server is running.   Note: The Analytics Server does not cache queries that contain this function.SyntaxCurrent_Time(integer)Where:integer Any integer that represents the number of digits of precision with which to display the fractional second.

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-1210127287843844122023-11-11T07:38:00.005-08:002023-11-11T07:38:58.676-08:00

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.

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-38562489309425961952023-11-11T07:38:00.001-08:002023-11-11T07:38:13.529-08:00

 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

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-17909425959879720512023-11-11T07:37:00.001-08:002023-11-11T07:37:20.668-08:00

 Using Nonsystem Session VariablesThe 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

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-10912530395836561012023-11-07T12:07:00.001-08:002023-11-07T12:07:22.645-08:00

 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

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-58137683275853831332023-11-07T12:06:00.003-08:002023-11-07T12:06:39.141-08:00

To create a repository variableFrom 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

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-1648685632343457282023-11-07T12:06:00.001-08:002023-11-07T12:06:07.356-08:00

 Creating Session VariablesUse this task to create a session variable.To create a session variableFrom 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

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-38792149348138004912023-11-05T10:13:00.003-08:002023-11-05T10:13:38.880-08:00

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.DeploymentOBIEE 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,

kashifhttp://www.blogger.com/profile/06630970419124115441noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-84249964410293978082023-11-05T10:07:00.000-08:002023-11-05T10:07:09.364-08:00

Migrating to Oracle Analytics Cloud (OAC) offers a range of benefits for organizations seeking to enhance their data analytics capabilities and decision-making processes. These benefits include: 1. Reduced IT Costs and Infrastructure Burden: OAC's cloud-based infrastructure eliminates the need for organizations to maintain and manage on-premises hardware and software, reducing IT costs and

kashifhttp://www.blogger.com/profile/06630970419124115441noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-86980366122835938562023-11-05T09:57:00.006-08:002023-11-05T09:57:46.028-08:00

Power BI and Oracle Analytics Cloud (OAC) are both powerful business intelligence (BI) platforms that can help you visualize and analyze your data. However, there are some key differences between the two platforms that may make one a better fit for your organization than the other.Ease of usePower BI is generally considered to be easier to use than OAC. It has a more intuitive interface and a

kashifhttp://www.blogger.com/profile/06630970419124115441noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-5918008168011004442023-11-04T17:25:00.006-07:002023-11-04T17:25:50.082-07:00

OperatorsOperators are used to combine expression elements to make certain types of comparisons in an expression.Operator Function in an Expression       + Plus sign for addition. - Minus sign for subtraction. * Multiply sign for multiplication. / Divide by sign for division. || Character string concatenation. ( Open

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-16544725177149295452023-11-04T17:24:00.002-07:002023-11-04T17:24:42.832-07:00

 Char Converts a numerical value between 0 and 255 to the character value corresponding to the ASCII code.   Syntax Char(numExpr) Where: numExpr Any expression that evaluates to a numerical value between 0 and 255.   Practical Usage in Answers Using the Paint Business Area SELECT Char(40) saw_0, Char(45) saw_1, Char(55) saw_2, Char(62) saw_3, Char(64) saw_4, Char(65)

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-44658630373779941752023-11-04T17:21:00.001-07:002023-11-04T17:21:25.378-07:00

 Formatting Columns and Changing Column Order1. Additional formatting can be done column by column, by selecting the format icon (looks like a hand) within any column. Doing so opens the column format dialogue box.2. The column order can be changed by dragging and dropping the column, or the parent heading (if they are being displayed). When dragging, a dark blue bar indicates where the

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-21051501728472261232023-11-04T17:20:00.001-07:002023-11-04T17:20:35.126-07:00

 What is the Informatica Designer?The Informatica Designer is a client tool used to create instructions for the Integration Service. The instructions consist of source and target definitions, along with transformation objects used to transform the data.   Who uses the Informatica DesignerInformatica Designer is used by system administrators and developers, alike. Designer

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-66165769618549897552023-11-02T19:38:00.005-07:002023-11-02T19:38:53.198-07:00

 1Goals of Data Warehousing 1. “The data warehouse must make an organization’s information easily accessible.” 2. “The data warehouse must present the organization’s information consistently.” 3. “The data warehouse must be adaptive and resilient to change.”4. “The data warehouse must be a secure bastion that protects out information assets.”5.“The data warehouse must

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-12570452781623139632023-11-02T19:38:00.001-07:002023-11-02T19:38:27.328-07:00

What is the Informatica Administration Console?The Informatica Administration Console is a server tool that manages the domain’s properties, integration services, repository services, and user security.  Who uses the Informatica Administration Console? The Informatica Administration Console is used primarily by system administrators.Administration Console Terminology and

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-2430542200739508142023-11-02T19:37:00.003-07:002023-11-02T19:37:51.297-07:00

 Client Tools: Repository ManagerWhat is the Informatica Repository Manager? The Informatica Repository Manager is a client tool that manages the repository objects. Who uses the Informatica Repository Manager?Informatica Repository Manager is used by system administrators and developers, alike. Repository Manager TerminologyRepository objects – Any object found in the

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-45908882997182197112023-11-02T19:37:00.001-07:002023-11-02T19:37:02.620-07:00

What is the Informatica Workflow Manager? The Informatica Workflow Manager is a client tool that executes workflows for the mappings that have been developed in Designer. Who uses the Informatica Workflow Manager? Informatica Workflow Manager is used by system administrators and developers, alike. Workflow Manager TerminologyTask Developer – Used to create and view sessions,

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0tag:blogger.com,1999:blog-6531182046821816297.post-36817793601687789162023-11-02T19:35:00.002-07:002023-11-02T19:35:21.382-07:00

What is the Informatica Workflow Monitor?   The Informatica Workflow Monitor is a client tool that monitors workflows and records workflow activity.   Who uses the Informatica Workflow Monitor?   Informatica Workflow Monitor is used by system administrators and developers, alike. Functions of Informatica Workflow Monitor: 1.To read workflow logs 2.To read session logs

adhinihttp://www.blogger.com/profile/14499253664959310726noreply@blogger.com0