Instant SQL \ MDX & DAX Formatter

To format a SQL \ MDX & DAX Script Instantly one can use the below link. Its really good !

http://www.dpriver.com/pp/sqlformat.htm

http://formatmdx.azurewebsites.net/

SSAS -Tabular Model and SSRS - DAX Query

• SSAS -Tabular Model and SSRS - DAX Query:
  1. Tabular model tutorials : http://msdn.microsoft.com/en-in/library/hh231691.aspx
  2. Points to remember for Direct query mode in Tabular Model - http://msdn.microsoft.com/en-IN/library/hh230898.aspx
  3. DAX for Tabular Model : http://msdn.microsoft.com/en-in/library/hh213101.aspx#bkmk_DAXintm
  
  Note:
  1. Multiple DataSources are not allowed in Direct Query mode.
  2. Calculated Columns are not supported in Direct query mode.
  3. MDX doesnt work if Model is in Direct Query mode. Use DAX or XMLA.
  4. Direct Query mode doesnt support some DAX functions. http://msdn.microsoft.com/en-us/library/hh213006.aspx

# Keywords for SSRS Charts

To increase readability of a chart, we can use #keywords.
Example: Disable the Legend in the chart. And append the Legend text to the DataLabels

The link gives more information http://msdn.microsoft.com/en-us/library/dd207017.aspx