1-1. What is SAP BW / BI?

Business Warehouse

Business Intelligence

1-2. AMOREPACIFIC BI Architecture

1-3. SAP Data Cycle

1-4. Object Modeling

1-5. Cube Area & Report Naming Rule

1-6. Simple Example

User Manual

Log-on the service
1. Go to Analysis > Select Data Sources > Insert Data source for Analysis 

2. Select BWP server on the list, Enter your credentials.
- Client  : 100

- Language  : EN

Search the report

You can search report with technical name & description.

[Search]                     

Main Report
- Net Sales   : S_ZSD_001_Q0058  [Std] Net Sales by Brand/Channel
- Stock  : S_ZCM_002_Q0053  [Std] Stock & Slow moving
- POS Sales  : S_ZSD_702_Q0013  [Std] Sell-Thru Analysis by POS receipt
- P&L  : S_ZCO_408_Q0001  [Std] New P&L

Prompts

Design Panel

[Analysis] 

 [Components]

Drill Down

Filter by Member

Filter by Measure

Key & Text

You can choose display option for characteristic. ( Key / Text / Key & Text )

[Option 1]

-Choose characteristic on your report. -Change display option at Analysis tab > Member.

[Option 2]

-Right Click on characteristic -Change display option at Member.

Repeat Members

BI Report shows text information only 1 time for same data level. (Default Option)

But If you need to fill-out text information for all lines, you can activate “Repeat Members” or “Repeat Titles” option

[Option] Analysis Design > Crosstab > Repeat Members

Total

You can change total option for each characteristic.

[Option 1] Right click on “Overall Result” > Totals > Change total option.



 

[Option 2] Choose your characteristic, Change option at Analysis > Totals.

Number Format / Scaling

- Choose measure line which you need to change display option. 
- Go to Analysis > Measures > Number Format
- Change “Scaling Factor”, “Decimal Places” option
   * If you change scaling factor by using this menu, scaling factor in prompts should be entered as 1. 
 


Currency Translation
-Go to Analysis > Measures > Currency Translation -You can choose “Target currency” & “Currency Conversion Type”
* Local Currency à KRW conversion only supported. 
* If you change currency conversion with this menu, currency condition should be removed in prompts.

 

Master Characteristic

If a characteristic have a master data, you can add its components as attributes.

Expand Node to Level

In case of New P&L report, Measure is shown as structure with hierarchy level.

User should expand node manually to check sub-level data.

“Expand Node to Level” menu helps user to expand node at once.

[Option] Right Click on node with [ + ] label > Expand Node to Level > Select Level. 
           * If you choose the largest number, all structure will be expanded for selected node.

Save & Refresh

You can save SAP BI file just like excel file.

Next time when you refresh BI file, just click “Refresh All” or Click “Prompts” button and update condition.

Prompts Option

1. Prompts for Workbook  : Check All report prompts in excel file. 

2. Prompts for Data Source  : Check specific report prompts in selected cell.

Smart Copy & Smart Paste

If you need to insert BI report with same condition but different layout, you can copy it easily with smart copy & paste function.

[Option]

-Choose BI report you want to copy. -Go to Analysis Design > Smart Copy 

-Choose excel cell you want to paste. 

-Go to Analysis Design > Smart Paste

Delete / Move BI Report

Change Report Position

-Go to “Components” tab -Expand + button on BI report. 

-Click “Crosstab” node, then you can check cell position of selected report. 

-Right Click on “Crosstab” > “Move To” 

-Input new position.

Delete / Move BI Report

Delete Report

-Go to “Components” tab 

-Right Click on BI report name > “Delete”