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.
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...
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.