W
warba
Pivot Tables are great with small datasets.
Does anyone have suggestions of products that can datasource from a
ODBC source and manage large datasets (1M+ rows), visualizing the dat
in a crosstab/pivottable format ?
Unfortunately the underlying logic in the PivotTable/MSquery link isn'
too intelligent in that is always wants to read the whole darn databas
table before even presenting a field list. I assume this is due to th
abstraction of the data created by sticking MS/Query inbetween th
Excel pivot table service and the actual datasource?
Seems pretty simply from a conceptual POV:
1. retrieve a field list from the datasource table
2. allow user to format rows/columns and data aggregations b
drag'n'drop of field names
3. user signifies they are done (i.e., click Refresh)
4. Pivot Table service then SQL's the table with only those field
required, creating the aggregations as defined by the user an
presenting them in the pivot table
If this doesn't exist, then could anyone use a tool like this if I wer
to write one
Does anyone have suggestions of products that can datasource from a
ODBC source and manage large datasets (1M+ rows), visualizing the dat
in a crosstab/pivottable format ?
Unfortunately the underlying logic in the PivotTable/MSquery link isn'
too intelligent in that is always wants to read the whole darn databas
table before even presenting a field list. I assume this is due to th
abstraction of the data created by sticking MS/Query inbetween th
Excel pivot table service and the actual datasource?
Seems pretty simply from a conceptual POV:
1. retrieve a field list from the datasource table
2. allow user to format rows/columns and data aggregations b
drag'n'drop of field names
3. user signifies they are done (i.e., click Refresh)
4. Pivot Table service then SQL's the table with only those field
required, creating the aggregations as defined by the user an
presenting them in the pivot table
If this doesn't exist, then could anyone use a tool like this if I wer
to write one