Excel and SSAS Tabular Data Model Data Types RRS feed

  • Question

  • I have a question concerning data types when using Excel and a SSAS tabular data model. I'm able to successfully connect to a tabular data model from Excel 2007 and 2010, and build a pivot table. However, when I use the drill-through or show details functionality in Excel to view the detailed data behind a measure, all attributes are returned as plain text and not the data types set in the tabular data model.

    This causes a problems when I try to use formulas with the data table that is generated when using the drill-through or show details functionality.

    Does anyone have a solution or a work-around for this particular problem?

    Thank you!

    Monday, June 10, 2013 3:54 PM


All replies