In older versions of BRIO, you could create column groupings in your results, and then if you wanted to modify them the option "Modify Column" was available....
That sometimes happens, and it seems to be a bug. Try closing the document and opening it again to see if the "modify" option becomes available. Steve. _____ ...
Hi, Can any one send the code to calculate the number of business days between two dates. I am browsing through the groups and I found that the code is...
I appologize to the group if I have picked the wrong venue for this question. I have a client who is wondering why they should upgrade to Smartview from the...
Has anyone tried to create sort of like a jscript file library? Something like on one script file you have all the functions like process queries,export...
Hi all, I am new to this group. Also, a fresher in Hyperion. We are not able to use the Constant operator, bqLimitOperatorBetween. Can anybody please help me...
I have created a scipt library via SQL. meaning, I have set up a database table and in it, I store all the scripts. I use a query to process it, and then use...
Hi everybody About 2 years ago I installed Hyperion V.9.3.0 in a client, during these 2 years the client have published reports, created oce's, created users,...
Good morning: I have the following script as a OnPostProcess document script. It works fine in the client but once I publish it to the workspace, it is not...
I have values like this Name Sri/Krishnan Raghu/Raman Shankar/Vijay This column has to be splitted as FirstName Sri Raghu Shankar LastName Krishnan Raman Vijay...
I am using Hyperion (BRIO) Explorer 8.3. For many of my queries, I have to use several thousand values for the limit parameter. For example, I have to query...
Hi ss. Instead of using the Advanced option, do the following… Open your query and go to File >>> Import Data File. Import the .TXT file that contains your...
Thanks Kyle, I think this should work. However, when I drag the table of order #'s, it just brings in the first order number. Then the datatypes do not match....
You may have to add a computed column to create a column with the data matching the datatype in the table you are querying. I have had this problem as well...
Hi Jeff, Thanks! Yes. The column header was the issue with that particular question. I am still working on the other part, i.e., to make it work for a table...
Have you tested the Local Limit to determine if the 1000 limit is in fact an issue for you? I do not know that I have ever used a Local Limit with that many...
what I would do is to create a query that loops thru the text file you have ... From: Jeff Marshall <jeffrm@...> Subject: RE: [Brio Users] Max number...
Anyone have idea about how many numbers of columns we can process at a time from a query on server? I have a query section which have 110 columns which i am...
i'm an expert user of Brio (version between 2002 and 2004). the version escapes me at this time, but i think it's ver 7.6. regardless, it's an old version of...
Hi, Create a DSN for the text file Prepare a simple query and run it Use the results of the query with this Query section. This will allow you to use more than...
programming on brio 5.5 (around 2000) to Brio 6.5 ( around 2004) to the Current ( 9.3) has change significantly if you plan to use a lot of the NEW IHMTL...
Hi all, I have been trying for some time to build a query that, for several reasons I think are good, I am using local tables to lookup information based on...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the briousers group. File : /Problem with...
briousers@yahoogroups...
Jul 22, 2008 6:43 pm
15683
I am using Hyperion (BRIO) Explorer 8.3. Does anyone know of a quick way ( command or query ) to answer the following questions: (a) All the tables that...
Hi Bill, I had a look at your document, and it looks like you've got the 'outer joins' sitting the wrong way round. Brio has a bit of a bug in the 'outer join'...
Hi Andre, You are absolutely correct. I have them right in my current experiments, but somehow they got turned around when I reorganized the picture for this...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
