BI Publisher 11G does not accept '>' and '<' signs in the Data Source query
a customer had noticed a problem when creating a new Data
Set based on an SQL Query in BI Publisher 11G. on R11.1.1.5.0 as well as 11.1.1.3
When the query contains an attribute that has '>' or '<' in the attribute name, the query is not accepted. (f.e. "Fact - WZcijfers"."# <1 jaar").
I am able to select the column via the Query Builder, and when I click on 'Results' it gives me the correct results. But when I click on the 'OK' button in the 'Create Data Set - SQL' screen, nothing happens.
What I find very strange about this is that when I select a column with '<=' in the name, it works fine (f.e. "Fact - WZcijfers"."# >= 10 jaren").
When the query contains an attribute that has '>' or '<' in the attribute name, the query is not accepted. (f.e. "Fact - WZcijfers"."# <1 jaar").
I am able to select the column via the Query Builder, and when I click on 'Results' it gives me the correct results. But when I click on the 'OK' button in the 'Create Data Set - SQL' screen, nothing happens.
What I find very strange about this is that when I select a column with '<=' in the name, it works fine (f.e. "Fact - WZcijfers"."# >= 10 jaren").
0