Hi Nancy. 1. When you install Brio, it creates an Access database called Brio 6.0 sample Advanced and an OCE to connect to it called Brio 6.0 sample ...
Katherine The error is IIs Web Server error itself. Are you getting the Brio Welcome Screen ? The initial step is to ensure that the IIs Services has been...
Hi all, I ended up using Adam's suggestion: minutes/60 and rounded - to just show total hours. Thanks for eveyones help on this! If anyone knows how to sum...
... have ... turned ... It works fine at our site. The only occassions where we had problems is where Brio was installed by the machine 'administrator' and...
Hi Katherine, Maybe this will help you. If you can find the brio.html file under \Brio Intelligence Server\Server\HTML directory you can trace the html code...
Hi, I got a question about how to count top a few rows in the report. I have a report has cloumns "account name, sales", and I sort it by sales descendingly,...
Sort sales descending in the query. Then in the Data Model Options, in the General tab, choose the "Return first xxx' Rows and set it to (say) 200. Gary ... ...
Hi Gary, Thanks for your reply, I guess I didn't explain clearly. What I want is that not only the top xxx rows, I need all query results first, and sort them...
We are currently upgrading our user areas from Brio 6.2 to 6.6. Some of our users are using the BCS (Broadcast server (scheduler)). Can BCS version 6.2 work...
Hi, I just started working on Brio..( 2 weeks back) Can I someone help me in validation of fields in EIS section..Is there any common script available for...
Well, as in all javascript, there is no quick and easy native method or anything, but if you want some nice validation tools you can incorporate into your...
I am trying to find a difinitive answer on duplicating queries. I am using BrioQuery Designer 6.1 and would like to set up duplicatable queries for users. I...
We have a position available for a consultant with BrioONE (Portal, SQR, and Intelligence) experience. BrioONE is installed on a Unix platform with Sybase as...
Not sure if v6.2 works, but we are currently using v6.5 against v6.6 server without too many problems. I never tried v6.2 against a v6.6 server. I don't...
Help - I attached the JavaScript code that is behind our Process button for this OnDemand Report. I have hid the other buttons and will make the user select a...
Brio support always recommend the server and client versions are the same. If they are not, and you have problems, the first thing they will ask you to do is...
You could try this: In your result set, add a computed column using the rank function, to rank the sales. Then create a table based on the result set and add a...
Yes, According to the BRIO documentation, it says that it has to be 'enabled' by the administrator (me). Yet it does not explain how to do that. Tom ... ...
Tom, If memory server me correctly the ability to duplicate a Query was introduced with Brio 6.2 which was released in around mid-2000. Why are you still on...
I am looking for feedback as I am trying to put together a FAQ on "Oracle OCE's Best Practices and Tunning". Both ODBC and SQL Net/8 All feedback is...
By the Brio SQR Evangelist himself! Darrin has been doing this longer than anyone I have ever personally met. And he is likeable to boot! ... Check ou his...
I have Insight, QV, Designer on my machine, O/S Windows 2000. I want to be able to open different ODS queries in either Insight or Quickview. At present the...
At first glance, all I can see is that you appear to be missing an opening bracket "{" in your FOR loop ... for ... the ... button. ... seems ... be...
I have two dates: OPEN_DATE and CLOSE_DATE I need to be able to calculate the BUSINESS HOURS involved in closing the item. Business Hours in this scenario...
I'm activating a standard (i.e. non-EIS) pivot table from an EIS section and want to somehow show the limits on the results in the pivot table, without using...
I don't follow your example. If "Business Hours in this scenario are: Mon-Fri 8:00am - 5:00pm" then how is it possible that "something was opened on FRI at...
Follow the current World Cup Cricket competition in South Africa using a Brio powered dashboard. Look at the current and prior competitions, team and player...
Hi Terri, The only way I can think of is to add a computed item that holds the limits that are active as a string and then you can add that column as the first...