Search results for query: *

Another good site is: http://www.w3schools.com/

To open a cube choose File --> New. When you are doing File --> Open it's trying to open an existing saved report.

Why assume twins will always be born on the same day? What will you resolve when twins are born on different days? ex: 01/01/07 11:55 PM and 01/02/07 12:05 AM? Can you use something like P1.birthdate between P2.birthdate-1 and P2.birthdate+1 ?

What database are you using? I know in Oracle you can specify the time zone by the function new_time. In ORACLE this: select sysdate, new_time(sysdate, 'CDT', 'PST') timezone from dual returns this: SYSDATE TIMEZONE 7/31/2006 3:14:24 PM 7/31/2006 12:14:24 PM and...

I've found this for Oracle SQL, not sure about ANSI SQL: count(employee_name)over ( ORDER BY 100 asc rows unbounded preceding) row_count

Which Cognos product are you using?

One way is to create a drill-through report as your prompt. I've set one up this way so the user selects if they want to run a National report only, Regional report only or both. Each selection drills through to a different report, each with it's own prompt page. The requirement I had with this...

Run your IQD for a couple of days and compare it to the data to comfirm the IQD's are pulling the data correctly. Run the cube, filter down to the same specific days and confirm the counts in the cube match the data from the datasource.

What database are you using?

You can use the LIKE function: select B.* from B, A where B.COL2 LIKE A.COl2

I have a request to make measure descriptions dynamic. I know I can assign query items to descriptions in Dimension Levels, has anybody found a way to do it with Measures? The users want to be able to make a change in a database and have the Measure Explain Descriptions update when the cube...

How are you filtering the selected prompt values? table.column_name in (?promptvalue?)? What is the query source for your section headers? If the section headers are from the same query you are applying your prompt values they should not appear. Are you using any sort of Master-Detail...

Hi, Does anyone know if it's possible to use one of the Excel Fill Effects instead of a color for the background on a chart? The user wants us to find a way to use the Bouquet Texture from Excel as the background when the report and chart are generated. Thanks to all in advance, Bill

U bet!! (Even though I didn't do anything) [upsidedown]

Can you copy your filter syntax from Impromptu and post it? Also, can you copy the generated SQL and post? Bill

Your query needs to return only the summary row. How about something like: Query1 SELECT sum(Kg)/count(Drop) FROM Table

Adding "+ char(13)" returns an error message: QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'. UDA-SQL-0446 Oracle returned an error message. ORA-00936: missing expression UDA-SQL-0450 An unexpected error encountered during the "prepare" operation...

I ran a quick test, it exports to excel ok but NOT to PDF. Bill

Great, this works. Current Week <br> Thank you!!

Thanks for the suggestion. I've tried: <br> '<br>' || <br> || + <br> + '<br>' + + <br> || and several variations, all return an error. I've been unable to pass the html through. They come back with a parsing error.