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...
Hi Need help . Trying to migrate the Hyperion performance suite 8.5 from Development server to Production. Require help in this .Also in the production...
There is an extensive migration help document available from Hyperion Support (now Oracle Support?). However, if you don't need to copy/migrate loaded...
Hi , I am new to Hyperion performance suite . Require information My client wants to monitor the errors of Hyperion Performance suite 8.5 So before that they...
creating a report that uses one record (actually 95 records, but have use cume function and flatten to one record) per individual survey. This a TOTALLY...
how to lock a BRIO Result in a Query document? Coz we create and give the results to the team and they change the sorting which screws up the added colums...