Recent content by gandhids

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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