My CSV source fact table has integers which PowerPivot is not identifying as measures. This is also true for calculated columns defined as decimals.
My test for this is to connect to the SSAS/PowerPivot instance, select the PowerPivot instance and within the Sandbox cube select "New Query". The Metadata tab shows no Measures (other than a default COUNT) within my Fact table.
The only way I can expose these fields as measures is to create a PivotTable in my workbook and drag each field that I want as a measure into Values...however each of the measures now shows up as Sum of ...measure name, renaming this has no effect.
Is there anything I'm doing wrong, or is this a known issue with Text file sources?
My bad...looks like an issue with all sources, just tried SQL Server. Will need to research PowerPivot more to see how to have values categorized as Measures w/o having to Create a Pivot table within the PowerPivot sheet
Marqué comme réponseLarryBarnesdimanche 1 avril 2012 13:32
Microsoft réalise une enquête en ligne pour comprendre votre opinion sur le site Web de Msdn. Si vous choisissez de participer, l’enquête en ligne vous sera présentée lorsque vous quitterez le site Web de Msdn.