Does anybody have any idea of how connection to database could be closed after processing of each query in case of ad hoc reports. The ad hoc reports here mean...
Hi Gary, Did you get anywhere with this problem? I really need to use the PasteSpecial function to paste just the values not formulas. Is there a work around...
hhhmmmm What I am currently doing is copying a pivot into an excel workbook. I then need to fill all the empty (null) cells with 0's. The way i do this,...
Hmmm... SO, you are trying to paste-special OVER the cells with data, .e.g. over themselves... Unfortunately, I too have had to revert to the same solution you...
Our client has a full-time contracted position in the Torrance, CA area for an experienced Hyperion Intelligence Developer (Brio) starting in November 2005....
Hi Ganesh, Not sure sure how you can force a disconnect, but you can set a time- limit in the oce for a connection. After the time is up, the user gets...
I want to run a query for todays date but when i type it in on brio i need to put (say for 3rd nov) 11/04/2005 into the limit box. is there anyway i can put in...
Hi, Could you tell me who to aggregate optimally certain information by using a defined key in BRIO (Hyperion). For example, if I had the following table...
hi all, I am using Brio for reporting and I need to export it to pdf with hyperlinks. When I insert a test label with <a href> tag, it is exporting to html...
For #1 create a query from table A that has id and US$purchase. Right click on us$purchase and choose data function sum. For #2 check the rowcount property. ...
I wanna know whether broadcast server of version 6.6.3.15 is compatible with the following combination ? If no, then what are the known problem issues ? and...
I currently create reports that connect to csv output from a data tool. I have had these reports running stable for several months with good customer...
Hi There, Which operating system are the files stored under? If it a windows one, then the 'Microsoft Txt Driver' should be able to read them. Otherwise you'll...
Hi There, You will have to upgrade to Brio version 6.6.4.44 or later as far as I know. André NZ ... compatible ... problem ... advice. ... responding"....
Thanks Andre, Then, does it mean that .... if I stick on using Brio 6.6.3.15, then there would be a compatibility issue or even encounter operational error....
Is there a way to format the date in the document scripts so that when I use the iHTML version in 8.x it shows the date in the 'mm/dd/yyyy' format when I use...
I have query where I so 'Sum(Sales - Cost)/Sum(Sales) = GM%' and 'Sum(Sales - Cost) = GM$'. The Sales is $150,045.05 and Cost is $123,742.22. The Results...
We had problems with the Oracle client v9 connecting properly. Our setup at the moment is Brio v6.6.4.50, Windows 2000 Advanced Server, Oracle client v8.1.7...
In the ODBC Administrator there is an option to use a custom delimiter. Maybe if you know how many commas separate the columns, define this in the customer...
I used the following query to get the Brio Cat information in Hyp 8.3. However, for some reason, the folders that I created on Hyp 8.3 portal get encrypted on...
Although we use 6.6.4.44 on our desktops, we do use Broadcast 6.6.3.15 as scheduler on Windows 2000 server with Oracle 9.2.0.1.0 , without any problems. I can...
Dan, This is not an error. The GM% is 0.1752995 and you are rounding to four decimal points which .1753 is correct. You can create a computed item to 4...
Two things to try. First, you are doing a CustomValues.RemoveAll() just before a SelectedValues.Add(). I think you may need to do a SelectedValues.RemoveAll()...