Recent content by debdas

Hi Experts, I am familiar with SAP BW. I have heard that some companies use SAP BW and have report net of Cognos. My question is: If your company has already SAP R/3 and SAP BW , why should you buy/use something as Cognos report Net.? So in other words what benifits do you gain? Or are there...

I am familiar with SAP BW. I have heard that some companies use SAP BW and have report net of Cognos. My question is: If your company has already SAP R/3 and SAP BW , why should you buy/use something as Cognos report Net.? So in other words what benifits do you gain? Or are there not any...

Thanks for your tips, its now working well

Hi experts, Whilst trying to run a Cognos Impromptu report we are encounterering a Query Server Error. DMS-GENERAL, A general exception has occurred during operation 'asynchronous open' What does this error means ?? and how to resolve it ? Kindly help

Thanks Dave Griffin D Das

Hi Experts, I have two tables one "Sales Table - SALES_TABLE01" and another "Inventory Table - INVENTORY_TABLE02" now I want to merge two tables, Logic is to add sales & margin item-wise & month-wise and extract last transaction itemwise & month-wise from Inventory table...

Hi, Can you also tell me where did you get AS service pak 3. Can you please give me the full URL. I am a new user. Can you tell me is it possible to do left/outer etc joins on MSOLAP. If yes, please tell me how ?

HI Experts, How you do left/right joins etc on MSOLAP Thks in advance

Hi Experts, I am a new user on MSOLAP . I want to know how you do joins as left/outer, right, cross etc. Thks in advance

Thanks to all, it was a silly mistake. The mistake was on call statement 'T1' program was written in lower case. Thanks once again for your kind reply Debabrata das

I am sorry to give single quotes, pl include that. I think I am doing mistake while compilation as I have not included T1 program while CRTSQLRPGI or any other mistake ... Pl point me out ...

I have one CL program named : T1 and another on SQLRPGLE : S1 and I am calling T1 program from S1 sample program C CALL T1 C ....... C/EXEC SQL C DELETE ..... C/END-SQL C SETON LR I have compiled T1 with option 14 and seperatly it is running and I have...

Even though I put decimals on FORMAT. It is still showing zeros. Can you please check at your end with Ms-Access DB for small sample of data where one field data type is numeric, precision 18 and scale: 3 and let me know... Thks in advance

Thanks dear for yr kind suggestions, it worked

Yes, I can compile it, if I give DSPLY statement before and after SQL it displays on the screen, but not executing SQL statement