Man am I excited to finally get this! Huge step forward in terms of getting Jasper Analysis to be viable on our end. I'm running into a problem at this point, however. It looks like at first glance I can't base a dimension on the fact table itself. We already aggregate all the data into one table and so I don't need to foreign key into another table in order to form my dimensions. (We're not likely to migrate to a star or snowflake schema database any time soon) Hence my need to be able to form my dimensions based on the fact table. Any suggestions? I've looked at the docs and they neither mention this as a limitation or provide a resolution. --Edit-- Looks like it does support degenerate dimensions... only it won't populate the drop-down after you've altered the table value within the dimension. --Edit2-- Looks like this is an issue specific to MSSQL JDBC. MySQL behaves just fine. Post edited by: Tharkad, at: 2007/05/15 12:04
