Answer / nareshkumar

Dimensions that change over time are called Slowly Changing
Dimensions. There are three types namely,
1) Overwriting the old values
2) Creating an another additional record
3) Creating new fields

Answer / surya

Master data occur in the OLTP system and that can't change
regularly,When the changes are occured in the OLTP
system,that changes can be handle by the dimension
tables.Such type of dimensions is called Slowly changing
dimensions.

There are three types of dimensions
TYPE1(Maintain only current data)
TYPE2(Maintain complete historic data)
TYPE3(Maintain one historic data)

Answer / mahesh225

The data present in the dimension table changess from time to time.

For example .

Customer is staying in Inda now and he may moves to Us in next year.Similerly from Us to Uk and so on.

So to maintain this kind of dimentional historical information we have SCD type1,Type2 and Type3.

www.futuresoftworld.com

Thanks

IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

2 Answers   Accenture, Rolta, TCS,

---

Is it possible to join more than one universe in Business Objects? If its so how is that possible ? thanks in advance for the answers

5 Answers   Wipro,

---

How to resolve the partial result error in the report

4 Answers   Keane India Ltd,

---

Hi ,how many shortcut joins used in a single universe? Thanks in Advance

2 Answers  

---

What is the pivot option ? what is the need of it?

1 Answers   Infotech,

---

What services the broadcast agent offers on the server side?

2 Answers   TCS,

---

When we use aggregate awareness function in designer?

0 Answers  

---

is it possible to export the webi reports to crystal reports?with out using businessview?

0 Answers   CTC, TCS,

---

What is meant by ZABO and FC(full-client)?

2 Answers  

---

how to hide the prompts?

7 Answers   TCS,

---

who r the users in B.O.XIR2?

2 Answers   PCS,

---

How can we acheive Correlated sub-query in Designer?

2 Answers   Infosys, TCCX, Wells Fargo,

---