You need system administrator on the Report Server. This article may help: http://www.mssqltips.com/sqlservertip/2793/sql-server-reporting-services-2012-permissions/[/url]

Not the format, but

Within the dimension, click on the attribute in questionm, then properties. What is the data type showing up in the NameColumn Source?

What about the data type in the dimension itself?

Within the dimension, click on the attribute in question. What is the data type showing up in the NameColumn Source?

You should be able to set the format of each measure to a numberic format ("###.##" for instance). Take a look at : http://technet.microsoft.com/en-us/library/ms175623.aspx

or

http://sharepointmike.wordpress.com/2012/06/02/949/[/url]

Yes, please take a look at SSAS writeback functionality. Please take a look at this MSDN article for some basic setup:

http://blogs.msdn.com/b/querysimon/archive/2011/03/03/writeback-to-analysis-services-cubes-from-excel-2010.aspx

I would go with the single dimension with multiple hierarchies to save processing time,

It will not show in your Excel Pivots.

grasshopper26 (10/28/2012)

---

I am new to SQL Server OLAP Cubes. I am having the following issue like

ex I have purchase order and invoice tables which are used in data source view....

You will need to go to the package to update the metadata. Otherwise you will get validation errors.

Use a toggle for the hidden field to show or hide the chart

I believe I understand better. You are wanting a query to run after the parameter has been selected. That is not quite how the parameters work as they...

I would start by displaying the parameters on the report to see exactly what values are being passed when you select an alternate value. That may point you in...

You might want to try using powershell to complete the copy and examine the exit codes

For 2008R2 and above. You should be able to add your additional dataset as a secondary axis. I am not at machine that has SSRS, but I believe...