Extracting data from generic data sources to SAP BI/BW is called generic extraction. If SAP has not delivered standard datasource, create generic data source i.e. based on reporting requirements we have to do thorough extractor (data source) analysis. If no data source is suitable for your reporting requirement create generic data source.
Scenario : My client requirement is he wants to see sales document flow.
It is present in VBFA table it doesn’t have SAP standard data source, so I have created generic datasource using table.
Example : VBFA, VBPA
2. What are the problems you faced in Flat File ?
We might get an error if the flat file is open and when try to execute DTP.
If the flat is saved as .xls instead of .csv the output data will be scrambled.
We will be able to see the data in the PSA, but we cant see the data in the DTP if the transformation is inactive.
If the flat file contains lower case letters and if we don’t tick case sensitive when creating infoobject we will get error.
If we don't assign the InfoObjects in the DataSource in the same order as the flat file output data will get mismatched.
3. How will u change multiple currencies into single currency?
1st I am going to make my Source System an Exchange Transfor rate and Execute in Background on Hourly bases.
After that I am going to T-code: RSCUR and create Currency Translation Type and in that I have given exchange type as M because it is on hourly bases on BI side and currency as 0P_CURPR (it is the verbal for currency) and time ref as 0CALDAY.
Open BEx and open Query in that the Report should Contain Value of Stock and Price per Unit.
4. Routines?
4 Types of Routines are Present
Field Routine (It operates on single character or key Figure Infoobject only)
Start Routine(It operates before Start of Transformation)
Suppose we are having 4 weeks data in that my client wants to see only 4th week data in that situation I have used Start Routine
End Routine(It operates at end of Transformation )
End Routines are used mainly for Lookup’s (2 Flows)
Expert Routine
5. How will you Transport in Modeling?
Go to RSA1 ----> Transport Connection
Select the Grouping method à save for system copy
Drag and Drop the Source system in the collection area
Go to T-code: SE09
Release the Transport request
6. Data Target InfoCube is mainly used for Aggregation then why we have a Aggregation in SAP-BI?
In InfoCube all the key figures are going to Aggregate where as in Aggregation we can aggregate the key figures based on characteristic Info object.
Example: If we want to see the different company’s sales data in that situation I am going to create aggregate on company characteristic InfoObject then all the sales data will be aggregated based Company.
8. What are the steps you will do while Enhancing a Data source?
1) Activate Data Source using T-code : RSA6
2) Check the Activated Data Source in T-code : RSA5
3) I am going to Double click on Data Source
4) Open the Extract Structure and then click on Appand Structure.(If Enhancement is being done for the 1st time create append Structure )
5) Now I am going to add new fields with prefix ZZ save and Activate the append Structure
6) Again go to T-code RSA6 and edit the Data Source. Unhide the newly enhanced fields
7) After completing this we need to write the enhanced code for populating this new fields
9. What is a Structure and how many types of structures are there?
In Structure all the Key Figures are saved in One Structure and this Structure can be used in diff Queries
2 Types are present Local Structure and Global Structure
You can use structures in several different queries. You have to save them in the InfoProvider to reuse them. These structures are then called reusable structures
If you want the change to the reusable structure to affect only one query, you can use the reusable structure locally in this query. To do this, you delete the reference to the reusable structure. Select the reusable structure in the query and choose Remove Reference in the context menu.
10. What is Aggregation and Exception Aggregation and the difference between them?