Mary, I've successfully run Hyperion/Brio Intelligence (BrioQuery) on a Mac using both VirtualPC (PowerPC Mac) and Parallels (Intel Mac) and it works fine...
Hello, I have a small problem with a Hyperion report. After I drag into the report (not dashboard) all the pivots and the other things I get two pages instead...
If you are dragging pivots into there you may need to change the font sizes on the pivots or tables you are dragging into the report. Make your headers and...
Hi, Thanks for your quick reply. I have tried what you have recommended and it indeed worked. I have also tried that but it seems I have tried it wrong. Many...
Hello again, Yet I have another question regarding Export option in Brio. What I have in a bqy are multiple dashboards which I want to save as a single file in...
Hello there, I would like to ask another question now. This one would be about pivots and how to add them if possible. Here is what i have. Two queries with...
Hi, If I try to drag/drop a synonym into the work area in order to add columns to the request line, it doesn't work. I can view the synonym but I can't seem...
hi, i have some code that exports files as pdf's to a particular folder. i can attach one file to an a-mail and send it automatically via outlook using the...
I'm using it as a separate line item. At this point, there are only 2 files but I expect it could be more in the future. ________________________________ ...
What you may want to do is name your sections with a preamble for post able and use a loop to identify them so that you don't need to explicitly name them...
Good call - thanks ________________________________ From: briousers@yahoogroups.com [mailto:briousers@yahoogroups.com] On Behalf Of Simon, Jason (MBS) Sent:...
I have a job that is migrated from Version 6.6.4 to 8.32 SP4 The job owner has left the company. I want to de-activate that owner. If I take away the...
The JOOLE allows you to cut and paste the result section. However it is not Exported WITH the formatting. The formatting would either need to be written via...
Here's a snippet. Obviously, you can go crazy with this. You can put this into Brio's Sample1.bqy that comes with the install. There is a limitation to how...
Hello All, Can anyone shed any light on known redraw issues with the Brio/Hyperion web client? I have some embedded result sections in a dashboard. When I show...
I am using Brio 6.6.4 and pulling against an Oracle database. I have a subquery that should return 15,000+ distinct rows as a limit to a unique ID (UID) field....
... what ... That's a good question, and since I never use sub-queries to get distinct rows (but rather a 'table' and limit that), I wouldn't know. However, if...
There are two types of subqueries. Regular,and correlated. In the case of a regular sub-query, Brio processes the sub-query, then passes the results to the...
I used the local query idea before trying the sub-query. I did an equal join on the local query and the main table of the second. However, the second query...
Make sure that you include one of the fields from the local results in your second query or sometimes the join does not work. It may be a bug or how it's...
You need to specify a “Local Limit Join” instead of an Equal Join in the properties of the join between the main table and the local results. The Local...
Usually there is a limit of 1000 values that can be passed as limits. This is a database setting. The DBA can change it I believe but I haven't run into anyone...
Thanks, Jeff, but Jason is correct in my case; I am limited to 1000 limit values. I have never used local results for the sake of limiting a query's results. I...
Hello All, Need suggestions on best possible solutions. We are using Hyperion Intelligence 8.3.2. Client has a BQY file that connects to a database, and...
I am trying to understand what you wrote here so bare with me. As you explain it in the post, you are already creating the documents in "pdf'" format and then...
If you have SQR it's a much better option for this kind of report. You can use the new-report command to create separate pdfs for every invoice/store. You...
Did you change the owner of the job? ... From: briousers@yahoogroups.com [mailto:briousers@yahoogroups.com]On Behalf Of aemjr1953 Sent: Wednesday, March 21,...