A ) LSA describes the design of service-level oriented,scalable,best practice bw architectures founded on accepted EDW principles.It is used for large bw implementations at enterprise level.See More...
A ) The database allows upto maximum 16 primary keys . So for this reason we cannot create more than 16 dimensions in CUBE and 16 keyfields in DSO.
3 ) Iam executing infopackage it showing yellow for many hours what i have to do ? (Accenture)
A ) Using t-code SM50 we can stop long running requests , If the issue is still exist contact basis people with ur credentials.
4 ) Is it possible to load data using delta without full load ? What are the steps ? (Tcs)
A ) Yes , In 2 ways we can load data without full load
One is Initialize Delta with data transfer.
Second is Initialize Delta without data transfer.
The difference is if we choose the first way all the data will be loaded as full load.
If we choose the second way , data will not upload but it makes a path to take delta records.
Next step is delta load , when u do this step it will treat these records as New(Delta) records.
5 ) We have standard info cubes given by sap ? Why do we go for customize info cubes ? Tell me the business scenario? (Wipro )
A ) If the info cubes given by sap are not enough to satisfy the user's requirement then we go for creating our own(customizing) infocubes based on user's requirement.
6 ) Tell me some t-codes which holds the delta records ? (Wipro)
A ) RSA7 (Delta Queue)
LBWQ (Extraction Queue)
SM13 (Update Queue)
SMQ1 (Outbound Queue)
SMQ2 (Inbound Queue).
7 ) What are the tables that provide the detail information about Data source ? (Accenture )
A ) RSOLTPSOURCE - Replicate table for oltp systems in bw.(3.x)
RSOLTPSOURCEFIE - Oltp source fields(3.x)
RSDS - (7.X).
8 ) When can you say an infocube is Non - Cumulative infocube ? (Infosys )
A ) If the infocube contains the non-cumulative key figures then we can call it as non-cumulative infocube.See More...
9 ) What is the extra table maintained in Non - Cumulative infocube ? (Infotech)
A ) L (Validity) table.It defines the range of the characteristic values for which the non - cumulative key figure is valid.The structure of the table is /bi0/L* or /bic/L* .
10 ) Maximum how many fields can be add to DSO ? (mind-tree)
A ) 16 Keyfields.
749 Datafields.
11 ) What is the difference between Filter & Condition ? (Accenture)
A ) Filter is used to restrict the data based on characteristics.
Condition is used to restricting the display of data based on keyfigures.
12 ) What are the phases of Project Implementation ?
A ) There are 5 phases.
1.Project Preparation.
2.Business Blueprint.
3.Realization.
4.Final Preparation.
5.Go - Live and support.
13 ) I have created a multiprovider using 10 basic infoproviders how do i get the data from single infoprovider ? (igate)
A ) Using characteristic 0INFOPROV when designing a query on the multiprovider.
14 ) How many infocubes can i use to built a multiprovider ? Is there any limit ?
A ) There is no limit for infocubes but sap recommends not to use more than 10 infoproviders becoz it may leads to incorrect query results.
15 ) What is Report to Report Interface(RRI) ?
A ) Report to Report Interface(RRI) helps to enhance the capabilities of bex queries.It is used in drill through reporting from one query to another query.
Drill through is possible from infocube query to infocube query or infocube query to dso query.
RRI is a technique used to describe the linking reports together.
RRI uses jump targets that are created using the t-code RSBBS.
16 ) If there are two data sources how many transfer structures in r/3 and bw side ? (Bosch)
A ) 2 in R/3.
2 in BW.
17 )Mention what are the different layers in R/3 system?
A ) Different layers in R/3 system includes
- Presentation Layer
- Database layer
- Application layer.
A ) Domain defines the attributes such as length,type and possible value range.
Element is an intermediate object between domain and table type.
19 ) What is the process to create a table in data dictionary ?
A ) There are 3 ways we can create table.
- Creating Domains(Data type,Length.Range).
- Creating Data elements(Type and Properties of the table field).
- Creating Tables(SE11).
1 comment:
Thanks for sharing this Information. SAP BI Course in Gurgaon
Post a Comment