By powerpivotgeek (dwickert@hotmail.com), on October 4th, 2010
Tip: (I spent several hours discovering this one)
When specifying your query for importing data into PowerPivot, make sure you columns are unique and only returned once in the query!
This is easy to do. In my case, I had a query that looked like this: SELECT FIELD1, * FROM TABLE – where field1 was a field [...]
By powerpivotgeek (dwickert@hotmail.com), on October 4th, 2010
So I am playing with importing data from an an SSAS cube. The most distracting issue is that numeric columns are imported as strings, and the default aggregation for strings is Count. Thus when I try to drag & drop measures into Values field, I found that it treated as Count rather than Sum. When [...]
Recent Comments