SAP ERP Business Intelligence-BI/BW Training in Pakistan

SAP ERP Business Intelligence-BI/BW

Introduction SAP BI 

sap erp bi/bw training course in lahore islamabad gujranwala gujrat multan okara kasur pakistan online fee and outline
SAP BI

Business knowledge (BI) is an application utilized for offering importance to crude information that an association has. The crude information is purged, put away and applied with business rationales to be helpful for big business clients to settle on better business choices. This information can be introduced as reports and can be shown as tables, diagrams and so forth which is productive and simpler to investigate and settle on business choices. 

During all business exercises, organizations make information about clients, providers and interior exercises. In view of these data's, workers of different offices like HR, Finance, Accounting, Marketing and so forth set up their work plan. 

Business Intelligence traverses a fluctuated set of toolset, of which the Data Ware House solidifies and stacks the information from the diverse Source Systems, while announcing apparatuses like Query Designer, Web Application Designer, and Analyzer are significantly used to make reports which show the information merged by the Data warehouse for investigating reason. 

Business Intelligence is a SAP item which significantly centers around giving its clients/associations with an easy to use and extremely valuable type of addressing information that could be useful for investigations reason and settling on business choices. 

In outline, Business Intelligence devices change crude information into reports which utilized for dynamic and business determining. 

Data warehouse and BI 

Associations have various types of information like account, Human asset, client, provider information and so forth, which can be put away on various types of capacity units, for example, DBMS, Excel sheets, SAP R/3 frameworks etc...Even the organization's inner information is frequently disseminated across a wide range of frameworks and isn't especially very much designed. 

A Data Warehouse can assist with getting sorted out the information. It unites heterogeneous Data Sources which are generally and contrasting in their subtleties. Utilizing BI Tools one can determine significant reports 

What makes SAP BI more viable BI apparatus? 

  • Single mark of admittance to all data is conceivable through BI. The information from different sources can be gotten to at the single place(i.e. BI). 
  • Information gathered from different sources are introduced as reports which is effective for investigation of the information at a significant level. 
  • SAP BI gives simple to utilize GUI and better designing 
  • A portion of the key usefulness that improves SAP BI than rest is its capacity to investigate multidimensional information sources in both web and MS office conditions, adaptable dashboards, portability and an adaptable, versatile BI stage. 
  • SAP BI is known for its wonderful inquiry execution, while requiring little organization 
  • Portable BI for end clients in a hurry 
  • Simple Integration with different stages

SAP BI/BW Architecture: 

BI has three level engineering: 
Information base Server: Where inform is actually put away.( ODS, PSA, Infocube and metadata archive). 
Application Server: The application worker depends on the OLAP processor. It is utilized to recover information put away in the data set worker. 
Introduction Server: Manages announcing and information access. 
  • Information is removed from the Source Systems. 
  • Information is organized at the Persistent Storage Area(PSA). This holds Source like information. 
  • Information is purified, stacked and put away in Data Store Object. 
  • Information is seen at numerous measurements in the Infocube. 
  • Information is accessible by the OLAP processor to the Business Explorer to show information according to Analysis prerequisites of the Business.
  • Information can be made accessible to SAP/Non-SAP, Data Marts by the Open Hub Service.( Info Spoke).

SAP Infoobject, Infoarea, Infoobject Catalog 

What is an InfoObjects? 

Data Objects take data from the source, at that point change and orchestrate the data into either a norm or tweaked report. Infoobjects are the littlest accessible data modules/fields in BI. It is required in data suppliers like InfoCubes, DSOs, MultiProviders, Queries and so on These Info-Providers are comprised of Info-objects. 
Data object gives all data about the business. For example organization 'XYZ' is keen on discovering the amount of "item x" sent on "date x" to "production line x". By characterizing Info-object for explicit capacity like "0MATERIAL", "0DATE" and "0LOCATION" all the data can be recovered. 
InfoObjects can be characterized into the accompanying sorts: 
  • Qualities (for instance, clients) 
  • Key figures (for instance, income) 
  • Units (for instance, cash, sum unit) 
  • Time attributes (for instance, monetary year) 
  • Specialized qualities (for instance, demand number) 
Qualities: 
Qualities are Business reference objects used to break down key figures. 
Instances of attributes InfoObjects: 
  • Cost focus (0COSTCENTER) 
  • Material(0MATERIAL) 
Key figures: 
Key figures give the qualities to be assessed. They are numeric data that is accounted for in the question. 
Instances of key figure InfoObjects: 
  • Amount (0QUANTITY) 
  • Sum (0AMOUNT) 
Units: 
Units are matched with Key figure esteems . They give relegate a unit of estimation to a Key Figure Value. For example 10 Kg where 10 is the Key Figure and Kg is the unit 
Different Examples of Unit Characteristics: 
  • Cash unit (0CURRENCY) (Holds the money sort of the exchange for example $, EUR, USD...) 
  • Worth unit (0UNIT) (or) unit of measure (Hold the unit of measure for example Gallon, Inch, cm, PC) 
Time Characteristic: 
Time qualities give time reference to information. 
Instances of Time Characteristics: 
  • Schedule day (0CALDAY) 
  • Schedule year (0CALYEAR) 
  • Monetary year (0FISCYEAR) 
Specialized Characteristics: 
Specialized qualities are SAP standard items having their own authoritative purposes. 
Instances of Technical Characteristics: 
  • Information Object 0REQUID – While stacking information to different information targets, SAP designates extraordinary numbers which are put away in this Info object 
  • Information Object 0CHNGID – When total change run is done, a novel number is dispensed and put away in this data object. 
Prior to making an Info Object, Info Area and Info Object Catalog should be made. 
What is an InfoArea? 
  • In Business Warehouse, Info-regions are the branches and hubs of a tree structure. 
  • It is utilized to put together information 3D squares and data objects. 
  • Every Info-object is appointed to an Info Area. 
  • Information Area can be considered as an organizer used to hold related documents together. 
What is Infoobject Catalog? 
  • Each data object should be made inside an Info Object Catalog. 
  • It helps in association and is no chance identified with revealing capacities. 
  • Model: There are huge loads of InfoObjects for SAP Financials which can be clubbed into an InfoObject Catalog. This makes the executives and maintainence simple. 
  • An Info Object can be allocated to numerous Catalog 
There are 2 sorts of Info Object Catalog. 
  • Trademark Info Object Catalog 
  • Key figure Info Object Catalog 

The most effective method to Create an Infoarea in SAP BI/BW 

Stage 1) 
  • Go to exchange code RSA1 to go to the Data Warehouse Workbench. 
  • Snap the OK catch. 
Stage 2) 
  • Explore to Modeling - >InfoProvider 
  • Right snap in the Workbench and Create an InfoArea 
Stage 3) 
  • Enter the Technical Name 
  • Enter the Description 
  • Press the enter button 
Stage 4) 
The Info Area made shows up as demonstrated underneath.

Step by step instructions to Create an InfoObject Catalog in SAP BI/BW 

Stage 1) 
  • Go to exchange code RSA1 to go to the Data Warehouse Workbench. 
  • Snap the OK catch. 
Stage 2) 
  • Explore to Modeling - > Infoobjects 
  • Right snap on the Info Area and pick the choice "Make InfoObject Catalog".
Stage 3) 
  • Enter the Technical name of the InfoObject Catalog. 
  • Enter the Description of the InfoObject Catalog. 
  • Snap in the "Trademark InfoObject" choice catch. This is a trademark InfoObject Catalog. Snap the Keyfigure alternative catch. At that point a Keyfigure InfoObject Catalog would be made. 
  • Snap on the make button. 
Save and Activate the InfoObject Catalog.

What is DSO in SAP BW? Why Use It? 

What is DSO? 
A DSO is a two dimensional stockpiling unit which basically stores merged and scrubbed exchange information or expert information on a least granularity. DSO represents Data Store Object. 
  • It is a two dimensional Transparent Table. 
  • Information is put away at definite level. 
  • With DSO, it is additionally conceivable to overwrite information fields. 
  • Point by point level revealing can be acquired from a DSO. 
Lets take an illustration of Sale request Data, which must be separated from SAP R/3 system(OLTP: Online Transaction Processing information which continues to change) into BI. The Sales Orders made in the R/3 framework could be altered anytime of time after formation of the record. At first when deals request records are made in R/3, these records are extricated into BI. When the records are changed in R/3, the progressions should be made in BI. 
  • Information is extricated from SAP R/3 framework and stacked into Data Store Object. 
  • At first, records are put away in New Status in the DSO. Records are put away in the New Table. 
  • When the DSO information is enacted, information is put away in the Active table. The New Table doesn't hold that information any longer. 
  • At the point when records are changed in R/3, for these progressions to reflect in BI, the progressions are separated into the DSO. 
  • Presently the information is put away in the new table until the DSO substance are initiated. The Data must be additionally stacked into Info block from which reports are being conveyed. 
  • DSO has Overwrite and added substance functionalities. If all attributes are same, key figures are collected/overwritten dependent on the usefulness picked. 
  • Shape is added substance in nature. In the event that all attributes are same, key figures are amassed. 
Sorts of DSO 
DSOs can be arranged into the accompanying kinds: 
  • Standard DSO 
  • Direct Update DSO 
  • Compose Optimized DSO

Comments

Post a Comment

Popular posts from this blog

SAP ERP ABAP Training Course in Lahore Pakistan

Image
What is  ABAP ?  ABAP (Advanced Business Application Programming) is a general programming language made by SAP that causes huge enterprises to redo the  SAP ERP . ABAP can help redo work processes for monetary book keeping, materials the executives, resource the board and any remaining modules of SAP. SAP ABAP Query Application The ABAP Query application is utilized to make reports not effectively present in SAP framework . It has been intended for clients with almost no information on the ABAP programming . ABAP Query offers clients an expansive scope of approaches to characterize reports and make various kinds of reports like essential records, insights, and positioned records.  The ABAP Query includes four segments:  Queries InfoSets  Client Groups  Interpretation of Query Queries The Queries segment is utilized by end clients to look after inquiries. One can make queries, change inquiries and execute questions. Transaction SQ01. Info...
Read more

SAP ERP High Performance Analytic Appliance-HANA Training Course in Pakistan

Image
What is SAP HANA ? SAP HANA is the most recent, in-memory data set, and stage which can be sent on-premises or cloud. SAP HANA is a mix of equipment and programming, which coordinates various parts like SAP HANA Database, SAP SLT (System Landscape Transformation) Replication worker, SAP HANA Direct Extractor association and Sybase replication. HANA has exceptional selection by the SAP clients. SAP HANA is equipped for preparing a lot of continuous information in a brief timeframe period. SAP HANA Architecture, Landscape and Sizing SAP HANA Database is Main-Memory driven information the board stage. SAP HANA Database runs on SUSE Linux Enterprises Server and expands on C++ Language.  SAP HANA Database can be dispersed to numerous machines.  SAP HANA Advantages are as referenced beneath -  SAP HANA is valuable as it's extremely quick because of all information stacked in-Memory and no compelling reason to stack information from plate.  SAP HANA can be utilized w...
Read more

SAP ERP Sales & Distribution-SD Training in Pakistan

Image
SAP SD Sales & Distribution What is SAP SD ?   SAP SD SAP Sales and Distribution ( SD ) is a significant module of SAP ERP comprising of business measures needed in selling, transporting, charging of an item. The module is firmly incorporated with SAP MM and SAP PP . Key sub-modules of SAP SD are Customer and Vendor Master Data, Sales, Delivery, Billing, Pricing, and Credit Management. Highlights of SAP SD module  Here are some significant highlights of the SAP SD module :  Cost and Taxation: – It causes you to assess the cost of merchandise and enterprises under different conditions like refund or markdown, which is conceded to a client.  Accessibility Check: Check the accessibility of an item in the stockroom of an association.  Charging and Invoice: Helps you to create bills or solicitations.  Material Determination: Helps you to decide the subtleties of materials based on a specific condition.  Credit Management: It is a technique for deal...
Read more