If I am not mistaken you can use KingFdoClass metadata table to add non-geometry tables.
Haris On Mon, Jan 25, 2010 at 2:10 PM, bojanfr...@fer <[email protected]> wrote: > > Hi, > > I have a data warehouse with a FACT table containing a lot of points (GPS > locations). And I have a DATE dimension table. > I want to draw a layer containing all locations within 1 day (or a period > of > days). > > I was thinking of doing a JOIN with King.Oracle of that FACT and DIMENSION > table, exporting it to XML and then in PHP editing the filter tag with > "DATE > = YYYY.MM.DD". After modifying the layer, I would insert the new layer into > map and draw it. > It should also work fast enough for users to be able to go BACK and FORWARD > displaying maps for each day. > > The problem is, in King.Oracle provider, I see only tables and views with > geometry fields. And I need to join my DATE dimension which has no geometry > (logicaly). > Is it possible? > > Also, has anyone a better solution for my problem? > > I have round 10 Mil GPS locations for every year. > > Thx! > -- > View this message in context: > http://n2.nabble.com/King-Oracle-provider-how-to-create-join-with-table-without-geometry-data-tp4453820p4453820.html > Sent from the MapGuide Users mailing list archive at Nabble.com. > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users >
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
