hi I need to open a brioquery document located in the Ondemand Servr 6.6 Thru open url(), plus, when de document it's open, Ineed to encript the url regards ...
hello! I am a new member of Briouser group! I am currently developping a datawarehouse over Hyperion System 9I+ Interactive Reporting studio. I am writing you...
Hello, In Hyperion Intelligence Designer in the query tab menu, go to 'Data Model'/'Data Model Options'/'Auditing' and click the 'define button for the 'Pre...
I am trying to add the following excel formula into a workbook using a brio joole script: =IF(ISERROR(F14/G14=TRUE),"",F14/G14) I can add the formula F14/G14...
I am trying to use the offset function in excel to move 2 cells to the right but am having problems I need to go to the bottom of a column, so I pick one 2 to...
I think you just have a parenthesis in the wrong place. Try this ... IF( ISERROR( F14 / G14 ) = TRUE, "", F14 / G14) ... From: briousers@yahoogroups.com...
Kyle - thanks for trying to help, however I think I maybe didnt make my first statement clear enough... The full line of code I am trying to use is: ...
Kyle - thanks for trying to help, however I think I maybe didnt make my first statement clear enough... The full line of code I am trying to use is: ...
Your speech marks " are confusing the script editor as you've got them inside your formula as well as enclosing it. objCurrentSheet.Range("H14").Formula =...
The problem is you are using a double quote all the way through your expression and Javascript does not like it. Excel wants the double quotes. Try this: ...
Hi..all I am also have same problem when using JOOLE to replace.. objCurrentSheet.Range("H14").Cells.Replace ".", "," then i get a brio error saying that I...
Sorry to bump - but can anyone help with this? Am trying to get excel to select the cell 2 to the right of the current selection - I would expect the below...
i am getting a problem trying to use Brio to select a range from my end cell to H15 on a workbook. I have got the code to make the active cell the last one in...
I'm Using Brio Intelligence 6.6.4 This is what i'm trying 1) Depending on the values of list boxes on EIS page i'm generating customized query (call it Query5)...
In javascript you are not in a scope where Selection is valid like it is in the Excel macro. In the same sense, Range is not valid so you need objCurrentSheet ...
Hi, I need to take 2 numbers and a string and concatenate them into one field and export that to text file (tab). PO Field = 'AR-00231' Field 1 = 28 Field 2 =...
Don't worry about the bad formatting in the custom sql window, the sql it shows is not what it actually runs. To see the "real" sql, turn on the query log and...
Hi Steve, The result set is not generated, if I try to process the quqry an error saying "SQL not properly ended" pops. I can't use the regular approach of EIS...
Hi, Field 2 has to padded with zeros to 6 places so for example 000007 and 004567. I can't do this with concatenation because there is no pad function to use....
Hi Dan, For your first numeric field create a computed item: Substr('000000' + ToChar ( <NumField1>, "0" ),Length (ToChar ( <NumField1>, "0" ))+1,6 ) and set...
Could anybody please guide me in this. I want to call a Java Class from the login screen of Brio. (newlogon.changepwd1.html) Here is my applet code added to...
Good afternoon all! I will first apologize, as I have checked for any posting of rules for posts for this message forum and did not find them. I am seeking...
Hello, I've been reading thru this group trying to find a solution to the ODS 1010 error. I've got about 20 users using the Brio Insight plugin. About a...
Hello, In preparation for our upgrade from version 6.6.4 to 8.5 or higher, we need to get 'migrate' our stuff to 8.2.1 We have a server running 'Windows 2003...