Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

0 Answers  

---

What is lookup table in etl testing?

0 Answers  

---

how would u estimate the size of Lookup transform data and index cache?

1 Answers  

---

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

0 Answers   Thomson,

---

what are variable ports and list two situations when they can be used?

4 Answers   Satyam,

---

What is a lookup table in etl?

0 Answers  

---

What is tracing level? How many types of transformations supported by sorted input?

0 Answers  

---

Compare ETL & Manual development?

0 Answers  

---

where we cannot use sorter Transformation. if we use then we will not get correct data?

0 Answers  

---

what are the facilities provided by data warehouse to analytical users?

0 Answers  

---

how do u set partition points in the mapping?

0 Answers   Quintiles,

---

What is the difference between project backlog and product backlog?

0 Answers   IBM,

---