If for creating SQL queries in BI Publisher using the Query Builder, then you might have noticed that in the "Conditions - The" missing an aggregate function for numeric data types. BI Publisher in order recognizes data types of columns from the selected table: but then for each data types are always offered the same list of SQL functions - ie functions which are suitable for data type contain text. The list of available SQL functions for different data types is the source for BI Publisher is listed correctly, see. function qb_rend [DataType] Select (). Unfortunately, for some reason (I did not look at it) will select the wrong data type and is always called qb_rendCharSelect function that generates the SQL function for text. Workaround Note: this is only a workaround and deploying a new version may be! 1 / J2EE in the Directory Server (the server application is running BI Publisher), locate the file "qb_gensql.js" (eg D: \ OracleBI \ oc4j_bi \ j2ee \ home \ applications \ xmlpserver \ xmlpserver \ qb \ qbfiles \ qb_gensql.js)2 / File backup 3 / file to open it and find the function qb_rendCharSelect 4 / Add the aggregate functions (lines of copy function qb_rendNumberSelect) 5 / Save the file 6 / Lubricate the local web browser cache and reload the page Query Builder - the result is complete list of the SQL aggregate function function of Erik Eckhardt.
MONDAY, 13 OCTOBER 2008
BI Publisher - Query Builder - The list of tables is too long
If for creating SQL queries in BI Publisher using the Query Builder, then perhaps you received an error message: "The list of tables is too long." Reports reached only when the number of objects in the diagram larger than the value of 100 (value 100 is BIP version 10.1.3.4 and below). The solution is : a) write to the filter one or more letters from the name of the table. b) use a workaround and a little tweak the code Query Builder. Workaround Note: this is only a workaround and deploying a new version may be everything else! 1 / J2EE in the Directory Server (the server application is running BI Publisher), locate the file "qb.jsp" (eg D: \ OracleBI \ oc4j_bi \ j2ee \ home \ applications \ xmlpserver \ xmlpserver \ qb \ qb.jsp ) 2 / File backup 3 / file to open it and find it ERROR_TOO_MANY_OBJECTS 4 / The present value (in my case 100) to change the example to 200 5 / Save the file 6 / Restore Query Builder page - the result is a display of all tables in the schema Erik Eckhardt .
Posts
