I have an application that, if the user selects too large of a date range, the query will time out due to a set TimeLimit on the Query Property. When this...
What version of the product are you using? Assuming you are using version 6 or greater, use a TRY CATCH block. Catch the error, evaluate it and use an Alert...
I'm using Version 8.2.3. I tried using the Try Catch function, however, If the Query Options limit the query to a number of rows returned, or limited by a...
We have a ODS 6.6.4 uanble to retrieve report from the web after the user login. When we open a bsm, to modify the report, it complains that the data model...
It would really help if people would read the documentation before posting. In the online help for the dashboard section, script editor, look at the section on...
Look for the .split function on a string in the Help. var strToSplit = '0817_BdrBotanic_BOTNM1_7' var Separator = '_' var arVals = strToSplit.split(Separator) ...
I'm currently running Hyperion 8.3. I have 3 separate queries to calculate sales history for year's 2006, 2007 and 2008. Each one of those queries returns...
Wow, no surprise you are out of memory. You are returning a ton of data. There are probably otherways of achieving this result, but they may require more...
Thanks for the quick response. I¢ve never tried using a table catalog before so I¢ll do some research on it. I think I can resolve my issue if I could...
Hello Ruben, Brio creates a group by when a computed column is added to the request line. You can also use the Custom SQL option to edit the statement sent to...
I'm trying to create a bar/line chart and have the bars be clustered instead of stacked, but when I go to the Properties and check the box for Cluster Bars...
Ruben - I believe you are trying to run this query from your local desktop, for which Brio definitely needs hell lot of memory. My suggestion to you is to...
I have to modify a query that covers 38 requests, w/ 7 Limits against 7 database tables. My problem is this: I have to filter the output to return only the...
... Solved my own problem. Solution for future searches against this subject: I did have to create a correlated sub-query wherein the Max value for the test...
Hi Steve I've tried adding a total and changing the data function but it changes everything in the column to % not just the total alone. How do I change the...
You should be able to use the ALT key to select the Total Row only. Then change the data function. Tirence ruben24 <ruben24@...> wrote: Hi Steve I've...
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...
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.
