Search results for query: *

I am passing a value based on a value retrieve from another cursor. The cursor where the value is passed to always retrieves the same number of rows, basically it just returns the value from just one variable. For example, cursor cur_prog always displays the first value returned from cursor...

Before I attempt to write a program for this, has anyone ever tried to keep a running balance on a query, and at the same, change the balance fields, for instance: INPUT DATA: NAME AMT ID JOE 125.00 1 JOE 125.00 2 JOE 200.00 A JOE 100.00 B...

I have a field that I though was Null or empty, but I do not seem to be able to get a return from my table. So far I tried: Len(Trim(Nz(myfield,"")&"")) > 0 Nz(Table1.Field1,'')=''; NZ([fieldname],0) I assume the field has to be either NULL or empty, but why do I not get any returns from...

Converting a number to string using Cstr, but everything is left justified. How can I make my converted text right justified? Have not found a way yet, Thanks, in advance,

I know that the 'Reset Dimension' button only takes away your filters, is there a known way to reset the cube all the way back to the default view? So it takes away all the replaced rows/columns and all you have left are the first 2 dimensions (which is my default view)? Thx.

Using PowerPlay, and when looking at the Properties of the Signons, I uncheck the 'Prompt for Password' box, save then close. But when open again, the check is back in the box, causes me to put in my password each time I generate a cube. I did not have this problem using a 9i database, but now...

Can you see the script or macro that runs in the background when building or updating a cube or model? Just trying to get an idea for what is happening in the background during a build. thanks,

I have a macro that I would like to run in Scheduler. I am using the CognosScript Editor to create the macro. But cannot get it to run. Any idea why it will not run? It compiles with no errors. Even when I execute the macro in the CognosScript Editor, nothing happens. Any ideas? Thanks in...

Doing a describe on a table defined as such: desc table_num Name Null? Type -------------- -------- ---------------------------- NUMBER1 NUMBER(10,2) NUMBERON2 NUMBER(10,2) I get this when I select data: Select * from table_num; NUMBER1...

I have a field defined in a table as varchar2(8), and it's being used as a date field in my report, as a dimension. In Impromptu, it's being converted as such: number-to-date(string-to-number(fieldA)) So, in the table, unfortunately, some of the values are null. So in the PowerPlay Cube...

Question, when I do a SEARCH ALL, I pass a file which I load into and internal table, it's 35,000 rows, I am looking for a match in this table with an input file, I get no matches. Now, when I take the same exact input file, except delete the last 15K rows, so now my internal table is 20K rows...

Is there a way that a user, non-admin or DBA priveleges can check a session to see what query is running? I am already checking the V$SESSION for SID, SERIAL#, USER, BLOCK_GETS, CONSISTENT_GETS, PHYSICAL_READS, ...), but is there a way to trace/find the query that is running? Thanks,

Situation, have 1 table call it table 1, with 2 indexes, 22mil rows. Have another table, table 2 exactly the same fields as table 1,except has a new column, and only half the data (11mil rows). 6 indexes (2 the same from table 1, and 4 new indexes). Bottom line, I need to make table 1 look...

When I do a drill-through from the PowerPlay cube, it opens up Impromptu, which I assume sends the query to the database I am connected to. Scenario: I have a dimension named 'Pay Year', and a measure named 'Total Charges' When I for instance choose 1983 for my 'Pay Year', and 'Total...

Could not find anything on my particular problem during a search. Have a problem during a SEARCH ALL on a mainframe. Want to do something like this: SEARCH ALL WS-TBL AT END SET WS-NOT-FND-ON-LIST TO TRUE WHEN WS-TABLE-NUM(WS-INDX) EQUAL WS-CHECK-NUM AND...

New to COGNOS, wonderful too, but at a standstill. When I check the scope of the dimensions they are properly highlighted when I choose the Data Sources. Warning: (TR2718) Dimension 'Num' has no measures associated with it. During PowerCube generation, no data source will be able to provide...

When I run this query, I get the result that I need. Select PHONE, COUNT(DISTINCT(NAME)) from TABLE where PHONE = '1234567879' group PHONE Having COUNT(DISTINCT(NAME)) > 1 PHONE COUNT(DISTINCT(NAME)) -------------------- --------------------------- 123456789...

Going through the Cognos, I read how to use the scheduler to kick off a new cube monthly, but I want to keep a back up of the old cube. Is there a way to backup the cube that is there first before building the new cube and I lost the last data? I could not find anything other than building or...

Importing data into Excel, I do not have the source code where the data comes from. The data look like this: 0011122588523400000000000000B1111 When it's imported into Excel, and I create the line breaks, the data looks like this. $11,225,885,234.00 B 1111 But it should look like this...

Would like to spool to a file directory, that has a space in the directory name. Without changing the directory name, is there any way around this? SQL> spool C:\Stuff Finance\Financial Data SP2-0333: Illegal spool file name: "T:\shr_data\Financial Data folder\VCIS Info" (bad character: ' ')