Depending on the complexity of the actual query and the volume of data in the tables, you could achieve the desired result with multiple queries.
SAP Business One customers with a valid maintenance contract benefit from: 24x7 support for critical issues, single access point for support tasks via the support launchpad for SAP Business One.
SAP Business One is the entry-level and most affordable ERP application within SAP's portfolio of solutions and has proven successful for small businesses and subsidiaries of large organizations.BO analysis - Analysis addition for olap (Analysis Workspace) based on BW Bex Query and hana olap Connections, BO Analysis MS-Excel, MS-Powerpoint Reporting based on BW Bex Query and hana.BO explorer - Creating Information Space Exploring the data based on UNX universes, hana Analytical Views.In the report, merge the two queries.The SQL to do what you want would be: select lumn1, lumn2 sum(asure) from table_A left outer join table_B ON table_ AND [email protected] we have another option igi unlimited edition setup for you.
Also, please see the SAP BusinessObjects BI Platform Product Availability Matrix for the latest information on updates and releases.
Latest Tools in.0 like upgrade manager Tool, Report Conversion Tool, LCM and SAP BI Visual Intelligence.SAP Business Objects.0 - Instructor Led video Training - ZaranTech ».You may have to create new variables for column1 and column2 as attributes of the respective ID object, but when done the result should be what you want.If this is a one-off need, you could just modify the SQL in the report, but that's not a durable solution.System Requirement, details, minimum server hardware requirements, refer to the SAP BI 4 Sizing Guide for more information.