Answer Posted / g k ramesh

1.In star schema the central fact table is surrounded by
master data tables(=dimension tables).since master data
lies with in the cube.we can not reuse the master data
information for other cubes.where as in Extended star
schema the central fact table is surrounded by dimension
tabes(!=master data tables).master data tables lies out
side the info cube.so,we can share the master data
information for other cubes.

2.In star schema the fact table holds Alpha-numaric
information.so,it degrades the database performance and
query performance.where as in Extended star schema using
SID tables we can see all the information in the fact table
as numaric.so,it improves the database performance and
query performance.

3.In star schema the fact table is directly connected to
the master data tables and it can be connected to a maximum
of 16 master data tables.so,we can not analyze the data
more then 16 angles.where as in Extended star schema the
fact table is connect to maximum 16 dimension tables and
each dimension table can be connected to a 248 SID
tables.so we can analyze the data in 16*248 angles

What are the components of sap bw system?

1065

---

What is the transaction to maintain services?

1983

---

What is the read mode in generic navigation block web item- read mode specifies

2074

---

What are the general tuning guidelines?

2168

---

What are the flags for general reporting?

2053

---

HOW CAN I APPLY PATCHES FOR BI 7.0 WITHOUT USER ID AND PASSWORD OF SAP?

2118

---

What is bw statistics and how it is used?

1022

---

What is the use ':' as an authorization value?

1048

---

where can we find transport return codes

1539

---

what is ods (operational data store)?

1065

---

What is geographical information in the sap bw?

1032

---

What are intervals?

2065

---

what is the data model and how it is use ?

2061

---

how the master data is read?

2133

---

What is extended star schema?

1037

---