We have recently purchased BO, and I have been reveiwing the BO Planning and Deployment guide to get an idea on how to distribute the various system components. Can someone give me an example of how to build out this environment. We currently have about 400 users, but no more than 20 different...
I have been asked to extract data from a custom Exchange form into a DB(oracle), for reporting purposes. This is how the data is collected: A custom form has been created to track sales call info. When a salesrep needs to set up an appointment, he/she logs into Outlook, and navigates to the...
I have one more question for the day.
I am having problems finding help on 'if else' constructs.
I want to do the following:
select cola if cola > colb else colb
from mytable
Thanks in advance!
VB
Can someone help me with the syntax for creating a simple loop.
I want to do the following:
Start with a number (lets say 5), then I want to multiply this value by a simple calculation (i.e. (5 * 3.14) / 10 = 1.8055).
I then want to take this new number, and apply it to the same calculation...
Is there a way in Crystal Reports to take two dates
i.e. (Thursday Jan 3,2002 5:30pm to Tuesday Jan 8, 2002 9:30 am)
and extract out the number of hours BUT only adding up the # of business days (mon - Fri)?
For example, using the above dates, the total # of hours would be 4 days, 16 hours (112...
Is there a way in Cognos to take two dates
i.e. (Thursday Jan 3,2002 5:30pm to Tuesday Jan 8, 2002 9:30 am)
and extract out the number of hours BUT only adding up the # of business days (mon - Fri)?
For example, using the above dates, the total # of hours would be 4 days, 16 hours (112 hours)...
Is there a way to get Impromptu to use the proper index (Oracle DB). I have two indexes which compete with each other. Several of my reports have prompts for a date range, and therefore use the "order date" index, while other reports do not have a date range prompt, and use the...
I'm in the process of re-creating several Impromptu reports, to go against our new data warehouse.
However, some of these reports are no longer being requested.
Since I do not know which reports are being used and which are not being used, is there some sort of a log file which keeps track of...
I'm having a problem with precision in Impromtu 6.0.
I am calculating a column (unit_price * Qty), but it keeps ignoring everything to the right of the decimal. I.E.
(29.95 * 1)gives me 29, not 29.95.
The columns are: unit_price (number 13,5) and qty (13,4)
I can paste the sql ito a query...
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.