MDX in SQL Server 2005 Analysis Services

MDX in SQL Server 2005 Analysis Services brings exciting improvements including query support and expression/calculation language. Explain.

MDX in SQL server 2005 Analysis services offers CASE and SCOPE statements. CASE returns specific values based upon its comparison of an expression to a set of simple expressions. It can perform conditional tests within multiple comparisons. SCOPE is used to define the current subcube. CALCULATE statement is used to populate each cell in the cube with aggregated data.
Can you explain how to deploy an SSIS package? - Data warehousing
A SSIS package can be deployed using the Deploy SSIS Packages page. The package and its dependencies....
Difference between the INTERSECT and EXCEPT operators
INTERSECT returns data value common to BOTH queries (queries on the left and right side of the operand).....
What is the new error handling technique in SQL Server 2005?
SQL Server 2005 introduces a new exception handling paradigm using TRY / CATCH blocks in T-SQL. The errors are well trapped in the try block and the execution is transferred to the catch block......
Post your comment