Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: karkia
  • Content: Threads
  • Order by date
  1. karkia

    Error: WIS 30270

    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...
  2. karkia

    Serial # generation

    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.
  3. karkia

    Enforcing User-defined sort order

    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.
  4. karkia

    Similar Records Counted Once

    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...
  5. karkia

    Null-valued records MISSING

    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...
  6. karkia

    Variables for Computation

    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...
  7. karkia

    Variable from different query

    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-...
  8. karkia

    Days to be displayed in range

    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...
  9. karkia

    Computing % out of GrandTotal

    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...
  10. karkia

    Sum block of 2 queries

    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...
  11. karkia

    Does WebI have Rank function?

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

    Ranking on Computed measure

    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...
  13. karkia

    Difference in separate block

    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...
  14. karkia

    Group by Product, Store...HOW?

    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 -- ---------- -------...
  15. karkia

    Group by Product, Store--HOW?

    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 -- ---------- -------...
  16. karkia

    Extract top 5 revenues

    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...

Part and Inventory Search

Back
Top