Scenario : Distribute Keyfigure values into formula elements and reprsent them in report by separate coulmn.
suppose the key figure is having 0 to 500 values then i want to make a distribution as follows:
0-50 formula 1
50-100 formula 2
100-200 formula 3
and so on--

Solution: Using boolean options in BEx we can achive this.
Create new formula and use one of below conditions:

Formula1 : ((keyfigur) => 0 * (keyfigure) <= 50) * keyfigure
Formula2 : ((keyfigur) => 51 * (keyfigure) <= 100) * keyfigure
Formula1 : ((keyfigur) => 101 * (keyfigure) <= 200) * keyfigure
Formula1 : ((keyfigur) => 20 * (keyfigure) <= 300) * keyfigure
and so on ....

More info refer to link : https://forums.sdn.sap.com/thread.jspa?threadID=635618&tstart=0

Scenario : Create and Populate User Exit Variable with default date as current date.

Step1: Create a variable(ex: cur_date) on requrired characteristic with Processing type "Customer Eixt" and check the check box for ready for input(if this variable need in selection screen).

Step 2: Goto T Code : CMOD and provide appropriate Project and choose components and click on display.

Step3: Double click on exit "EXIT_SAPLRRS0_001" you can see include "ZXRSRU01", double click on include.

Step4: Sample code to populate.

WHEN 'CUR_DATE'.
Data : l_p_range_SSS TYPE rrrangesid.

IF I_STEP = 1.
l_p_range_SSS-Low = sy-datum.
l_p_range_SSS-Sign = 'I'.
l_p_range_SSS-Opt = 'EQ'.
APPEND l_p_range_SSS TO e_t_range.
Endif.

The following values are valid for I_STEP:
· I_STEP = 1
Call up takes place directly before variable entry
· I_STEP = 2
Call up takes place directly after variable entry. This step is only started up when the same variable could not be filled at I_STEP=1.
· I_STEP = 3
In this call up, you can check the values of the variables. Triggering an exception (RAISE) causes the variable screen to appear once more. Afterwards, I_STEP=2 is also called up again.
· I_STEP = 0
The enhancement is not called from the variable screen. The call up can come from the authorization check or from the Monitor.

More info @ http://help.sap.com/saphelp_bw320/helpdata/en/1d/ca10d858c2e949ba4a152c44f8128a/content.htm

Documents for sap business warehouse from other web sites

SAP BW BPS Advanced Budgeting Example which gives a glance of BPS Functionality
SAP BW BPS Advanced Budgeting Example

Sap BW Authorizations docs in detail
Sap BW Authorizations

Sap BW BPS Planning Folders and Layouts
Sap BW BPS Planning Folders and Layout

Sap BW Best practices overview Presentation
Sap BW Best practices overview

How to integrate Sap BI with XI PDF
How to integrate Sap BI with XI

Sap BW Netweaver Installation MEDIA_LIST_NETWEAVER
Sap BW Netweaver Installation MEDIA_LIST_NETWEAVER

Online Analytical Processing(OLAP)
Online Analytical Processing(OLAP)

Sap BW Sizing Help for estimating the hardware resources needed
Sap BW Sizing Help

Sap BW Business Explorer(BEX) a detail learning document
Sap BW Business Explorer(BEX)

ABAP Required in Sap BW for ABAP routines,Functional modules in detail
ABAP Required in Sap BW

Sap BI Accelerator for high performance in queries
Sap BI Accelerator

Sap BW Cell editing in Bex
Sap BW Cell editing in Bex

Control and profitability Analysis in SAP BW
Sap BW copa

Exit Function in Sap BW
Exit Function in Sap BW

Sap BW Front End Designing
Sap BW Front End Designing

Sap BW Installation Guide
Sap BW Installation Guide

How to handle inventory in SAP BW
How to handle inventory in SAP BW

Sap BW Transaction Codes (t-codes)
Sap BW Transaction Codes

Sap BW BPS WEB Based Planning
Sap BW BPS WEB Based Planning

Custome Infoobjects Tabels:
/BIC/M -- View of Master data Tables
/BIC/P -- Master data Table, Time Independent attributes
/BIC/Q -- Master data Table, Time Dependent attributes
/BIC/X -- SID Table, Time Independent
/BIC/Y -- SID Tabel, Time Dependent
/BIC/T -- Text Table
/BIC/H -- Heirarchy Table
/BIC/K -- Heirarchy SID Table

Standard Infoobjects Tabels(Buss. Content):
Replace "C" with "0" in above tables.
Ex: /BI0/M -- View of Master data Tables

Standard InfoCUBE Tables :
/BI0/F -- Fact Table(Before Compression)
/BI0/E -- Fact Table(After Compression)
/BI0/P -- Dimension Table - Data Package
/BI0/T -- Dimension Table - Time
/BI0/U -- Dimension Table - Unit
/BI0/1, 2, 3, .......A,B,C,D : -- Dimension Tables

BW Tables:
BTCEVTJOB -- To check List of jobs waiting for events
ROOSOURCE -- Control parameters for Datasource
ROOSFIELD -- Control parameters for Datasource
ROOSPRMSC -- Control parameters for Datasource
ROOSPRMSF -- Control parameters for Datasource
-- More info @ ROOSOURCE weblog
RSOLTPSOURCE -- Replicate Table for OLTP source in BW
RSDMDELTA -- Datamart Delta Management
RSSDLINITSEL, RSSDLINITDEL
-- Last valid Initialization to an OLTP Source
RSUPDINFO -- Infocube to Infosource correlation
RSUPDDAT -- Update rules key figures
RSUPDENQ -- Removal of locks in the update rules
RSUPDFORM -- BW: Update Rules - Formulas - Checking Table
RSUPDINFO -- Update info (status and program)
RSUPDKEY -- Update rule: Key per key figure
RSUPDROUT -- Update rules - ABAP routine - check table
RSUPDSIMULD -- Table for saving simulation data update
RSUPDSIMULH -- Table for saving simulation data header information
RSDCUBEIOBJ -- Infoobjects per Infocube
RSIS -- Infosouce Info
RSUPDINFO -- Update Rules Info
RSTS -- Transfer Rules Info
RSKSFIELD -- Communication Structure fields
RSALLOWEDCHAR -- Special Characters Table(T Code : RSKC, To maintain)
RSDLPSEL -- Selection Table for fields scheduler(Infpak's)
RSDLPIO -- Log data packet no
RSMONICTAB -- Monitor, Data Targets(Infocube/ODS) Table, request related info
RSTSODS -- Operational data store for Transfer structure
RSZELTDIR -- Query Elements
RSZGLOBV -- BEx Variables
RXSELTXREF, RSCOMPDIR -- Reports/query relavent tables
RSCUSTV -- Query settings
RSDIOBJ -- Infoobjects
RSLDPSEL -- Selection table for fields scheduler(Info pak list)
RSMONIPTAB -- InfoPackage for the monitor
RSRWORKBOOK -- Workbooks & related query genunid's
RSRREPDIR -- Contains Genuin id, Rep Name, author, etc...
RSRINDEXT -- Workbook ID & Name
RSREQDONE -- Monitor: Saving of the QM entries
RSSELDONE -- Monitor : Selection for exected requests
RSLDTDONE -- Texts on the requeasted infopacks & groups
RSUICDONE -- BIW: Selection table for user-selection update Infocubes's
RSSDBATCH -- Table for Batch run scheduler
RSLDPDEL -- Selection table for deleting with full update scheduler
RSADMINSV -- RS Administration
RSSDLINIT -- Last Valid Initializations to an OLTP Source
BTCEVTJOB --To check event status(scheduled or not)
VARI -- ABAP Variant related Table
VARIDESC -- Selection Variants: Description
SMQ1 -- QRFC Monitor(Out Bound)
SM13 -- Update Records status

T Code : LBWQ --> QRFC related Tables
TRFCQOUT,
QREFTID,
ARFCSDATA
More info @ Note 728687 - Delta queued: No data in RSA7

BI Performance Tuning

-- Contains all information related to BI performance tuning.

Performance Tuning for SAP BW : pdf

Performance Tuning for Queries with Aggregates : pdf

BEx Front-End Performance: Performance Analyses of BEx Analyzer and Web Application in the Local and Wide Area Networks Environment : pdf

SAP BW Data Load Performance Analysis and Tuning : e learning

-- Need SDN User ID and Password to log-on.