Questions tagged [brio]
13 questions
2
votes
1 answer
using excel vba to open specific version of brio (hyperion reporting studio)
I was using Hyperion version 9.3.3 to process my queries and was recently upgraded to version 11. The problem I'm encountering is that version 11 doesn't have the same amount to computational space as 9.3.3, so until I create a solution to this I'd…

Slow Joe Crow
- 21
- 1
1
vote
3 answers
Brio save file without column headings
How can I prevent the column headings from appearing in a .txt save file in Hyperion ?

C J
- 21
- 3
1
vote
0 answers
Issue to take picture with 4k resolution using Logitech Brio webcam and "pygame" in python
I am using "pygame" in python (the code below) to take an image with 4k resolution using Logitech Brio webcam.
# take picture using pygame
import time
import cv2
import pygame
import pygame.camera
from pygame.locals import *
start_time =…

Abbas
- 71
- 1
- 8
0
votes
0 answers
Add Database specific hints to BRIO queries/reports
Is there a way to add db specific hints to Brio queries.
I'm looking to improve the performance of a bunch of brio reports that connect to a MS SQL database to pull data. Brio seems to be creating SQL queries with not hints like
WITH…

nJoshi
- 376
- 1
- 5
- 16
0
votes
1 answer
How to extract report based calculation from BRIO report?
How to extract report based calculation from BRIO report ?
For example Multiple Requests
is there public API available to do this task?
Enter code to remove the fields you want to hide from the Results section after the query
finishes processing.…

Rahul Patel
- 307
- 1
- 9
- 27
0
votes
1 answer
Execute Brio queries using java api
I have few .bqy which i am now running it manually using Hyperion client. Is there any java api to connect to Hyperion designer and run the brio queries(.bqy) and extract report out of that.

Amjad Ahamed
- 1
- 1
0
votes
2 answers
Using Javascript to read metadata from .bqy (Brio query file) file
I have some .bqy (Brio query file) files I need to loop through them and read the metadata which is the OCE (database connection strings) and write them to an excel file.

ivric
- 109
- 1
- 6
- 24
0
votes
2 answers
Updating an imported .csv in Hyperion v8.3
I have a csv imported into my Hyperion v8.3 bqy file. I have some custom columns and a pivot already created. I just want to refresh the data. In the past, I would hit Process Current and it would direct me to my computer and I could select the…
Eric
0
votes
1 answer
Is it possible to create dynamic drop-down boxes in Hyperion Planning forms
I'm working on my first sandbox Hyperion planning application and I'm curious if its possible to create dynamic drop-down boxes in planning forms. For example, if a form requires the planner to select a Team/Cost Center, Company and Currency would…

Mutuelinvestor
- 3,384
- 10
- 44
- 75
0
votes
2 answers
Access to multiple data sources using Oracle Brio
Trying to build a dashboard using Oracle's Brio. I have to access 6 different databases to grab the same type of data, aggregate it and display it. Except that when I do it, Brio grabs the data from the first source just fine. When I grab the…
Murat
0
votes
1 answer
Using Regex with Brio (Hyperion Interactive Reporting)
I am trying to use Regex with Brio interactive reporting
I have a column in the results set called event. There is a compliance guide how this event should be inputted. The aim of the report is to find out who isnt doing it correctly and correct…

John Smith
- 2,448
- 7
- 54
- 78
0
votes
1 answer
UNION Query with hyperion Reporting Studio 9.3 (BRIO)
I’m using Hyperion Interactive Reporting Studio version 9.3.1 to write my first report.
The query that I am trying to produce is in the form
SELECT A, B FROM CW_STATEMNT_BEN_FEAT
UNION
SELECT C,D FROM Table2
…where the data type of A and B…

Chad
- 23,658
- 51
- 191
- 321
0
votes
2 answers
Missing semicolon in JavaScript / JScript
I have the following code that I am writing inside BRIO (Hyperion Interactive Reporting Studio). The code is either in JavaScript or JScript, though I am not sure which as I am just learning the syntax and am not sure how they differ.
Anyway, I am…

Scott Holtzman
- 27,099
- 5
- 37
- 72