SSAS tabular custom format bit (or any other fields) RRS feed

  • Question

  • Can I format this true/false columns output to something like "NetTaxBegDate TRUE" for true and "NetTaxBegDate FALSE"  for false.

    When users use these columns in excel drilldown all they see is a true / false and they started to get confused when many of these columns are used in a drill down. They want to see the column name within the column content. I modified the dimensions to have a text value instead of a bit to satisfy this but it costs a lot during deployment, after changing some dimensions instead of 2:15 my full deployment takes 3:45 hours which I don't like. If I can manage to use formatting for this I expect there won't be extra overhead.

    Thank you

    Gokhan Varol

    Friday, August 16, 2013 3:20 PM