A collection of OBIEE / OBISE stuff from 101 till 404. I just put the things here I run into.
Updated the Config Tags file and made (hopefully) better readable: OBIEE 10341 Config Tags
Till Next Time
Great stuff John.Where have you collated these from? And are there any new ones specifically for 10.1.3.4.1 from 10.1.3.4?
Hi, can u help me in question of using OR operator in the WHERE clause in Oracle BI? I am using Oracle BI EE 10.1.3.3.3.I construct the simple report in BI Answers on the Accounts presentation layer, and use the following filter clause:"WHERE (AccountNum BETWEEN '441' and '473') OR (БалСчет1Порядка BETWEEN '501' and '519')"Then i look in the cursor cache and find the real query which is going to database, and it's "where" clause now is:"where ( (T45172.BA >= '441' or T45172.BA >= '501') and(T45172.BA >= '441' or T45172.BA <= '519') and(T45172.BA >= '501' or T45172.BA <= '473') and(T45172.BA <= '473' or T45172.BA <= '519') ) "Why BI create so many expressions instead of the source 2 expressions?How can i force BI to use the source expressions?
@Andrey,The reason is that the OBIEE SQL is independ off the underlying database. Your DB query optimizer will fix this internally.regardsJohn
Post a Comment