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!

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

Recent content by pramsam1

  1. pramsam1

    With Clause with UNIONS - how to enforce indexes

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

    Dynamic SQL for Report Studio

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

Part and Inventory Search

Back
Top