Sap BI: Installation Of BW Standard Content

BI Content:

BI Content gives chose parts inside an organization with the data that they have to do their assignments. SAP NetWeaver Business Warehouse conveys pre-designed approval objects under the aggregate term BI content. To comprehend this we take a case of a business chief, who needs all the data like deals, piece of the overall industry, item quality, deals and administration cost and so forth… to empower him to settle on successful choice. A BI content part will unite this information as exercise manuals and questions conveying precisely the data the business administrator needs. No touchy and private data from the HR office are appeared to him

Benefits Of  BI Content:

Underneath said are the advantages of utilizing BI Content.

• Be utilized as a part of specific commercial ventures without being altered

• Be adjusted, which means you can redo it to any level of point of interest

• Serve as a layout or a case for client characterized Business Content

• Prompt access to translated data.

• Prepared to-go reports, information models, extractors, changes

• Huge chop down of usage time and expenses

• Consistency of operational procedures with administration forms

• Effortlessly extensible

• Programmed upgrades to the data model

• Information consistency and honesty

• Rich arrangement of standard key execution markers

Business Content incorporates:

• SAP extractor programs

• Information Sources

• Process Chains

• Info Objects

• Info Sources

• Information targets (Info Cubes and DSO objects)

• Variables

• Inquiries

• Exercise manuals

• Changes and Update Rules

• Web layouts

• oles

Activation Of  BI Content:

Ventures to see and enact objects accessible by means of BI Content:

Step 1:

• Go to Transaction Code RSA1.

• Click the "alright" catch.

   
Step 2:

• Skim to the tab "BI Content".

• Click on "Item Types."

Step 3:

You can skim the BI Content utilizing distinctive perspectives. In connected screenshot, the substance is assembled by "Article Type".

• Click on "Select Objects" for required Object Type. Every item sort is implied for an alternate part in an organiztion

• In the resulting screen, select the required items.

• Click on"Transfer Selection".

Step 4:

The chose articles and every one of the items on which they are reliant are included progressively.

• Select/deselect required articles

• Click on "Introduce" Button

• Click on Install starting from the drop.

Folkstrain offers a best online training for sap bi in usa, uk and globally with professionals on your flexible timings with experts@ sap bi online training

Sap BI: Load Transaction Data From Flat File

Load Transaction Data From Flat File:

We will figure out how to stack value-based information from a Flat File with the assistance of a situation.

Situation: Load information to the DSO named "DEMO_DSO". The DSO has the accompanying fields.

Key Fields:

• ZCUST - Customer

• ZMAT – Material

Information Fields:

• ZPRICE – Material Price

• Gives look access to the Steps to Load information to DSO from Flat record

Step 1: Create source framework for level document.

• Go to exchange code RSA1

• Click the OK catch.                     

In the following screen,

• Explore to Modeling tab->Source Systems.

• Right tap on the organizer named FILE and pick "Make" from the setting menu.

In the following screen,

• Enter the Logical System Name.

• Enter the Description.Click Continue Button.

 
Step 2: Create Application segment.

• Go to exchange code RSA1

• Click the OK catch.

• Explore to Modeling tab->Data Sources.

• Pick the Source System.

• Right snap - > Create Application Component.    

• Enter the Technical Name.

• Enter the Description.

• Click Continue.

Step 3: Create Data Source.

• Go to exchange code RSA1

• Click the OK catch.

 

• Explore to Modeling tab->Data Sources.

• Right snap - > Create Data Source.

• Enter Technical Name.

• Pick the DataType DataSource.

• Click Continue.

• Enter the Fields demonstrated as follows. This Structure ought to be the same as the DSO to which exchange information is to be stacked.    

• In the Extraction tab, pick the Adapter as "Burden Text-Type File from Local Workstation".

• Pick the record way where the level document to be stacked is set in the framework and enact information source.

Step 4: Create change between Data Source(Source) and DSO(Target).

• Go to exchange code RSA1.

• Click the OK catch.

• Explore to Modeling tab->InfoProvider.

• Make Transformation.

  

• Enter Target Object Type.

• Enter Target Object Name.

• Enter Source Object Type.

• Enter Source Object Name.

• Enter the Source System.

• Click Continue.

• Beneath screen demonstrates the change made with programmed mapping of the Source fields to the Target fields.

   
Step 5: Create Data Transfer Process.

• Right-Click on DTP envelope and pick the alternative "Make Data Transfer Process" from the setting menu.

  

• Beneath screen demonstrates the DTP made.

   
Step 6: Create Infopackage and Schedule dataload to the DataSource(PSA).      

• Go to exchange code RSA1.

• Click the OK catch.

 

• Explore to Modeling tab->DataSources.

• Right tap on the DataSource - > Create InfoPackage.

   

• Enter the InfoPackage Description.

• Click Save.

   

• Click on Schedule tab.

• Click Start catch to begin the heap from the level record to the Data Source.

  
Step 7: Load information to the DSO.

• Click Execute tab in the DTP.

• Click the Execute Button to begin information load from the DataSource(PSA) to the DSO.

     
Folkstrain offers  a best online training for sap bi in usa, uk and globally with professionals in usa, uk and globally with professionals@ sap bi online training

Sap BI: Characterstics Settings

SAP BI:
SAP BI (Business Intelligence) is a leading data warehousing and reporting tool. It helps convert raw data into information and insights that help improve business margins. This course is geared to make a BI expert

Characteristics Settings – Display Name:
As a matter of course, when a trademark is added to the inquiry, it shows the portrayal indicated in SAP BW. It is conceivable to supplant this with redid content as takes after.

• Click on Properties

• Select the General tab

• Enter Description

Characteristics Settings – Display Properties: 
Select the Display tab of the properties window of the chose trademark.

The "Showcase as" choice is utilized to show either just the Key or just Text or both Key and Text.

In the event that a trademark has 2 or a greater amount of Short/Medium/Long Text populated, "Content View" is utilized to show relating content.

It is conceivable to sort information rising/diving either by the trademark or any of its properties.

The "Outcome Rows" choice is utilized to appear or conceal sub-all out for fundamental trademark.

            

Characteristics Settings – Display Records:
The showcase choice is utilized to characterize what information is seen by client amid information determination (in channels) and after report execution.

• Select the Advanced tab of the properties window of the chose trademark.

• Access Type for Result Values. Pick one of these qualities.

• "Posted qualities" is utilized to demonstrate just records that have a few exchanges connected with them

• "Expert Data" shows all expert information records regardless of whether an exchange exists for them or not. It is insufficient if utilized with zero concealment.

Channel Value Selection. Pick one of these qualities.

• Just Posted Values for Navigation: The framework shows just posted qualities from the current navigational state.

• Just Values in InfoProvider: The framework shows just values contained in the InfoProvider.

• Values in Master Data Table: It is quicker, yet may bring about zero records coordinating choice criteria.

           

Folkstrain offers a best online training for sap bi in usa, uk and globally with real time experts. On your flexible timings with professionals@ sap bi online training

Sap Bi: Infocube And Creation Of Standard Infocube

Infocube:

Infocube is information stockpiling range in which we keep up information which we are removing from source framework physically. An InfoCube can work as both an information target and an InfoProvider. From a reporting perspective, an Infocube can be portrayed as an independent dataset.

For instance, a Sales Amount Infocube which has measurements like MONTH – PRODUCT-CUSTOMER-REGION, can be seen by any of the tomahawks, for instance all out deals by locale or by client. The measurements of an Info-Cube are elements or chains of command.

BIW ( Business Intelligence Warehouse) gives office to characterize 16 measurements, out of which 3 are pre-characterized.

Steps To Create Standard Infocube:

Step 1:
Make InfoCube

• Go to exchange code RSA1

• Click the OK catch.

Step 2:

• Explore to Modeling tab->InfoProvider.

• Right tap on InfoArea.

• Click on "Make InfoCube" from the setting menu.

Step 3:

• Enter the Technical Name.

• Enter the Description.

• Pick the choice catch "Standard InfoCube".

• Click the make catch

Step 4:

Right Click on Dimension 1 - > Properties.

 

 

Step 5:
Rename the Dimension according to Info object data.




 

Step 6:
Right tap on the Dimension - >InfoObject Direct Input to Insert InfoObjects into the Dimension. 

 

Step 7:

Select Characteristics.



Step 8: 

• Select Airline ID in qualities

• Move and customize it into Dimension

Step 9:

Correspondingly make new measurements and take after the strides 4-8 to include the InfoObjects.
 
Step 10:

Including Key figureInfoObjects in the Infocube

Step 11:

Take after the proesses above to include more Key Figures
 
Step 12:

Initiate the Infocube.


Infocube Additional Points:

The specialized name of the dimensional table is alloted by the framework, utilizing the example/BIC/"D<your Infocube>#", where the primary # will be a1, the second a 2, etc.

• On the off chance that it is a sap conveyed 3D shape, then it would start as/BI0/D

• Qualities Infoobjects can be uninhibitedly added to client made measurements.

• Measurement Tables ought to be utilized ideally.

Guarantee ideal cardinality while adding qualities infoobject to dimensions.E.g. A departmental store has 10,000 clients and 1000 distinct materials. The cardinality is m:n, which implies every client can purchase numerous materials. Such sort of cardinality ought not be kept up in the same measurement table.

Folkstrain offers a best online training for sap bi in usa, uk and globally with real time experts. On your flexible timings with professionals@ sap bi online training