Search results for query: *

Sorry, perhaps I didn't explain my last post very well. The result of each measure is a SUM of millions of rows, rather than actually returning millions of rows, per se. I'm expecting to see totals of around 3-4 million rows in each measure. If they were simple queries this wouldn't be so bad...

Just to provide some further information... The measures do not select data from multiple fact tables, they are both based on the one central fact in the universe (a view actually, but I can't see how that would matter). And yes, both measures work perfectly well on an individual basis. I've...

I am trying to diagnose a problem with one of my Webi reports which returns two complex measures (each containing decode statements), grouped by one dimension. When each of the measures is used on its own, they work perfectly. However, when they are used in conjunction they return the error...

If you add a single digit to SYSDATE, you get tomorrow's date. Therefore, I beleive the expression you want is: "SYSDATE - 23725" since 365 * 65 = 23725 days. Hope this helps!

Our team have shifted from designing reports in the BusinessObjects app to using the WebIntelligence Java client, since we discovered that there's no 'drill' functionality on BO reports in WebI. One thing that bothers me about these new reports is that when you have a selection prompt in a...

I wish to present the user with a prompt, giving the option to report on a set of data EITHER by a date range OR by a single month (in addition to two other matching criteria). Is there any way of presenting the user with a prompt box in which they can fill in the two mandatory criteria and...