It seems that it is not currently possible to have a report table with
no cross-tab dimensions. The reason that I would like to have this is
in order to feed a PivotTable and having the data already cross-tabbed
is a bit problematic. I would do this from the datamart itself, but
since there is so much data in the data mart, and it is not possible
to have multiple data marts (as is the case for report tables) I would
prefer to have a select set of data elements (and preferably
indicators as well, similar to the data mart).
So, I guess, I am asking would it be possible either to
1) Have multiple named datamarts that would be stored in something
other the default tables?
2) Allow a report table to have zero cross-tab dimensions?
2010/2/5 Lars Helge Øverland <larshelge@gmail.com>:
On Fri, Feb 5, 2010 at 9:17 AM, Jason Pickering > <jason.p.pickering@gmail.com> wrote:
It seems that it is not currently possible to have a report table with
no cross-tab dimensions. The reason that I would like to have this is
in order to feed a PivotTable and having the data already cross-tabbed
is a bit problematic. I would do this from the datamart itself, but
since there is so much data in the data mart, and it is not possible
to have multiple data marts (as is the case for report tables) I would
prefer to have a select set of data elements (and preferably
indicators as well, similar to the data mart).
So, I guess, I am asking would it be possible either to
1) Have multiple named datamarts that would be stored in something
other the default tables?
2) Allow a report table to have zero cross-tab dimensions?
Ideas
2) would be the simplest. Go ahead with a blueprint.
Lars
And when we get a built in pivot generator in place (for OO and Excel) then it is just a matter of creating one of these non-crosstabbed repprt tables and click on a “create pivot table” button and there you are in Excel without any need for complicated views with all the data from the pivot table.
Ola Hodne Titlestad |Technical Officer|
Health Metrics Network (HMN) | World Health Organization
Avenue Appia 20 |1211 Geneva 27, Switzerland | Email: titlestado@who.int|Tel: +41 788216897