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,

---

what is confirm dimension ?

11 Answers   IBM, Wipro,

---

WHO ARE THE USERS OF THE REPOSITORY?

6 Answers   AG Technologies,

---

can any body tell me how to create Hyperlinks in BO XI R2?

2 Answers  

---

if there are 2 hierarchies 1 is a-b-c and another one is a- c which hierarchy b.o takes while we use drill mode

3 Answers   HP,

---

What is the drill up , drill down, drill by , drill trough ?

3 Answers   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,

---

What is pragma?

1 Answers  

---

Is it possible to create a user defined Calendar in BOXIR2? If yes, then how? Ex:- I want to create a Calendar where the year starts with the month of Feb-1. Each month is of 28 days. 1st Month as 1-feb to 28-feb. 2nd Month as 29 Feb - 21 Mar. Please help me out to get the answer....

1 Answers  

---

1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?

2 Answers  

---

I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)

3 Answers  

---

how to improve the performance of the report

3 Answers  

---