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: *

  1. karkia

    Serial # generation

    Thanks Blom, Followed your tip. You know what I did...yeah!!
  2. 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...
  3. karkia

    Serial # generation

    Yeah, I just need a row counter. I did check out for the rowindex and rownumber functions...but they are not available. Is there any other way out? It should be there..since it is such a common feature.
  4. 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.
  5. karkia

    Sum block of 2 queries

    Ok, if adding elements from 2 different queries is not possible, can I create a template in Excel to perform the sum? That is, from WebI, I get the result from the 2 queries (say, A and B). Now, if I have a template in Excel which performs SUM(A,B), is there any way of automating the process of...
  6. karkia

    Enforcing User-defined sort order

    Thanks Steve. With this lousy WebI, I guess your trick seems to be the only way out.
  7. karkia

    Similar Records Counted Once

    I am happy with the unique field forcing all records to appear. Like I said earlier, I have to hide the field since it is not desired in the report. What baffles me though is, the purpose of the data property 'retrieve duplicate records'. Why is it that checking/unchecking it retrieves only...
  8. 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.
  9. karkia

    Similar Records Counted Once

    I guess counting the unique field helped. But I needed to clear the contents of the unique field, so that it doesn't show in the cross-tab report. But I can't remove the row or column for that field. I guess i will have to live with that.
  10. karkia

    Similar Records Counted Once

    Oops, that would cause a problem since the report has to be cross-tab. And the unique field will just be an extra field.
  11. karkia

    Similar Records Counted Once

    I guess I will just pull in a unique field to solve my problem.
  12. karkia

    Similar Records Counted Once

    Hey Blom, If you read my posting clearly, you would notice that I had mentioned that I CHECKED to retrieve duplicate rows in the Data Properties tab. BTW, I am using BO WebI XI r.1. I understand your comments, but that is what is intended of my reports since I need to make a count of all...
  13. 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...
  14. karkia

    Webi XI - Ranking Data to display top 10 results

    I had my question answered in an Oracle forum. Try the link http://asktom.oracle.com/pls/ask/f?p=4950:8:2806143251741218992::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:53141843431710
  15. 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...
  16. karkia

    Days to be displayed in range

    I had that in mind, but how do I use the Where clause? I work with BO Webi XI rel 1. The currentmonthend and PreviousMonthEnd are predefined queries in the universe. I guess I can make use of other dimensions to get the equivalent for use in the formula.
  17. karkia

    Days to be displayed in range

    As per the suggestions,I have created cross-tab report and sectionized it to reporesent for CurrentMonthEnd and PreviousMonthEnd, like below- CurrentMonthEnd Productname ----------------------- Days | Count(#ofDays) PreviousMonthEnd Productname...
  18. karkia

    Days to be displayed in range

    Cool. Thanks Blom.
  19. karkia

    Days to be displayed in range

    Hey Blom, now don't shout at me. But, how would this work in case of non-numerics. For example, if I have- #ofDays ProductName ------- -------- 5 P1 9 P2 25 P1 30 P2 50 P2 55 P3 80 P1 How do I count the ProductName for the range of...
  20. karkia

    Variables for Computation

    Thanks for ur response guys. I am not really a BO guy. More into Datawarehousing analyst/developer. Was just trying to validate some of my numbers with WebI (that's what we have). I don't believe that the BO folks did not include even such primitive functions like ranking, linking of multiple...

Part and Inventory Search

Back
Top