Sap Bi Queries.

[former_member183113]

Hai experts,

i've some queries. plz clear them if u have free time.

1.)What do you do, when you get a GAP? What is FIT-GAP analysis?

2.)What is the t-code to create INDEX in SAP BI (7.0)?

3.)How to get the recordmode D or A in changelog table when we delete or add records in DSO?

4.)What is variable? Give me one example? I want to display 12 months in a report..? How many variables are used?

5.)If we want to design an info cube, what are the pre-requisites u have to take in real time?

6.)What are the reports generated in a sap BW project? Name them and what is the requirement?(Any 2 examples..)

7.)What are the InfoCubes developed in a sap project? Name them and what is the requirement?(Any 2 examples..)

8.)Suppose, you are working on a report, how do you know from which INFOCUBE, report should be generated?

if u answer any of these questions enough for me..........

Thanks and regards,

Ravi kiran

banglore

[Former Member · Accepted solution]

1.)What do you do, when you get a GAP? What is FIT-GAP analysis?
A) Fit-Gap analysis is the study of finding the gaps (differences) between the system functions and the actual business scenario.

when u find a GAP, u have to bridge or fill the GAPs by certain procedures ,one of which is by using userexits  (enhancements)
Eg: Suppose that u have selected a standard infocube which meets 90% of ur business requirements but not 100% as it doesnt have some fields (infoobjects) which u need .Let's take an example of  sales overview cube (0sd_c03) and u need storage location to be included in the cube. then u can  add a new characteritic infoobject to the cube and load it through the datasource Data
source 2LIS_11_VDITM- Billing item data in which the particular field is available.


2)What is the t-code to create INDEX in SAP BI (7.0)?
A) For creating BIA (BI Accelerator)indices , the Tcode is RSDDV.
But if u meant just the normal secondary index
a)For Infocube : RSA1->select the cube->Manage ->performance->create index(batch)
b)For DSO: RSA1->select the DSO-->Go to Edit Mode->click Indexes at the bottom of the screen-->create new index->drag and drop the characteristics on which u want to generate the indexes.

3.)How to get the recordmode D or A in changelog table when we delete or add records in DSO?
A)ROCANCEL field of thedatasource is linked 2 0recordmode of DSO via transformations. As the ROCANCEL field will have images ,the same images will be trasfrerred to 0recordmode infoobject.

4.)What is variable? Give me one example? I want to display 12 months in a report..? How many variables are used?
A) Variable is a query parameter which doesnt hold any value .The user can assign some characteristic value at the time of query execution.
If u want 12 months report u can create a single variable on the characterictic "month". u can iput any month value at the time of query execution .It will display the entries specific to the month value u enter.

5.)If we want to design an info cube, what are the pre-requisites u have to take in real time?
A) create the dimensions optimally
Tick it as line item dimension if the dimension table contains as many entries as in the fact table.

8.)Suppose, you are working on a report, how do you know from which INFOCUBE, report should be generated?

A)There is no thumbrule  to find which cube is apt for the report.
It's just a matter of commonsense ,suppose u want a report on the month wise sales volume, u can select 0SD_C01 like that.


Question Nos 6&7 are purely related on ur experience that u mentioned in ur CV,    

Hope this would help you.

Thanks and Regards

Jitendra Prasad

[former_member183113 · Accepted solution]

hi jitendra..thnks..satisfied with u r answers......k am closing this thread....

[former_member182098]

Hi Ravi,

You have posted in a wrong forum.

Furthermore, these forums are for discussing the business related SAP issues, rather than attempting interview questions.

Please read the forum rules before posting.

Best Regards,

Ravi

[former_member183113]

leav it......no prblem...plz suggest one forum if u know....any where......

[former_member182098]

You can post business related queries in

http://scn.sap.com/community/bi-solution-architecture

If you post as a interview questions, probably moderators will lock it.

You would get better answers if you put something with business example.

[Former Member]

Hi Ravi,

Please move this posting to the space as suggested by Ravi Sankar.

Thank you,

Simon

[Former Member]

Hi Ravi Kiran,

2, Tcode to create and maintain the INDEX is RSDDV

Regards,

Vasanthi

[former_member183113]

thnks vasanthi...........