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 bkrike 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 mohammedhajat

  1. mohammedhajat

    Decode function from Oracle to cognos

    COALESCE(NULLIF(totalcost,0) ,NULLIF(submitcost,0) ,NULLIF(apprvalue,0) ,NULLIF(defestvalue,0) ,0) "Cost" niceone,. thanks
  2. mohammedhajat

    Decode function from Oracle to cognos

    I have a decode sql from oracle, which i need to translate into a measeure into Cognos, it's fairly complex for an amatuer like me.. I know the equivalent is the Case function, but I cant seen to write the case equivalent of the decode, could anyone please assist? Code...
  3. mohammedhajat

    performing calculation on two query sets

    no data is being produced, i have joined Query 1 and 2 to Query 3, and defined a relationship based on the description of the order, as both description are identical on both 1 & 2, so i defined a 1 to 1 relationship. but when querying Query 3 with : Query1.orders/query2.orders This is where...
  4. mohammedhajat

    performing calculation on two query sets

    Hi, I am very new to cognos and having a bit of trouble with a calculation i am trying to perform. I have two list tables, both with their own query sets, Query 1 & Query 2. both list tab 1 & 2 have No of orders, on it. list tab 1 is ALL orders, list tab 2 has all orders filtered by a certain...
See more

Part and Inventory Search

Back
Top