Drill down functionality is setup on the Action Tab of the Cube. In BIDS/ Visual Studio, double click on the cube, then click on the Actions tab. Then...

yes, In SSRS, go to the specific report and then security, you can then just grant user access to that one report without granting the user access to the...

You could create some grouping and then break it based on the grouping of that value by dropping the chart into a tablix

It would be better for you to use the multi-value parameter option. Then the report will present a check box list from which to select individual items (in your...

I like several free apps...

doPDF7... virtual pdf print driver or cutepdf

foxit reader... quick pdf reader

7zip... for compression

Q-dir... alternative to windows explorer

Agent ransack... alternative search tool; not indexed

I have been using a stand up desk for over 4 years now.... it is the best!! I do recommend having a good pair of shoes, and if you...

First check your key. Time Dimensions are a pain because of the repeating values in each year, ie you have a month 1 , a day 1, etc in...

Yes it is... SSRS creates a Report Server / Report Manger sites for you.

Using SSRS with Report Builder gives you much flexibility

Take a look at this blog:

http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx

No roles are for both editions. You assign each role to specific set of data within your dimensions.

Have you checked your cube dimension usage?

For a Star Schema, you will need to adjust you dimension tables to minor the attributes you would like included in the hierarchy. You can either create named queries...

Any chance you are using a reporting tool which will do the rollup / running total?

From what you have described, it seems one item you are struggling with the level of granularity. Make sure you define upfront, the lowest level of detail you...