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…
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.
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