I am trying to edit the default forms/reports that come with CM14, trying to edit the data model, data set, (to get to the old Infomaker style graphic view) , the Query model does not display (error the list of tables is too long..) Oracle tell me the limit is 60, there are not 60 tables referenced in any CM report.
Does this Query builder view work at all on any report?
(bigger question, we are moving from CM12, should we move to CM13 which works with infomaker?)
If you want to avoid going to BI, you'll have to stay with CM13. 13.1 is last release that supported Infomaker. I think support for the 13x environment is planned to stop in 2014, so something else to consider.
BI--does not have a comparable to the Infomaker "Graphical View". When selecting tables, it will not display all tables from the complete list, but once you start typing "PR.." will then start displaying those that start with those letters.
As you saw, the BI Query Builder limits you to selecting 60 FIELDS maximum, and also once you build the query, you cannot return to the same graphical view to make changes. Any queries built already must be modified in the SQL language screen, not the query builder. BI expects for the most part that you will be working directly in SQL language for your queries.
I'm not sure that you can still obtain the CM13 installers from edelivery at this point, and pretty sure you cannot buy any more older licenses without explicit permission from Oracle sales, so these are other considerations.
Thanks for the help Rudylsing. It is unfortunate, buildling queries graphically and the ability to go back to edit, is a pretty standard function in most report writing tools(Access / Infomaker etc.). Will look at the BI desktop developer tools. As you noted CM13 is an option.
I have been using BI Publisher with CM14 for a few months. I am not familiar with CM13 and Infomaker. This is how I get to see the tables used to create the DM. Log into BI Publisher, find your datamodel and select EDIT. Once it displays, click on dataset. When that displays click on the pencil icon(edit selected dataset). Click on Query Builder. You will now see all of the tables and selected columns that were used to build your SQL needed to create the output dataset. I hope this helps.
Kurt, thanks for your replies.
A couple of notes/clarifications.
1. You are correct that BI works better in Firefox--I have observed issues with the BI display when using IE. I would recommend using Firefox too.
2. You are correct about the way to get to the Query Builder to see a graphical view of data tables. There are basically two issues with this that I mentioned, but will re-iterate:
a. If you have an EXISTING query in the data set, then click the "Query Builder" button, this will remove the existing query that's there, it will NOT display the existing query in the query builder. Query Builder works only to create a NEW query from scratch.
b. Query builder is limited to selecting 60 fields max in your query. If you are creating a large report with many tables, you may find that 60 fields is not enough. For that you will have to work in the SQL edit screen rather than using the query builder.
I would impress on anyone developing CM14 reports that they become familiar with the database schema and relationships to avoid problems when developing your BI reports. You should be able to find the tables and joins documentation in the knowledgebase.