Sree data model

From PTAGISWiki

Here is an attempt to set up an SREE report based on a data model. It almost works like this.

Data Model

Report definition

Report Output

The blank Tag Site could be just an artifact of the report designer. I think that if I were to create the report from scratch, I could make a version of this report that shows the Tag Site and Rel Date.

My theory was confirmed: by building a new report I was able to get it working correctly on my Linux workstation in the Report Designer. Evidently, if you experiment with too many settings, the report gets into a state which no amount of editing can get you out of and you just need to start over.

The latest revision of the report looks like this within the Report Designer preview:

But now when I try to deploy that report to development it looks like this:

Notice the different columns and alignment within the cells. This is very odd since I can view the .srt file on development and verify that it is the same as the one I'm using on my workstation.

Ahh, the answer was that there was a mismatch between the datasource.xml in use on my workstation and on development. After I copied the datasource.xml to development and restarted the webapp, the report shows up properly.

When deployed to development, it worked fine, but an empty report came up when deploying to production. I had to switch the datasource for the data model from "production" to "sockeye" in datasource.xml, switch the datasource in Site_Summary_data_model.srt, and restart the SREE application from the Enterprise Manager to cause the report to work properly on production.

datasource.xml

<DataModel datasource="sockeye">
<LogicalModel name="sum obs model" partition="sum obs view" datasource="sockeye">
<Description>
for use by reports that used the sum_obs_by_day view
</Description>

Site_Summary_data_model.srt

<bindingAttr type="3" class="BindingAttr">
<filter class="SourceAttr" type="1" source="sum obs model" prefix="sockeye">
</filter>