Business Intelligence Types


Web Intelligence on top of SAP NetWeaver BI:
Web Intelligence connectivity:

BI metadata featureSAP OLAP BAPI support level
Characteristics (incl. Time and Unit)InfoCube/BI Query
HierarchiesInfoCube/BI Query
Basic Key FiguresInfoCube/BI Query
Navigational AttributesBI Query only
Display AttributesInfoCube/BI Query
Calculated Key Figures / FormulasBI Query only
Restricted Key FiguresBI Query only
Custom StructuresBI Query only
VariablesBI Query only


Web Intelligence / OLAP Universes: Connectivity towards BI queries
  • Queries need to be configured to “Allow external access”
  • Consider Crystal Reports for a direct ODS / DSA access (Direct BAPI access)
Connectivity towards InfoProvider level
  • Consider the different sets of meta-data exposure
  • Consider BI Authorizations / Authorization variables


SAP BI elementUniverse object
Universe object
Dimension 		Class
CharacteristicSubclass with dimension and detail objects
Characteristic with hierarchyBI Query: Subclass containing dimension and detail objects for each hierarchy level in the currently defined hierarchy. BI InfoProvider: Subclasses containing dimension and detail objects for each hierarchy level for all hierarchies defined for the characteristic
Structure based on Characteristics (BEx Queries only) Class with single dimension object for the structure
Navigational attributeSubclass with dimension and detail objects (identical to characteristic)
Display AttributeDetail object for the dimension
Key FigureMeasure object in the class for the Key Figure structure with dimension objects for units/currency, numeric value and formatted value (based on User preferences)
Calculated Key Figure (BEx Queries only)Measure and dimension objects (same as Key Figure)
Restricted Key Figure (BEx Queries only)Measure and dimension objects (same as Key Figure)
Variables (BEx Queries only)Pre-defined Filter in the Universe
In the class for the dimension to which the variable applies, two dimension objects supporting the list of values, one for caption, one for description.
Key date variable (BEx Queries only)Universe parameters defining key date variable in the universe

SAP Variables and Web Intelligence filter

The following types of BI variables are supported in universes:
  • Characteristic variables
  • Hierarchy variables
  • Hierarchy node variables
  • Currency variables
  • Formula variables
  • Text variables (as replacement path and authorization processed variables)
  • Key date variables

Variable Type Processing Type
User Entry / Default Value Replacement Path
AuthorizationCustomer ExitSAP Exit
Characteristics Support Support Support Support Support
Text Not Support Support N/A N/A N/A
Formula Support Support N/A Support Support
Hierarchy Support N/A N/A Support Support
Hierarchy Node Support N/A N/A Support Support

Comments

Post a Comment

Popular posts from this blog

One stage stop to know all about BW Extractors-Part1

Image
Types of Extractors:               Application specific BW content extractors: Lo Extraction: Logistics refers to the process of getting a product or service to its desired location upon request which involves transportation, purchasing, warehousing etc. Main areas in logistics are: Sales and Distribution (SD) : application 11, 13, 08 (in LBWE T-code) Materials Management (MM) : application 03, 02 Logistics Execution (LE) : application 12 Quality Management : application 05 Plant Maintenance (PM) : application 04, 17 Customer Service (CS) : application 18 Project System (PS) : application 20 SAP Retail : application 40,43,44,45 How the data extraction happens? Extraction can be done using either Full update/delta update. Full load: Incase of l...
Read more

COPA Extraction Step By Step in SAP BW

Image
COPA Extraction Step by Step: SAP R/3 or SAP ECC: 1. SAP R/3 or ECC goto T.Code KEB0 , In Function: Select Create  Control Parameters: Provide a New CO-PA DataSource Name:1_CO_PA%CL%ERK 2. Select your O perating C oncern, e.g.,IDES. 3. Select radio button Costing-based or Account-based as OC . 4.Select field names for partitioning.e.g. BUKRS (Company Code), Check 5.Click on Info Catalog (F7) 6. Select the Characteristics & Value fields & Keyfigures 7. Select the Package/Development Class for Workbench request 8. Edit your DataSource to select/Hide fields, Save. Datasource created successfully. 9. Extractor Checker or RSA3, extraction. SAP BW:   1. Replicate DataSource 2. Assign InfoSource 3. Transfer all the datasource elements to an InfoSource 4. Activate InfoSource 5. Create a InfoCube (Copy Str from InfoSource) 6. Create Dimension & Define and Assign it. 7. Check & Activate. 8. Create Transformati...
Read more

SAP BW Reporting Variables:Customer Exit

Examples: Customer Variable Exit Documentation With this enhancement to global variables in reporting you have the option of determining your default values for variables. You can use this enhancement for variables, for which 'Processing by Customer-Exit' has been selected in the variable maintenance. This is valid for all variable types (characteristic value, node, hierarchy, formula and text variables). You use the Exit EXIT_SAPLRRS0_001 for this. You could, for example, establish the default value of a characteristic value variable depending on the user. Depending on the variable type, the fields LOW, HIGH, SIGN and OPT of the internal table E_T_RANGE must be filled as follows: LOW Single value or lower interval limit (characteristic variable) Text (Text variable) Formula value (Formula variable) Hierarchy name (Hierarchy variable) Hierarchy node (Hierarchy node variable) HIGH Upper interval limit (char. variable with interval) I...
Read more