1. How you are going to Debug?
By Using T-Code RSRT and open the Query and select Execute + Debug
At DTP we will set breakpoints in Extraction tab
2. What is Time Stamp Error?
The “Time Stamp” Error occurs when the Transfer Rules or Transfer Structure are internally inactive in the system.
They can also occur whenever the DataSources are changed on the R/3 side or the
DataMarts are changed in BW side. In that case, the Transfer Rules is showing active status
when checked. But they are actually not, it happens because the time stamp between the
DataSource and the Transfer Rules are different.
3. Where will u set Exception Aggregation and at which level?
At BEx Level I am going to use This Exception Aggregation.
Properties ----> Aggregation
4. Clear explanation on Replacement Path and Customer Exit variable processing types by taking a real time scenario?
Replacement Path: It is used to Calculate the Difference between Created date and Changed
date in BW or BI Reports.
Using Formula Variables with replacement path in BEx reports we can achieve it. Create one formula variable with replacement path on Created Date Character and another formula
variable with replacement path on Changed Date, then create a formula and just do simple subtraction in report.
Customer Exit: My Client wants to see the Sales Report like Month to Date format
If suppose the user runs the Sales Report on 7th April 20014, then the Report should show from 1st April to 6th April data...
Similarly if the user runs the Report on 1st day of any month the Report should show last month data.To achieve this we are going to use Customer Exit variable.
5. How will u see delta records in a DSO?
We can see Delta Records in Change Log table in the DSO.
6. It possible to use Multiprovider on the top of single Infocube? Suppose, if we use Multiprovider on top is it possible to improve the Performance or not?
We can create Multiprovider on one Infocube and Multiprovider is used to fetch data from different targets
By Using T-Code RSRT and open the Query and select Execute + Debug
At DTP we will set breakpoints in Extraction tab
2. What is Time Stamp Error?
The “Time Stamp” Error occurs when the Transfer Rules or Transfer Structure are internally inactive in the system.
They can also occur whenever the DataSources are changed on the R/3 side or the
DataMarts are changed in BW side. In that case, the Transfer Rules is showing active status
when checked. But they are actually not, it happens because the time stamp between the
DataSource and the Transfer Rules are different.
3. Where will u set Exception Aggregation and at which level?
At BEx Level I am going to use This Exception Aggregation.
Properties ----> Aggregation
4. Clear explanation on Replacement Path and Customer Exit variable processing types by taking a real time scenario?
Replacement Path: It is used to Calculate the Difference between Created date and Changed
date in BW or BI Reports.
Using Formula Variables with replacement path in BEx reports we can achieve it. Create one formula variable with replacement path on Created Date Character and another formula
variable with replacement path on Changed Date, then create a formula and just do simple subtraction in report.
Customer Exit: My Client wants to see the Sales Report like Month to Date format
If suppose the user runs the Sales Report on 7th April 20014, then the Report should show from 1st April to 6th April data...
Similarly if the user runs the Report on 1st day of any month the Report should show last month data.To achieve this we are going to use Customer Exit variable.
5. How will u see delta records in a DSO?
We can see Delta Records in Change Log table in the DSO.
6. It possible to use Multiprovider on the top of single Infocube? Suppose, if we use Multiprovider on top is it possible to improve the Performance or not?
We can create Multiprovider on one Infocube and Multiprovider is used to fetch data from different targets