1. Can we format BEx reports/graphs using HTML and CSS
Manual says we can do format using HTML and Java Script [not css].
2. Why is there a restriction of 16 Dim tables in an Info Cube and 16 key fields in an ODS?
In all of the database systems there is maximum number of
fields allowed to create a primary key (composite key) is 16.
An in the case of cube, to fetch a single record a
combination of all dimension is used, so this is the reason
behind having maximum no. of dimension in cube is 16 only.
3. Why we have only 16 Dimension tables in a cube. Is there any reason. Is it a limitation?
SAP BI InfoCube Can have maximum 16 Dimension, Why because
na Cube shape will have only 16 Dimensions and also Normal
data base table will have only 16 keyfields. When we create
InfoCube system is going to create tables like F-table and
E-table So,we should follow that database concepts Because
of that InfoCube will Have only 16 Dimensions..
4. Why we are going for customization? Give me a scenario?
1.For Requirement as per company
2.Reporting As Per Module
3.Remove Complexity From End User
5. WHERE DO YOU STORE THE MASTER DATA IN BI 7.0?
Unlike the older version of BW which uses star schema, BI
7.0 uses the extended star schema. In this, master data is
stored outside the cube.
In the star schema, both master data and transaction data
resides inside the cube bringing many problems: master data
not reusable, computing of alphanumeric values and analysis
being limited.
In BI 7.0 Master data is stored outside the cube which
makes it reusable, and alphanumeric values can be computed
and many more analysis are possible.
6. What are the common Transport errors in SAP BW?
1.NOT CORRECT USAGE.
Reason: When we change the structure of any cube which has Business Warehouse Accelerator Indexes created for it. Change in structure could mean a change as simple as adding a navigational attribute.
solution: Delete the Indexes (BWA Indexes)first then transport and then rebuild the indexes
2.Info Object not available in active version.
Reason: We get this error when we try to transport the Info Object Catalogs without transporting the info objects.
Solution: As a prerequisite first transport the info objects then transport info object catalogs.
3. Navigational attribute does not exist
Reason: If we mark an object in the cube as navigational attribute and navigational attribute does not exist as navigational in the target system.
Solution: Transport the info object with navigational attribute and then re-import this transport.
7. What advantage of ic with aggregates?
if we create aggregates on infocube then query performance
will be improved if our query accessing attributes data
frequently.The sequence when we execute the query is:
1.Query first goes into cache if it finds relevant data in
cache will fetch data otherwise
2. it goes into BI ACCELERATOR(BIA)
3. Aggregates
4. Finally it goes into IC if the data is not available in
above 3 stages.
If we maintain aggregates or BIA olap no needs to come
upto IC. So time will be reduced. Query performance will be
improved.
8. Can we load delta load directly without full load? How? What are the steps?
Yes we can.
because of for capturing deltas we need to do somthing
before load the deltas.
before going to set the delta mode. you should initialize
delta process without data transfor process. ofter
finishing the this initiazation keep the delta mode. and
exectue the infopackage.
before going to execute info package check weather data
source is reay to capture deltas or not. by using the t-
code rsa7.
every process it has own variant .selecting the variant it
will give the time period i..e immediate or time/date..
10. Explain process chain failure notifications?
Create a job at that time when all the process chains have ended. This job will send you a email alert what process chains have errors.
normally
red - failure.
black - start the next process.
11. What are three dimensions provided by SAP?
SAP Given Three different kind dimensions for InfoCube.Those
are.
1)Data Packet Dimension : Which is going to hold the
technical information like request Number etc..
2)Unit Dimension: This dimension can hold the all Unit
characteristics like Reference Currencies , UNIT'S etc..
3)Time Dimension : This particular Dimension Can hold the
all time characteristics like 0calday,zdate, start date, end
date etc..
12. Explain difference between transfer rule&update rules?
In context to BW/BI 3.x
transfer rules - mapping the fields in the datasource to the infoobjects in Infosource or target fields. it help you to distinguish which all fields in the datasource are required in the infoobjects in the Infosource.
update rules - to update something. here it revolves around a source(infosource)and a target(data target). update rules are used to update the data targets.you have to create update rules if you supply a data target from an InfoSource with flexible update.
In BI 7.0 Transforamtion - (Tranfer and update rules)
