Search results for query: *

Hi, When I run a certain query with conditions- (previousMonth OR Some_Month=10-31-2005) AND (Other conditions), it works fine. But when I change the query to- (Some_Month=11-30-2005 OR Some_Month=10-31-2005) AND (Other conditions), then it throws an error- An internal error occurred while...

Hi, Is there any way to generate Serial number from within BO Webi and display it on a separate column? I use version X1 r1.

Can we define the order in which my dimensions appear? For example, I need to get this - #ofDays ------- >150 101-150 51-100 1-50 But I get this- #ofDays ------- 101-150 >150 1-50 51-100 Ascending or Descending would only reverse the order.

If I do an equivalent query in Oracle, I get a result like- Product Cost ------- ---- p1 10 p1 10 p1 20 But,in BO, the records returned are- Product Cost ------- ---- p1 10 (only one of these is returned) p1 20 The properties are set to return duplicate...

Does BO Webi XI r.1 have any means of returning rows containing only Nulls. My queries are returning measures for only those rows where there is at least one Not Null value. I know we can use NVL() function in the database to replace nulls with 0's, which would eliminate the problem altogether...

Hi, I need to capture values of certain records which act as denominator for my calculations. Example: Group SUM ----- --- G1 50 (NOTE: sum varies over time, but groups are same) G2 80 Can I create 2 variables, say varG1, varG2 to hold values of the SUM, i.e. varG1=SUM(G1) and...

Hi, 1. Can I create a variable based on, say Query1, and use the same to compute a Percentage on another Query? 2. WHat if I have 2 queries which return as follows- Query1 col_1 Percentage ----- ---------- 20 30 Query2col --- 50 120 Now, to compute Percentage for Query1, I need to do-...

Hi, I need to design a report, in WebI XI r1, for "The qty of product that have been in stock for some range of days (say, since they were brought to the warehouse till today). I have Product dimension, #ofDays in inventory and the qty. Looks simple. But the problem I am facing is that the...

Hi, I have a query which returns revenues in a table such as- Nov'05 ------ Product1 Product2 RowTotal %(calculated as) -------- -------- ======== ===== store1 20 30 50 (50/90)*100=55.56%; Here,denom is rowtotal for the store2 10 25 35 (35/95)*100=36.84% store in...

I am using BO Webi v.11. I have a query (for this month) which returns revenues from each product by each store (cross-tab). Another query does the same thing, but for the previous month. I also need a block which totals every record from the previous two queries. I have written another query...

Does BO WebI r.1 have ranking functionality? If yes, please tell me where to find it, and how to use it. Thanks.

Hi, I have a table which as STORES and REVENUE (measure that is computed in the report). Now, I need to filter the records based on this computed revenue. That is, I just need those records where the revenue > $2000. NOTE: If the measure was available as part of the Fact, then I could have...

Hi, I am using BO WebI ver.11 and Oracle9i. I need to generate a report such as- DECEMBER 2005 STORE PRODUCT_UNITS_SOLD ----- ------------------ store1 10 store2 0 store3 50 TOTAL:60 NOVEMBER 2005 STORE PRODUCT_UNITS_SOLD ----- ------------------ store1 4 store2...

Hi, I have 2 dimension tables, STORE and PRODUCT. The REVENUE fact contains the revenue for each product sold from every store. I need to extract just 3 stores with the highest revenue. My report should look as follows- PRODUCT1 SN STORE_NAME REVENUE %ofGRANDTOTAL -- ---------- -------...

Hi, I have 2 dimension tables, STORE and PRODUCT. The REVENUE fact contains the revenue for each product sold from every store. I need to extract just 3 stores with the highest revenue. My report should look as follows- PRODUCT1 SN STORE_NAME REVENUE %ofGRANDTOTAL -- ---------- -------...

Hi, I have a store dimension with more than 500 records. The earnings fact contains the revenue from each of the stores. I need to extract just 5 stores with the highest earnings. I want to display store name and revenue in $. Also, a column is required which shows %of Revenue (calculated...