tag:blogger.com,1999:blog-4322942733345823065.post3227269434800148292..comments2024-03-12T10:59:42.736+02:00Comments on OBIEE in IL: OBIEE - Power to the people - joining the unjoinableOBIEE in ILhttp://www.blogger.com/profile/05334337345060191164noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4322942733345823065.post-34421602605979412122016-08-10T19:40:39.123+03:002016-08-10T19:40:39.123+03:00Great tip. We have some heavily formatted tables, ...Great tip. We have some heavily formatted tables, is there any way to keep the formatting if we were to need to update the SQL?jshiveyhttps://www.blogger.com/profile/08312065595034870372noreply@blogger.comtag:blogger.com,1999:blog-4322942733345823065.post-5662502396731292892016-04-18T23:24:37.495+03:002016-04-18T23:24:37.495+03:00any advice on optimization of these custom SQL are...any advice on optimization of these custom SQL areas? The evaluate functions don't work as a substitute as far as I could tell. I couldn't find info on what the physical or logical SQL generated might be if I use this method with the column formula filters. Ideally, the subquery would be filtered to a dashboard prompt. The only way I've been able to guess at how to get that is to use a custom GO URL and put the SQL directly there with variables somehow...subquakehttps://www.blogger.com/profile/03877956444133065121noreply@blogger.com