Question { 7025 }

Define a process chain?

Answer

Process chain is diffarent kind of process link in one
chain.

in process chain diffrent kinds of T code are there.

RSPC - process chain display palning view.
in this we r monitor and create the process chain. here
we monitor indivisual PCs.

RSPCM - Monitor the Process chains.
here we check status of the all process chains.

RSMO- Monitor adminstration work bench.
here we see the status of the load by using
header,status,detail tabs.

SM37 - Job over View.
here we can see the job status like scheule, repair,
repeate, active, cancel,finished status.

SM50- Process over view.
SM51- it is also same as SM50 but it will give detail
information about catorized application servers.

and also we use so many t.codes based on failures.

Question { 5928 }

What is ASAP?

Answer

ASAP have 5 imp steps
1. Project Preparation,
2. Blue print
3. Realisation
4. Final Project Preparation
5. Go live Support.

this is very imp concept for project.

Question { 3935 }

How does change run affect aggregate?

Answer

without change run the masterdata navi.attr and hierarchey
changes will not effect on data in cube.

Question { 8873 }

Can you partition a cube that has data already?

Answer

first u need to be empty the cube.
u need to create one more cube (copy of same cube) and by
using data mart data will upload to the new one. after the
partion of orginal cube u must export data to the new cube
to original cube.

Question { 4484 }

What is a star schema?

Answer

Star shcema is one of the Cube Structure.

Fact table surounded by several Dimention tables.
in star schema some imp points.
1. in star schema master data tables and dimention tables
are one and same.

2. Dim tables are linked with fact table. fact table having
a key figures.

3. in we can see the data only in 16 angles only.

4.there is no reusability of dim tables.

and also some are futures and defects also there. these are
little.

Question { EDS, 21001 }

How is multi provider different from info set?

Answer

Multiprovider is 3dim in this infoobject, ods and infocube
included.it will works on union concept.

infoset are 2dim in this infoobject and Ods included. it
will works on intersection concept.

in BI7 infocubes also included in Infosets.

info cube is 3 dimention data target.

Question { 5898 }

What is Open Hub (OH)?

Answer

Open hub is a data distributor for SAP or Non SAP systems.
i mean i.e it will send data to the flat files or DB system.


the T.Code for Open Hub is RSBOH1

Question { 15712 }

What is the maximum number of key figures you can have in
an info cube?

Answer

according excel sheet there are
255 colums
016 dim
------
239
006 Sap Defined
----
233 Key figures

Question { Cap Gemini, 31458 }

What is v1,v2 and v3 updates?

Answer

The above answer is exactly correct. in techical terms.

V1: syncronious

V2: asyncronious

V3: asyncronious with background schduling.

Question { 10137 }

How many dimensions in a cube?

Answer

how we have only 16 dim in cube.
answer is .....

in Excel sheet we have 255 coloms, in those 233 keyfigures
using, and 6 are defined for SAP. remaing are Dim in cube
255
233 - KF
---
022
006 -SAP
---
016- (13 char, 1 datapacket,1 time, 1 unit)

Question { 4280 }

Is it possible to cancel the "collapse" process in Process
chain. if yes. Briefly expalin how to cancel the process.

Answer

you can kill the job in SM37.