Using Functions Formulas And Calculations In Web Intelligence-Books Pdf

Using functions formulas and calculations in Web Intelligence
28 May 2020 | 18 views | 0 downloads | 238 Pages | 4.28 MB

Share Pdf : Using Functions Formulas And Calculations In Web Intelligence

Download and Preview : Using Functions Formulas And Calculations In Web Intelligence


Report CopyRight/DMCA Form For : Using Functions Formulas And Calculations In Web Intelligence



Transcription

Table of Contents, 1 Document History Web Intelligence Functions Formulas and Calculations 5. 2 About this guide 6,3 Using standard and custom calculations 7. 3 1 Standard calculations 7,3 2 Using formulas to build custom calculations 7. 3 2 1 Using variables to simplify formulas 8,3 3 Working with functions 8. 3 3 1 Including functions in cells 9,3 3 2 Function syntax 9.
3 3 3 Examples of functions 9,3 3 4 Function and formula operators 14. 4 Understanding calculation contexts 16,4 1 Calculation contexts defined 16. 4 1 1 The input context 16,4 1 2 The output context 17. 4 2 Default calculation contexts 19,4 2 1 Default contexts in a vertical table 20. 4 2 2 Default contexts in a horizontal table 21,4 2 3 Default contexts in a crosstab 21.
4 2 4 Default contexts in a section 22,4 2 5 Default contexts in a break 23. 4 3 Modifying the default calculation context with extended syntax 23. 4 3 1 Extended syntax operators 24,4 3 2 Extended syntax keywords 27. 5 Calculating values with smart measures 35,5 1 Smart measures defined 35. 5 2 Grouping sets and smart measures 35,5 2 1 Management of grouping sets 36. 5 3 Smart measures and the scope of analysis 36,5 4 Smart measures and SQL 37.
5 4 1 Grouping sets and the UNION operator 37,5 5 Smart measures and formulas 39. 5 5 1 Smart measures and dimensions containing formulas 39. 5 5 2 Smart measures in formulas 39,5 6 Smart measures and filters 40. 5 6 1 Smart measures and filters on dimensions 40, Using functions formulas and calculations in Web Intelligence. 2 2013 SAP AG or an SAP affiliate company All rights reserved Table of Contents. 5 6 2 Filtering smart measures 41,5 6 3 Smart measures and drill filters 41. 5 6 4 Smart measures and nested OR filters 42,6 Functions operators and keywords 43.
6 1 Functions 43,6 1 1 Aggregate functions 43,6 1 2 Character functions 73. 6 1 3 Date and Time functions 94,6 1 4 Data Provider functions 110. 6 1 5 Document functions 125,6 1 6 Logical functions 134. 6 1 7 Numeric functions 144,6 1 8 Set functions 169. 6 1 9 Misc functions 179,6 2 Function and formula operators 201.
6 2 1 Mathematical operators 202,6 2 2 Conditional operators 202. 6 2 3 Logical operators 202,6 2 4 Function specific operators 206. 6 2 5 Extended syntax operators 212,6 2 6 Set operators 215. 6 3 Extended syntax keywords 216,6 3 1 The Block keyword 216. 6 3 2 The Body keyword 217,6 3 3 The Break keyword 218.
6 3 4 The Report keyword 219,6 3 5 The Section keyword 220. 6 4 Rounding and truncating numbers 221, 6 5 Referring to members and member sets in hierarchies 222. 7 Troubleshooting formulas 224,7 1 Formula error and information messages 224. 7 1 1 COMPUTATION 224,7 1 2 CONTEXT 224,7 1 3 DATASYNC 225. 7 1 4 DIV 0 225,7 1 5 ERROR 225,7 1 6 EXTERNAL 225.
7 1 7 INCOMPATIBLE 226,7 1 8 MIX 226,7 1 9 MULTIVALUE 226. Using functions formulas and calculations in Web Intelligence. Table of Contents 2013 SAP AG or an SAP affiliate company All rights reserved 3. 7 1 10 N A 226,7 1 11 OVERFLOW 227,7 1 12 PARTIALRESULT 227. 7 1 13 RANK 227,7 1 14 RECURSIVE 227,7 1 15 REFRESH 228. 7 1 16 REPFORMULA 228,7 1 17 SECURITY 228,7 1 18 SYNTAX 228. 7 1 19 TOREFRESH 228,7 1 20 UNAVAILABLE 229,8 Comparing values using functions 230.
8 1 Comparing values using the Previous function 230. 8 2 Comparing values using the RelativeValue function 230. 8 2 1 Slicing dimensions and the RelativeValue function 231. 8 2 2 Slicing dimensions and sections 232,8 2 3 Order of slicing dimensions 234. 8 2 4 Slicing dimensions and sorts 235,8 2 5 Using RelativeValue in crosstabs 237. Using functions formulas and calculations in Web Intelligence. 4 2013 SAP AG or an SAP affiliate company All rights reserved Table of Contents. 1 Document History Web Intelligence,Functions Formulas and Calculations. The following table provides an overview of the most important document changes. Version Date Description, SAP BusinessObjects Interactive 30 November 2011 Initially rebranded Interactive Analysis. Analysis 4 0 First release of this document, SAP BusinessObjects Interactive 25 February 2011 Support Package 1.
Analysis 4 0 Service Pack 1, BusinessObjects Web Intelligence 4 0 15 June 2011 Support Package 2 Rebranded back to. Service Pack 2 Web Intelligence, BusinessObjects Web Intelligence 4 0 20 February 2012 Feature Pack 3. Feature Pack 3, Using functions formulas and calculations in Web Intelligence. Document History Web Intelligence Functions Formulas and Calculations 2013 SAP AG or an SAP affiliate company All rights reserved 5. 2 About this guide, The Using Functions Formulas and Calculations in Web Intelligence guide provides detailed information on the. advanced calculation capabilities available in when you perform data analysis It also provides a syntax reference. to the available functions and operators, Using functions formulas and calculations in Web Intelligence.
6 2013 SAP AG or an SAP affiliate company All rights reserved About this guide. 3 Using standard and custom calculations, You can use standard calculation functions to make quick calculations on data If standard calculations are not. sufficient for your needs you can use the formula language to build custom calculations. 3 1 Standard calculations, You can use standard calculation functions to make quick calculations on data The following standard. calculations are available,Calculation Description. Sum Calculates the sum of the selected data, Count Counts all rows for a measure object or count distinct. rows for a dimension or detail object,Average Calculates the average of the data.
Minimum Displays the minimum value of the selected data. Maximum Display the maximum value of the selected data. Percentage Displays the selected data as a percentage of the total. The results of the percentage are displayed in an,additional column or row of the table. Percentages are calculated for the selected,measure compared to the total results for that. measure on the table or break To calculate the,percentage of one measure compared to another. measure you need to build a custom calculation, Default Applies the default aggregation function to a standard. measure or the database aggregation function to a,smart measure.
When you apply standard calculations to table columns the calculation results appear in footers One footer is. added for each calculation,3 2 Using formulas to build custom calculations. Custom calculations allow you to add additional calculations to your report beyond its base objects and standard. calculations, Using functions formulas and calculations in Web Intelligence. Using standard and custom calculations 2013 SAP AG or an SAP affiliate company All rights reserved 7. You add a custom calculation by writing a formula A formula can consist of base report variables functions. operators and calculation contexts, A custom calculation is a formula that can consist of report objects functions and operators Formulas have a. calculation context that you can specify explicitly if you choose. Showing average revenue per sale, If you have a report with Sales Revenue and Number Sold objects and you want to add revenue per sale to the. report The calculation Sales Revenue Number Sold gives this value by dividing the revenue by the. number of items sold in order to give the revenue per item. Related Information,Calculation contexts defined page 16.
3 2 1 Using variables to simplify formulas, If a formula is complex you can use variables to simplify it By using variables you break a complex formula down. into manageable parts and make it much easier to read as well as making building formulas much less error. You can use previously created variables in a formula in exactly the same way as you use other report objects. Variables appear in the formula editor under the Variables folder. You can type this variable name into a formula or drag the variable to the Formula toolbar as you would for any. report object,Related Information, Simplifying a variance formula with variables page 13. 3 3 Working with functions, A custom calculation sometimes contains report objects only for example Sales Revenue Number of. Sales Calculations can also include functions in addition to report objects. A function receives zero or more values as input and returns output based on those values For example the Sum. function totals all the values in a measure and outputs the result The formula Sum Sales Revenue outputs. a total of sales revenues In this case the function input is the Sales Revenue measure and the output is the total. of all Sales Measures,Related Information,Function and formula operators page 14. Functions page 43, Using functions formulas and calculations in Web Intelligence.
8 2013 SAP AG or an SAP affiliate company All rights reserved Using standard and custom calculations. 3 3 1 Including functions in cells, The text in report cells always begins with Literal text appears in quotation marks while formulas appear. without quotation marks For example the formula Average Revenue appears in a cell as. Average Revenue The text Average Revenue appears as Average Revenue. You can use text alone in a cell or mix formulas and text by using the operator If you want a cell to display the. average revenue preceded by the text Average Revenue the cell text is as follows Average Revenue. Average Revenue, Note the space at the end of the text string so that the text and the value are not placed directly side by side in the. 3 3 2 Function syntax, To use a function you need to know its name how many input values it requires and the data types of these input. values You also need to know the type of data that the function outputs. For example the Sum function takes a numerical object as input for example a measure showing sales revenue. and outputs numeric data the sum of all the values of the measure object. Here is the syntax of the Abs function,num Abs number. This syntax tells you that the Abs function takes a single number as input and returns a number as output. The Formula Editor displays the function syntax when you select the function. 3 3 3 Examples of functions, Showing prompt input with the UserResponse function.
You have a report showing Year Quarter and Sales revenue The State object also appears in the report data. although it is not displayed When the user runs the report they are presented with a prompt and they must. choose a state You want to show the state that they have chosen in the report title If your data provider is. called eFashion and the text in the prompt is Choose a State the formula for the title is. Quarterly Revenues for UserResponse eFashion Choose a State. The report is as follows when the user has chosen Illinois as the state when refreshing the data provider. Using functions formulas and calculations in Web Intelligence. Using standard and custom calculations 2013 SAP AG or an SAP affiliate company All rights reserved 9. Calculating a percentage using the Percentage function. The Percentage function calculates percentages This function calculates the percentage of a number in. relation to its surrounding context For example the following table shows revenues by year and quarter The. percentage column contains the formula Percentage Sales Revenue. Using functions formulas and calculations in Web Intelligence. 10 2013 SAP AG or an SAP affiliate company All rights reserved Using standard and custom calculations. In this case the function calculates each revenue as a percentage of the total revenue The surrounding context. is the total revenue this is the only revenue figure that is relevant outside the breakdown by year and quarter in. If the report is split into sections by year the surrounding context outside the table becomes the total revenue. in the section, If the Percentage cell is placed outside the table but still inside the section the surrounding context becomes. the total revenue In this case the Percentage function calculates the total revenue for the section as a. percentage of the total overall revenue, Using functions formulas and calculations in Web Intelligence. Using standard and custom calculations 2013 SAP AG or an SAP affiliate company All rights reserved 11. Calculating a percentage using the Sum function, You can gain more control over the context in which a percentage is calculated by using the Sum function. rather than the Percentage function If you divide one figure in a set of figures by the total of those figures you. get its percentage of the total for example the formula Sales Revenue Sum Sales Revenue gives the sales. revenue as a percentage of the total revenue, In the following table the Percentage of Total column has the formula. Sales revenue Sum Sales revenue In Report,and the Percentage of Year column has the formula.
Sales revenue Sum Sales revenue In Section, These formulas take advantage of the extended syntax keywords Report and Section to instruct the Sum. function to calculate the overall total revenue and yearly revenue respectively. Using functions formulas and calculations in Web Intelligence. 12 2013 SAP AG or an SAP affiliate company All rights reserved Using standard and custom calculations. SAP BusinessObjects Business Intelligence Suite Document Version 4 0 Support Package 5 2013 10 31 Using functions formulas and calculations in Web Intelligence

Related Books

ACT IR224UN ACT IR424UN USB to RAW SIR Serial Adapter

ACT IR224UN ACT IR424UN USB to RAW SIR Serial Adapter

ACT IR224UN is an USB to raw IR adapter which can generate a virtual COM port for user to transmit data with other raw IR devices without IrDA protocols required And its driver will help user to make IR connection without changing any Application Program in PC which is only equipped with USB for COM port access ACT IR424UN is the thumb size

TOYOTA National Highway Traffic Safety Administration

TOYOTA National Highway Traffic Safety Administration

class action lawsuit involving certain 2009 and 2010 Toyota Corolla vehicles excluding the XRS grade equipped with an electric power steering system was approved Background The class action settlement relates to certain 2009 and 2010 Toyota Corolla vehicles excluding the XRS grade equipped with an electric power steering EPS system which hasbeen alleged to cause vehicles to wander

Toyota Demand Chain Management WordPress com

Toyota Demand Chain Management WordPress com

Toyota Demand Chain Management GS 42 p 2 As of March 2002 besides its own 12 plants and 11 manufacturing subsidiaries and affiliates in Japan Toyota has 45 manufacturing companies in 26 countries and regions which produce Lexus and Toyota brand vehicles and components Exhibit 1 employs 264 100 people worldwide on a consolidated basis and markets vehicles in more than 160 countries

www toyota com COROLLA

www toyota com COROLLA

COROLLA 2010 T hank you for purchasing a Toyota vehicle We know you have many options when considering which vehicle to buy and we appreciate your decision to select Toyota We want you to enjoy owning your Toyota as much as you enjoy driving it This booklet is designed to help Here you ll find information on Toyota s warranty coverage and maintenance recommendations for your vehicle

Toyota 2010 Keyless Entry System

Toyota 2010 Keyless Entry System

Toyota Corolla 2010 Keyless Entry System Part Number 00016 32901 Code KE1 Conflicts Vehicle Service Parts may be required for reassembly Keyless Entry Control Module Kit Contents proceed until process has been complied with Hardware Bag Contents SPECIALNOTE After TMS and Safety mandated preparatory steps have been

Dear Boys and Girls Scholastic Canada

Dear Boys and Girls Scholastic Canada

Dear Boys and Girls How to Tame a Bully was the first chapter book I wrote Before that I wrote three Farmer Joe picture books And while I loved writing about Farmer Joe I wanted to try something a little different How to Tame a Bully was the result of that You might think that when I was a little kid I was bullied Not so I had a great childhood I always had tons of friends to play

Bullying Film Education

Bullying Film Education

Bullying Leslie liked to make up stories about the giants that threatened the peace of Terabithia but they both knew that the real giant in their lives was Janice Avery Bridge to Terabithia Katherine Paterson Puffin 1995 Unfortunately most of us have experienced bullying at some point in our lives either as a victim a bully or a bystander For Jess and Leslie in Bridge to

Bullying Interventions in schools Six major approaches

Bullying Interventions in schools Six major approaches

Bully You must be stupid to keep agreeing with me Target That s true Bully You keep saying that s true Target That s true In the next part of this exercise reply by asking a question which can surprise and put the bully on the back foot Look at at the bully with mild curiosity Bully You are such an idiot Target Why do you think so Wait for the answer Bully Everybody

CRITICAL CARE MEDICINE American Board of Internal Medicine

CRITICAL CARE MEDICINE American Board of Internal Medicine

Critical Care Medicine MOC exam blueprint Based on feedback from physicians that MOC assessments should better reflect what they see in practice in 2016 the American Board of Internal Medicine ABIM invited all certified Critical Care Medicine specialists to provide ratings of the relative frequency and importance of blueprint topics in practice This review process which resulted in a new

critical care medicine review notes

critical care medicine review notes

Critical Care Board Study Notes 2014 h www heart lung org JEK Critical Care Medicine Review Notes 3 CARDIAC RESUSCITATION The quality of CPR is associated with survival to discharge for in house arrest It is not the application of an AED which has been studied 40 of chest compressions in house are of insufficient depth there is a long period of time during codes when health care providers

Critical Care ACCP

Critical Care ACCP

Critical Care Christopher A Paciullo Pharm D BCPS FCCM Emory University Hospital Atlanta Georgia C pdpatesCt i ACCP Udates in Therapeutics 2015 The Pharmacotherapy Preparatory Review Recertification Course 1 218 Learning Objectives 1 Interpret hemodynamic parameters and acid base status in critically ill patients 2 Differentiate between presentation of and treat ment strategies