Search results for query: *

Thanks Blom, Followed your tip. You know what I did...yeah!!

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

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.

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.

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

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

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

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.

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.

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

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

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

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

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

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

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.

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

Cool. Thanks Blom.

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

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