Search results for query: *

We've found that there are issues...specifically with the max connections parameter in windows registry...i'm surprised nobody else has.

Anyone using this combo? Any performance issues as compared to IE6?

Very easy... Using the catalog...bring 1 col into a report and let it run...then go to the profile tab and click the SQL radio button. Click edit and then you can freelance SQL. Been doing this since version 4.0! al

My biggest question, is what's better...multi-core CPU or multi CPU? In terms of running Cognos?

or... CREATE OR REPLACE function weekenddays(startrange in date, endrange in date) return number as weekenddays number; BEGIN SELECT (trunc((trunc(endrange+1) - trunc(startrange))/7) * 2)+ decode(decode((trunc(startrange) - trunc(startrange,'DAY')), 0, decode(mod((trunc(endrange+1) -...

Elaborate on the problem. I've done this for years with no issues. Would look like this: CP.CAL_PD_DATE BETWEEN ?PD1? AND ?PD2? Just use the insert prompt option in the query window. -al

Here's one way of doing it. SELECT SUM(days) "Total Working Days" FROM (SELECT ((TO_DATE('11-APR-07') + TRUNC((TO_DATE('13-APR-07') - TO_DATE('11-APR-07') + 1)/7)*7 - 1) - TO_DATE('11-APR-07') + 1)*5/7 days FROM DUAL UNION ALL SELECT CASE...

For an organization with 1000 named users, what would be a good UNIX setup to run Cognos 8.3 using a Oracle 10g DB. Would (2) SunFire T2000's with 8core CPU and 16GB to the job? Thanks

I suggest you revert back to Impromptu.

If you store a value of '_ALL' in the reference table used by the prompt, you can do something like we use here. (1=if('_ALL' in (?PROMPT?))then(1) else if (COL in(?PROMPT?))then(1) else (0)) Using a space before ALL in the table will force it to appear first in the prompt list. We've found...

Hello Everyone, Just like to take a poll of people currently using ReportNet: 1.) Do you like it? 2.) Prefer it over Impromptu? 3.) What shortcomings have you noticed? Greatly Appreciated! al