What I get using Rank Dan 100 1 Dan 200 1 Dan 400 1 Bob 100 2 Bob 200 2 Bob 300 2 I used the cume function successfully. Dan ... On Behalf Of googlepost123...
Hi Everyone I hope somebody can help me with this... How can i make reference a Sheet2 of the book in excel from Brioquey ?? I need paste a chart in one sheet...
I've heard that HPS 9 will only have support for the Security Platform Driver, which uses the CSS_Config.XML file in BrioPlatform/etc folder to specify...
Hi, You need to use the following command: objExcel.Sheets.Item(1).Name = "name" just change name to whatever you want to call it - ie January. For the 2nd...
Thanks Paul... but i found this code... var objExcel = new JOOLEObject("Excel.Application"); objExcel.Visible = false; objExcel.Workbooks.Add var objBook =...
To delete a sheet the code is just: objExcel4.Sheets.Item(3).Delete; That would delete the 3rd sheet tab (ie sheet3). Just add that into your code for each...
We are to be installing for our next release Hyperion Version 8. Does anyone know if you can union result sets with this version? Does anyone know if you...
Via script, I need to be able to take the limit names from one query and put them into another query. Any ideas on how to do this??? I want to do a FOR loop to...
ActiveDocument.Sections["query section name"].Limits[i] is the i'th limit of the query. You should be able to use that in your loop. Cheers, Steve ... From:...
Steve -- Thanks, I'll give that a shot!! ... i'th limit of the query. You should be able to use that in your ... On Behalf Of balemay ... query and put them...
I am creating a report and have grouped it into four different report groups. I have four different table dimensions one of the dimensions has data for one...
Does anyone know the fix to this ? In the LIMIT section (6) of Dashboard Builder, when I try and set the limits on an open BQY, I get the message : An error...
Look under the properties for your limit, there is a LogicalOperator ActiveDocument.Sections[QueryName].Limits [2].LogicalOperator=bqLogicalOperatorOR the...
The term you're looking for is "Logical Operator" (not clause). Logical operators can be changed programatically by accessing it as a property of the limit...
I was wondering if anyone could help with the following problem on the Broadcast Server, v6.6.4.50. We have some FTP actions that will fail intermittently and...
Hi I need to have this in brio but don't know how to do it b/c brio doesn't seems to handle trunc( date ) function. trunc(sysdate-9,'D')in oracle Would...
Just type that into a computed request item. Make sure after your done to set the datatype of the field to date, since that is not the default for trunc in...
The release of HPS version 8.x has opened up an opportunity to insert Embedded Browser Controls. Working with one of the local reps we were able to beat BO at...
I'm getting an error when I try to upload a BQY document using the SDK. But the file lands in the Hyperion Performance Suite just the same. Here is the...
I have a Completion date ( in date and time format) and Elapsed time in minutes. I am trying to do calculation to get Start Date and time. something like...
