Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pramsam1

    With Clause with UNIONS - how to enforce indexes

    ...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' ------------------------------------------------- This query takes too long. If I throw in "where...
  2. pramsam1

    Dynamic SQL for Report Studio

    ...table) for the prompt below. Obvioulsy, the following does not work. Is there a way to achieve this in Cognos? What I'm asking is to build a dynamic sql with the user input... select * from Customer where date = '31-jul-2013' and #prompt('customer name:')# like ('A%') Thanks in advance...
  3. pramsam1

    Transformer Cube build with selected dates

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

    Transformer Question

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

    Transformer Question

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

    Transformer Question

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

    oracle datasource in transformer 7.4

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

    oracle datasource in transformer 7.4

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

    How create a chart from a query?

    Great help. Thank you very much.
  10. pramsam1

    How create a chart from a query?

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

    How to restore latest version of dts using dts backup 2000 tool ?

    Tried that. There is not modified date unfortunately.
  12. pramsam1

    How to restore latest version of dts using dts backup 2000 tool ?

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

    How to restore latest version of dts using dts backup 2000 tool ?

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

    How to get Latest Version using DTS Backup 2000 ?

    One last attempt at posting the picture.
  15. pramsam1

    How to get Latest Version using DTS Backup 2000 ?

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

    How to get Latest Version using DTS Backup 2000 ?

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

    Wierd Stored Procedure Issue

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

    Wierd Stored Procedure Issue

    ...is: ---------------- CREATE PROC prSalesByCountry @country char(3), @template_country char(3)="USA" AS SET @template_country=@country SELECT * FROM sales WHERE country=@template_country GO ---------------- I tried this for my query but it did not work. Then I found a similar work around...
  19. pramsam1

    Wierd Stored Procedure Issue

    ...AS [USED], ISNULL(A.[Expiry Date], '1900-01-01') AS [MATURITY], A.[Facility Risk Rating] AS [FRR], A.[OBLIGOR RISK RATING] FROM (SELECT * FROM tbl_FacilitiesExtract_Hist WHERE [As Of Date] = @CurrentDay) A inner join tbl_companies_hist C on a.[customer number] =...
  20. pramsam1

    Wierd Stored Procedure Issue

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

Part and Inventory Search

Back
Top