Search results for query: *

Hello, I have a query as follows. ------------------------------------------------ with base as ( select date, cust_id, amount from multiple tables union all select date, cust_id, amount from multiple tables ) select * from base where snapshot_date = '31-jul-2014'...

Hello, I was wondering if this at all possible to do. I am creating a cognos report using native sql. I would like to be able to have the user select the column during the run time to build the sql. For example, the user will type in customer_name (a field in customer table) for the prompt...

I have to build a cube to show metric for the current date, month before, 3 month before, 6 month before and 12 month before and the difference between current date and month before and so on. How can I set up the date dimension so that the data refresh in the future will keep giving me the...

Hello: I am very new to cognos. I am trying to do the following: 1. Use iqd file to retrieve data from an oracle database. This gives me most of the data I need for analysis. For example, I get the following columns from this query: Month_End_Date, Region and Sales. 2. However the data...

I am trying to create a model in Transformer 7.4 and would like to use Oracle as the data srouce. When the wizard prompts for the data source, I do not see Oracle as one of the data source types. Only the following source data type is available: Impromptu Query Definition Delimited-field text...

I am very new to this. Using Report Studio. Database is Oracle 9. I am trying to create a chart from the results out of a query on oracle. I have dragged and dropped query items into the chart as guided in the user guide. But when I run the report, my chart is empty. Do you have to do anything...

I have been backing up my dts packages using dts backup 2000. Unfortunately, I am having to restore some of the packages for the first time today due to the hard disk failure on my server. When I tried to restore the pacakges, I discovered that the dts backup 2000 tool actually backs up multiple...

I have been backing up my dts packages using dts backup 2000. Unfortunately, I am having to restore some of the packages for the first time today due to the hard disk failure on my server. When I tried to restore the pacakges, I discovered that the dts backup 2000 tool actually backs up multiple...

I have a simple stored procedure. ----------------------------------------------- SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE PROCEDURE sp_stproc1 @CurrentDay AS smalldatetime, @WhatDay AS smalldatetime AS Just one select statment GO SET QUOTED_IDENTIFIER OFF GO SET...

Hello: I need to access SQL server data via database query from Excel. I would like to use some values in a cell (eg. a date) in the excel file. Can I write a query and pass the data in a cell in Excel as a parameter to the query ? Much appreciated.

Hi All: I am new to SQL server. I have got the SQL Server 2000 debugger working for Stored procedures but when I right click on a User Defined Function from the Object Browser in the SQL Query Analyzer, the "Debug" is disabled. Does this mean functions cannot be debugged in SQL server 2000 ...

I have just completed self training with Cognos CDs for Reportnet. Is the Cognos training worth doing after taking the self training with the CDs ? Anyone done both ?

Anyone been to one of those Cognos Traing for Reportnet 1.1 ? Is it worth it ?

Hello: I was wondering if the ReportNet 1.1 can use PowerPlay Cubes through metadata layer. Or is this feature only available in Cognos 8 ? Thanks in advance... //SS