If I have a saved layout using the HTML wizard, how can I incorporate that into the Broadcast Server? If I use the Export to HTML section in the Broadcast...
Hi Rob, It is good news to me. I'm connecting to MS SQL 7.0 database. If you need more information please let me know. Thanks, Sarah ... wanting to ... On ... ...
HI all, I have a dashboard (using Hp designer and Hyperion performance server 8.2) with a number of pivots. My data is on sql server, which i refresh everyday...
I've created 2 separate queries from my .oce connection and would like to append (or union) the both of the table results. I've set the results so that each...
Henry, Adam has an excellent example on his web site at http://www.adamfranz.com. hth ... From: briousers@yahoogroups.com [mailto:briousers@yahoogroups.com]...
Ok, here goes. Create an odbc connection to your sql server don't bother selecting a default database. Create a new OCE connection select ODBC connection...
In the date section I need to see Jan 1, 2005 as 05001 Mm then 001 is jan 1 feb 1 is 32 dec 31st would be 365 so the date that I need would be 05365 Anyone...
Looking for the SQL that help be get rid of / for example50/300 150/150 0/300 1000/2000 I only want to bring back the numbers leading up to the / 50 150 0 1000...
here is what I ended up doing...I knew that the number before the / would be no greater than 1000 CASE WHEN SUBSTRING ( F , 5 ,1) = '/' THEN SUBSTRING ( F , 1,...
Is the Mac insight helper application from 6.5 compatible with the 6.6.4.50 ODS server version? Our MAC users can't access the reports with the 6.5 insight...
var dt = new Date(yourDateField) var yr = String(dt.getFullYear()) var frst = new Date("1/1/" + yr) var dif = Math.floor(dt - frst) if(dif < 10){ dif = "00" +...
The syntax and functions available vary from database to database, so in the future please specify what database you're working with when you ask a SQL...
Hi Just wonder if there is anyway we can load the brio doc via SQL script instead of using brio server job list to add it one by one. Would appreciate very...
Sort on number then create a computed column that uses: Cume(user, Number) ...and one that uses: var x = Number var y = Next(Number) eval(x != y) IMPORTANT...
Why not just create a pivot and put the number in the sidelabel (on the left) and the names in the facts area (on the right). As names are strings, they...
If you don't mind doing the seperation as a computed item in the Results section, this is rather elegant: Column_to_be_parsed.split("/")[0]; ... the / would be...
Hello all! I do not have much experience with Brio and I am faced with a task to format a number into elapsed time in the form h:mm. For example a number 2.75...
Hello Maria, If you're querying an Oracle database, just 'modify' your request line item, and write the syntax of the requested item as you would in an Oracle...
Hello Andre! I also thought about this but I need a detail rows plus a total row. So if I format them like this: 2:45 (2 hours and 45 minutes), using trunc and...
Maria, perhaps you can modify this script to meet your needs. I use it as a computed statement in tables and pivots, so it might also be used in a report...
I have a function that does this from seconds that could easily be modified to what you want. What you want, I believe can only be used in a result/table ...
Hi Dear Kevin! Thanks a lot! It was a great help - I did not know where to put the javascript function ;-). Now I got it and I modified the function because I...
I have a couple of quick (I hope) Hyperion questions. I'm trying to create an Organizational Administrator who can add users to two specific groups. In order...
Hi Steve, Both these tasks would be pretty simple using the SDK. You can use a query to return an array of objects (e.g. users or bqy's), then loop through the...
Steve, I thought about using the SDK for both tasks but had some reservations. Using the SDK to grant list access on all users would require the program to be...
I thought LIST was the default for all users? Rerunning the job shouldn't be too much of a problem, it should only take a few minutes for thousands of users. ...
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.
