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

Can anyone plz tell me How to create universe in business objects enterprise 11.5

3 Answers  

---

What is the functional & architectural differences between business objects and web intelligence reports?

0 Answers  

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

3 Answers  

---

What is package in BO

0 Answers   Infosys, Saksoft,

---

What is the difference in creating filters in designer and business objects?

0 Answers  

---

how to create reports on screech?

0 Answers   Zensar,

---

how change the order of prompts in bo xi? eg. i create first prompt with 'year' and second prompt with 'city'. my question is to display the 'city' prompt first .what can i do for it ?

3 Answers   Cambridge, Patni,

---

What are the Errors in BO Pls Explain with Examples

2 Answers   iFlex, Tech Mahindra,

---

What is the difference between absolute and relative div positioning?

0 Answers  

---

why measure objects are semantically dynamic?

1 Answers  

---

Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.

1 Answers  

---

main purpose of aggregate awareness(not include make possible of use of aggregate tables)

2 Answers   Accenture,

---