1.find the structure of the datasource and goto se11 using 
append structure add the require fileds to the structure 
and activate
2.goto rsa6 select ur datasource and click on change icon 
and unhide the fileds and generate the datasoure.
3. goto tcode cmod create a project and assign RSRA0001
write the require code in the standard Include.

mostly right,but the enhancement name is RSAP0001

DTP: data Transfer processing 
simply says.. we r transfering data from PSA to data 
tragets...or data targets to data targets.

In BW 3.5 we had Infopackage to pull the data at all the 
lavels, but now in BI 7.0 Infopackage pull the data only 
till datasource/PSA from source thereafter we need to 
create the transformation and DTP to pull the data. 

So we can say that DTP is used to push the data from one 
target to another data target.

Thanks
Mayank

Postprocessing is the process of tranforming the data after 
it is staged in BW (PSA or DSO). It is purely a business 
decision.

RSMO: monitering the 
RSPC: for creating process chains
RSPCM: moniter daily process chains

This all Data targets.We used for analysis &reporting purpose.

A DataStore object is used to store consolidated and 
cleansed data (transaction data or master data) on a 
document level (atomic level). 

SAP BI distinguishes between three DataStore object types: 
Standard, Write Optimized, and Direct Update.

It serves as a storage location for consolidated and 
cleansed transaction data or master data on a document 
level.
there are three types of DSO's

Standard DSO
Direct Update DSO
Write Optimised DSO

DSO is same as ODS..data source object 
there are three type of DSO's

remove the process chain from schedule when rollup of the 
process chain in progress or remove the step of the 
collapse in the process chain or if we dont want to do the 
Aggregate compression then remove the check mark in the 
rollup step for collapse.

The report/report interface (RRI) makes the parameterized 
call of programs possible from other programs. It gives the 
user the ability to jump from one report into another 
report that supplies further information. In SAP BI, you 
can arrive at branch destinations within and outside of the 
BI system.

With the report/report interface, you can create several 
individual reports, each with a limited number of 
characteristics. These can be linked one to another to
make very flexible data evaluations possible online.

i will try to get the RRI structure and conditions ASAP....

RRI stands for Report to report Interphase.
You can Link other queries to 1 query by using RSBBS T-code.
This is basically to jump ffrom one query to another.

In case of queued delta LUW's r posted to extractor queue 
by scheduling V3job we move the documents from Extactor 
queue to Delta queue and we extract LUW's from Deltaqueue 
to SAP BW by running Delta loadsQueued delta maintains 
Extractor log to handle the LUW's which r missed.


In case of Direct delta LUW's r directly posted to Delta 
Queue(RSA7)and we extact the LUW's from DeltaQueue to SAP 
BW by running Delta loads.It degrades the OLTP performance 
becoz when LUW's r directly posted to DeltaQueue the 
application is kept waiting until all the enhancement code 
is executed.

in queued delta, the data comes first to extractor queue 
(LBWQ) and then upon following processing it move to delta 
queue.This Load is processed once data is queued with 10000 
LUW.
In Direct delta, Every document is one LUW and it comes 
direcly to delta queue(RSA7) and upon requent it is 
extracted to BW.

We can collapse the process in process chain manually.

There is not a single particular transaction code that is 
used in production support. For e.g. in a day you might use
ST22, ST03N, SE11, SE16, RSA1, RSPC etc..

This means the dimension contains precisely one 
characteristic. This means that the system does not create 
a dimension table. Instead, the SID table of the 
characteristic takes on the role of dimension table.

When dimension table size equals or exceeds the fact table 
at that point time we need to use the line item dimension. 

If we use Line item dimension our fact table contains SID 
instead of dimension ID.

For maintaining L.I.D we have to create only one object in 
dimension table.

Line item dmension is a single chracteristic considered as 
a dimension.When size of dimension table is greater then 
10% of the size of fact table then we create line item 
dimension