Answer / kshatri

Slowly Changing Dimensions are basically those dimensions
whose key value will remain static but description might
change over the period of time. For example, the product
id in a companies, product line might remain the same, but
the description might change from time to time, hence,
product dimension is called slowly changing dimension.

Where as Confirmed dimensions is some thing, which can be
shared by multiple Fact Tables or multiple Data Marts.

12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?

3 Answers  

---

i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)

0 Answers  

---

Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?

1 Answers  

---

We can have two separate installations of BOE XI 3.1 on a single server?

2 Answers  

---

whats the diff between break and section

4 Answers   TCS,

---

i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?

5 Answers   TCS,

---

WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY?

1 Answers  

---

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

0 Answers  

---

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1

4 Answers   IBM,

---

can you use inputbox in BOXI. e.g. checkbox,textbox etc.

1 Answers   ACN, Patni,

---

I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?

2 Answers   Accenture,

---

what is performance tunning in BO in report level& designer level?

1 Answers   IBM,

---