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