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...

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...

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...

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...

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...

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...

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...

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...

Hi, Been searching the forum, but can't seem to find the right answer i'm looking ofr... Basically I need to remove all the log files from a folder, compress them and move them to another folder.. I've come up with this: gzip -r $LOG_PATH_STR_PARM cp $LOG_PATH_STR_PARM/*.gz...

HI, I'm trying to pass parameters from a shell script to an SQL file. Here's my shell script: for TAB_NAME in INX_CDM_DREPORT_DATES INX_CDM_PDBAND do echo "Selecting from table $TAB_NAME" db2 -tvf /gcdm/dev/scripts/ControlMScripts/dailyMI/andytemp/sample.sql $TAB_NAME done And here's the SQL...

Hi, this is my first proper thread in the COGNOS forum, so hello everybody... I've got an issue with ranking and i'm not sure if it's achievable in report studio. Basically i have a report with 5 or 6 prompts (3 of these prompts are for choosing dates which will become relevant later). The...

Hi, I'm new to the cognos forum and have a pretty general question. Basically I've not used Cognos before but have an interview as a cognos developer (they are providing training and I've used Business Objects which i understand is similar) and was wondering if anyone could provide some basic...

Bit of a general question this: We've been having some network access issues recently and a lot of our end users have been losing there work (i.e. working on Excel or Word, the network goes down so they're unable to save the work before hometime or lose everything they are working on).. I've...

Hi, I want to run some code that will remove all named ranges except the print area from an excel spreadsheet. So far I have this: Dim nm As Name On Error Resume Next For Each nm In ActiveWorkbook.Names If ActiveWorkbook.Name = "Print_Area" Then Resume Next...

Hi, I run some scheduled tasks on my PC using excel/word and vba, that occasionally throw up an error. In order to enable the other scheduled tasks to run I get the error handler to quit the application in the event of these errors. The problem is that I need to start logging these errors and...

Hi, I run some business objects reports using my PC's sceduled tasks. These reports refresh overnight and dump into a text file for other users. The problem is that one of the reports has been returning a partial result for the past 3 months and we've only just spotted it. Because I run...

I've got some linked tables in an access database. When I first linked the tables I clicked the save password button to save people having to type it in every time. Trouble is, that this is no longer acceptable from a security point of view and i need to remove the password. I've had a look...

Hi, I've written a query that I need to distribute the results of in a text file with no tabs. My current process is to run the query, copy and past it into anotepad and then remove all of the Tabs. Trouble is I now have over 3000 lines of data and I don't want to manually remove all of the...