Search results for query: *

Hi, I'm new to Oracle, so excuse me if I'm asking an obviuos question.. Basically I have a need to execute a loop concurrently (i.e. execute all of the outcomes of the loop in one go). I can do this easily from unix (just execute as a background process), but am struggling to find a way of...

Cheers guys, thanks for the suggestions. Due to the fact that I want to paramiterise the field in question as part of a batch process and the data files are huge so don't want to increase storage requirements I've gone with: OPTIONS (SILENT=(HEADER, FEEDBACK), DIRECT=FALSE, SKIP=1) LOAD DATA...

Hi, I'm brand new to Oracle and am very much learning the ropes, so please go easy on me. We're currently loading a table from a csv using a control file like this: OPTIONS (SILENT=(HEADER, FEEDBACK), DIRECT=FALSE, SKIP=1) LOAD DATA CHARACTERSET US7ASCII INFILE 'TEST.CSV' TRUNCATE INTO TABLE...

Thanks PHV, works like a dream... Have a star

Hi, I'm a bit rusty with my shell scripting and have a need to create a script to do the following: Search a file for lines beginning with this string: SITE_LIST_STR_PARM Then for this line extract each of the numbers following it and put them in a new file each on a different line. The numbers...

Hmmm, sounds interesting.... Any ideas how I'd go about that?

Hi, I've had a request to disable the Export to excel (both under run options and the link in the header) for some Report Studio reports (8.4), is this possible? I've been told by our gatekeeper that the only way he knows to do it is to disable it over the entire application for every user...

We've only ever managed to achieve this by building this kind of 'prompt page' as a standard report page, then using the radio button to show a drill through link depending on the option selected. the user then has to perform the extra step of clicking on the drill through link. Hope this...

Maybe use the paramweter values to create sections then apply page breaks to these.. Should work

Hi, my users are currently operating version 8.3 utilising pre-canned Report Studio and Query Studio reports. However, they've raised an issue wherebye the default file names that COGNOS gives to excel exports are too long (causes some kind of error with pivot tables). I realise that there's a...

First of all please excuse the rather cryptic title to this thread... I'm building a prompt page on a standard COGNOS Page (i.e. not a prompt page). The reason for this is that the user needs to be able to choose between 6 different reports, each with there own set of prompts, so I've got show...

Have sorted this using #prompt()# macro in a parameter map to read the table name extension from the drop down.. Works like a dream...

Hi.. I've been trying to build a dynamic Select & search prompt in Report Studio but seem to be failing miserably so was wondering if anyone could help... Here's the scenario: - User is searching from a customer from a list, there are 11 different types of customer name they will want to...

Cheers, mate... The rollup function mentioned with Grouping sets seems to be doing the kind of thing I'm after so gonna take a closer look at it.. Thanks,

Hi, I've an interesting SQL problem that's quite tricky to explain.... Here's goes: I've an aggregate query that aggregates by each combination of the dimensions that have been selected, here's my SQL: select DGOG.REGION_CDE, DGOG.CTRY_CDE, DFAC.BASE_ENTITY, DCPA.CUST_SUST_RTNG...

Hi we recently updated to COGNOS 8.3 from 8.3, which has been great. However, we've been experiencing problems with prompt pages for new packages (i.e. that have been fully developed in 8.3) that we launch onto a production server. The issue is, that users who are not in a certain group (which...

Cheers Preachie, problem solved... Have a star

Thanks for the link preachie.... Seems to work like a dream, but have been told I'm not allowed to use any java script because it may not be forwards/backwards compatible. Thanks anyway...

Hi, Whenever I create a Multi select list box in report studio (8.3) I get a 'Select All' link at the bottom of this box as default. Is there a way of removing this? It causes problems when the user tries to run a report with this option as there are too many parameters being passed to the...

Hmmm... It's a monthly task and I'll be removing the previous months log files when a new month batch takes effect.. The archive directory doesn't have to be in the log directory, I've just been playing around trying to get it to work from here.. Also the version of Unix i'm on doesn't support...