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

I am a little bit confused here regarding Unique checkbox. If there are multiple attributes (in above example there are just two - date and region, but there can be more) on which to join two data sources, do we make each of those attributes unique? I wonder why Cognos does not allow the joins...

Unfortunately, I am not able to load xls file into Oracle as I am just a business user as far as Oracle DB is concerned. I read up somewhere that Transformer does the join automatically on the two data sources based on the attribute names and their data types, but I may be wrong...

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

Very helpful. Thank you very much and have a great long weekend...

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

Great help. Thank you very much.

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

Tried that. There is not modified date unfortunately.

Thanks but that did not work. The enterprise manager opened up an older version. Is there a way to figure out the latest version by looking at the version id ? I am ready to go through the pain if Version ID can help me with this.

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

One last attempt at posting the picture.

Not allowed to open box.net for attachment from my work pc.. But I guess you get the idea without the screenshot.

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

George: With just above code change for the exchange rate, the time reduced from 4min 18sec to 2min 29sec. Thanks.

George: Thanks a lot. I will follow your advice on optimizing the query but now I have been able to have the query run from stored proc in about the same time as select statement from SQL query analyzer. You were right all along. It is parameter sniffing issue. Here's how it finally worked...

Unfortunately, even after writing code to get around parameter sniffing this still is not working. Here's the stored proc. Any help would be much appreciated. ------------------------------------------------------ SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO ALTER PROCEDURE...

George: Sorry, I actually did not notice the link in your earlier post. I am going to try this and will post how it went. Thanks in advance..