Yes, this can be done. You can script individual Brio documents to do things on startup, so any scheduling application that can launch files will work. You can...
Hi! I need to export a Hyperion resultset into Excel. I am successful in opening the Excel worksheet and pasting the data. However, to make the resultset look...
how I make this: select t1.field1, t2.field1 from table1 t1 left outer join table2 t2 on (t1.field3 = t2.field3 and t2.field4 = 1) I'm able to do this only: ...
Unfortunately the paste values doesn't work within Excel. I spent a few bit of time on this a few weeks back. You may have to loop through the column clearing...
Hi Julie, I know I am rather late, but I am a Free-Lance Brio/HPSU Singaporean consultant in Singapore, graduated from the University of Michigan, Ann Arbor. I...
Hello, we are using HPS 8.3.2. with AIX 5.3. and websphere 5.1.1.6 on Windows 2003. I can't delete any thing on some folders. As soon as I click on "Delete ...
The only other query tool I have on my pc is MS Access and it returns a non-truncated result. That is why I think it is most likely a Brio bug. Should I get...
With the outer join, you're attempting to obtain data that does NOT exist, so how can you specify a where clause for it? I've had good luck using OR ISNULL....
Hi Dan, It's definitely worth seeing the result from a MS SqlServer direct query (using the same username/password). Another thing you can try is to create...
Hi.. query#1 ... the drill through option of connecting with RDBMS which is present in EIS ... can only be used with MS excel addin of hyperion.. I am not able...
I would like to create a week year format but when I try to group the WW all I get is WW back :( is there a week formating function in brio. By the way I am...
I think you are out of luck on this one. The imported file never shows up as a topic when it is dragged into the work area with the other database table. The...
Hi there, With To_Char (MY_DATE_COLUMN, "WW" ), you're telling it to only return the week (WW). Maybe you could try: To_Char (MY_DATE_COLUMN, "YYYY/WW" ) or ...
Are you doing this in the Request/SQL or a computed item in the Results section? if results I do not believe that the To_Char has a fomat for week of the year,...
Thanks for your response but apparently no one thought we would use version 5.5.6 so long and threw out all the manuals. I have found a manual online but I...
Jason the syntax guide I am referring to is for the Database you are using. There might be a builtin SQL function you can use. What Database are you using? ...
We are using Oracle _____ From: briousers@yahoogroups.com [mailto:briousers@yahoogroups.com] On Behalf Of Wayne D. Van Sluys Sent: Wednesday, December 07, 2005...
Thank you so much I will take a look at them later today! _____ From: briousers@yahoogroups.com [mailto:briousers@yahoogroups.com] On Behalf Of Wayne D. Van...
Executing the query directly on the SQL Server box using Query Analyzer resulted in the trucation at 4 decimal places so it appears to be a SQL Server issue....
The column that you are pulling from could have a 4 decimal place property. Is the column Real, Integer (16 or 32 bit)? If it is a formula in a computed...
Hello, I would like to know how to use this loaded from file which is at the Limit. Is it only from text file? Do anyone know the format of the text file...
Yes, it is only a text file. Put each limit value needed on a line by itself. No "header" or "label" is needed- the first line in the file should be a single...
Hello Ming, Yes, the 'limit' file should be plain text, single column and in the same format as the database 'column' that normally would hold the values. You...
Hi Dan I'm affraid I can't help you there as we don't use sql server here. I think this is a problem that should be explained by your DBA, or you could try a...
In working with startup scripts I have been able to set up the auto login and process (works great). But when I try to set it up on a query that requires 2...
We are getting Server Error as follows when we schedule a brio file "Failed to acquire Data access: Invalidate DB User..." Except this file all other BQY files...
You verified the DAS entry for that datasource is correct? ... From: briousers@yahoogroups.com [mailto:briousers@yahoogroups.com] Sent: Sunday, December 11,...
