We are tyring to remediate brio reports with a new oracle database. I took the script for a stored procedure which resides in our current oracle environment -...
Lots of hits in Google; http://www.google.co.uk/search?hl=en&q=ORA-00904&meta= including this at the top; http://ora-00904.ora-code.com/ You could check your...
Hi, Is there a way using Brio 8.2 scripting to step through the records of a result set and write a text file that has custom space delimiting? TIA, Dan...
I wouldn't call that UTC format. I would call it unix time or seconds from 1/1/1970. I mistakenly assumed you had a formatted date that was in the correct...
Hi Dan, Just stick all columns in a single computed item, using the Concat functionality (or just use +, like <field1> + ' ' + <field2> etc. or '"' + <field1>...
Thank's for the information.... The returned value should be 25 Apr or 26 Apr ? ... From: Kevin Sigl To: briousers@yahoogroups.com Sent: Thursday, May 04, 2006...
I need to extract surrender transactions from my database where the surrender date is within the last 6 months. The date range will change from month to...
H1B professionals needed for US skills : DWH with Valid H1B location : US pl send ur profiles to abba_consultants@... abba_consultants(at)yahoo.com ...
Assuming there's no other reason to be using your month table, you're probably better off basing the limits on calculations of SYSDATE (or whatever your...
Hi Bharath I would like to get a job in India. I am located in the US. would like a job preferably in Pune (MS). I am returning to India in Aug 2006. Please...
Hello - I'm trying to attempt the following and it's driving me crazy ... please help! I'm using Brio 6.6.4, Brio Scheduler 6.6(?) on an Oracle DB. I have a...
Sysdate>=Valid_From AND (Sysdate<=To_Date OR To_Date IS NULL) ...prefacing with the table name (or "Request"), of course. Adam Franz Independent Consultant ...
We had an issue with the cleanliness of the userid grabbed from the cookie in 8.3.1, 8.3.2 SP3. Users log in w/ their email address, and there is some...
Dear All, I had developed Brio reports and wants to show Page X of Y on each page. But, when i draged the Page X of Y field on page header of report, it shows...
Kevin -- typing too fast, you're correct that I meant VALID_TO instead of TO_DATE... Adam, thanks for the tip -- I was able to get my query to run correctly,...
View the Query log and capture what it's actually trying to send. ... __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo!...
It's designed that way, and arguably a good thing. When creating a report, you need only load one or two pages in memory to create a report. Loading the rest ...
FYI it will also calculate if you export the report. Basically whenever you do something that requires it to load all pages into memory (print, export or...
Hi, Hyperion Designer 8.3.0. creates outer joins with OUTER JOIN statement, but I need the (+) Oracle join operator. Where can I set it? It seems that Oracle...
I think (in all versions) it's an OCE setting, isn't it? The "use Oracle outer join operator" setting? Adam Franz Independent Consultant Phone: 603-661-6194 ...
Hi all: I am sure that brio server will be having this option. Our server fails to run the jobs when the database is down. So we usually restart the server...
Hi Matt, The solution is simple. Do NOT shut down the Broadcast Server when the repository database is down. It just keeps polling on the set times, which...
Okay, I'll try to keep it simple here and avoid things like ISO dates...assume that the column you listed as "MyDate" is actually a date (even though it...
A Brio report, that has been used by the business for the past 4 months has suddenly started failing. It runs successfully about 50% of the time and fails the...
