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 don't see records that are blank.

Showing Answers 1 - 2 of 2 Answers

Desperado

  • Jun 21st, 2006
 

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.

  Was this answer useful?  Yes

IMRAN

  • Nov 1st, 2006
 

Use MDX

IMRAN

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.