Data Warehouse Analyst Question:
Download Questions PDF

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.?

Answer:

Reporting services allows the slicing and dicing functionality. to see the non empty records, i think you have to create a calculated measure,to hide all the non empty rows.

Download Data Warehouse Analyst Interview Questions And Answers PDF

Previous QuestionNext Question
Explain about a tricky situation for which you found a very simple solution?Explain What is the difference between Business Requirement Document and Use case Document. What is the difference.

I need a good BRD and UC template?