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

    Join in Impromptu

    Hi, I have a table called deal_fact a and alias of the same deal_fact b.Now i want to achive the following query by joining two tables in impromptu.How should i join them. select count(a.deal_key) from deal_fact a, deal_fact b where (b.time_key (+)=20030629 ) and a.time_key=20030725 and...
  2. gandhids

    Joins

    Hi, I have go two tables...A and B Table A has Investment_id as primary id,while Table has following structure. Deal_id,Property_id,Investment_id,detail_id,month and year.Table A stores the data for current month while table B stores data for all past months.Now in my report, i have to show...
  3. gandhids

    Catalog Joins

    Thanks for your reply... here is the corrected matching....could you please suggest now where i missed.. A=T2 B=T5 C=T4 D=T1 E=T3
  4. gandhids

    Catalog Joins

    Hi nagrajm, Yor suggestion seems to be quite helpful.See, i should have got three missing deals whereas i am getting only one deal when i modify the query as u suggested.here is the query, may be u can have a look over it...what could be the reasons...Please revert. select "c8&quot...
  5. gandhids

    Catalog Joins

    the above problem gets resolved if by any way i could get my query to do as follows D."DEAL_ID"=E."DEAL_ID" and E."BALANCE_MONTH"(+)=03 and E."BALANCE_YEAR"(+)=2003 and When i specify outer join between D and E, still i need to have some arrangement...
  6. gandhids

    Catalog Joins

    Hi, Thanks for your reply.I tried doing the same.But i forgot to tell you one thing.I have two fields called balance_month and balance_year in both the tables A and E.In filter i put the condition as follows A.balance_month =03 nad A.Balance_Year=2003 and E.balance_month =03 nad...
  7. gandhids

    Catalog Joins

    Hi, I have 5 tables A,B,C,D,E A Investment_detail_ID B Investment_detail_ID Investment_id c Investment_id Deal_id D Deal_id E Deal_ID on Joining the A,B,C,D I get some deal_ids.Now if I have to find out which ids of these result set are not there in table...
  8. gandhids

    Stored Proceudre Report

    Hi, I have 5 tables A,B,C,D,E A Investment_detail_ID B Investment_detail_ID Investment_id c Investment_id Deal_id D Deal_id E Deal_ID on Joining the A,B,C,D I get some deal_ids.Now if I have to find out which ids of these result set are not there in table of e, how can join...
  9. gandhids

    Stored Proceudre Report

    Hi when i did as u said. i am getting following error. Error number -9: DMS-E-GENERAL, A general exception has occurred during operation 'execute'. ORA-06550: line 1, column 7: PLS-00201: identifier 'Pk_TEST.PR_GET_DTS_PORTFOLIO' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement...
  10. gandhids

    Stored Proceudre Report

    In Impromptu stored procedure report, how do i specify the out paramater.If i don't specify the out parameter, it gives me the error. call ORION_ODS_BALANCES_CONTROL_NEW(?p_in_time_key? IN , ?p_in_portfolio_key? IN ,???????) I am using type-in prompts for IN parameter, but how do i write OUT...
  11. gandhids

    Stored Proceudre Report

    Hi This is my procedure PROCEDURE ORION_ODS_BALANCES_CONTROL_NEW (p_in_time_key IN Number, p_in_portfolio_key IN Number, cnt OUT NUMBER ) IS p_out_err varchar2(200); BEGIN SELECT COUNT(d.investment_key ) INTO cnt FROM cre_portfolio_dim a, portfolio_investment_fact c...
  12. gandhids

    Stored Proceudre Report

    When i do the same, i get following error. Error number -9: DMS-E-GENERAL, A general exception has occurred during operation 'execute'. ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'ORION_ODS_BALANCES_CONTROL_NEW' ORA-06550: line 1, column 7: PL/SQL...
  13. gandhids

    Stored Proceudre Report

    Hi, I have to prepare a few stored procedure reports.Could you please tell me that for making the catalog, i will fetch the metadata of all tables that will be used.Do i need to perform the join between them as anyway i am using the stored procedures. Please revert. And do i need to inclued...
  14. gandhids

    Catalog Problem

    Hi, Thanks for the reply... But i have already tried both the options.May main concern was,when i click on retrieve tables(having selected tables and view), it is taking too long to retrieve metadata and so i am not able to find whether that view has been retrieved or not.Unless i do that, my...
  15. gandhids

    Catalog Problem

    Hi, I have a catalog with some tables and a database view.The catalog and all the reports associated with it are working fine.But when i send it to somebody be mail, and the guy at other end tries to open the report,it says view or table not found.The report is unable to find data item from...
  16. gandhids

    Impadmin.exe error

    Hi, I have an .imr report.There are four sub reports in it.Of which, Two are bar graphs.The report runs fine.But When i customise the colours of bars in these graphs,the reports doesn't run for all values of each prompt.For some values, when started running, it shows error saying'Impadmin.exe...

Part and Inventory Search

Back
Top