If Analysis Services on the server has been upgraded to Service Pack 3, you will need to run the SP3 update on every client that needs to connect to the...
You could set global variable flags in the package and use an ActiveX script in the Workflow properties for a task to determine whether that task should execute or not.
I have used or reviewed the following for both OLAP and RDBMS reporting from SQL and Analysis Services. Price differs, different tool for different needs:
If you want to have the same product under multiple hierarchies, you could do this by having the same product description but different product ID in the dimension. To...