Incompatible Objects Error In Webi
Contents |
and SafetyAsset NetworkAsset Operations and datasync error in business objects MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel webi merge dimensions incompatible object CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial extended merged dimension in webi Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote
Forced Merge In Bo
to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovern
+ Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23, FLBOUG, Clearwater: Oct 28, ASUG Northern California: Nov 2, ASUG Arizona Chapter: Nov 3, ASUG
#context Error In Webi
All Texas Chapter Meeting: Nov 11. # Incompatible error in compatible and incompatible objects in business objects WebI Report Search this topic...|Search WebIntelligence XI...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) business objects merge variables Unanswered Posts Register or Login to Post Forum Index -> Building Reports -> WebIntelligence XI Author Message raj_sree216Forum MemberJoined: 25 Aug 2006Posts: 6 Posted: Tue Jul 31, 2007 https://archive.sap.com/discussions/thread/3288201 1:12 amPost subject: # Incompatible error in WebI Report Hello BO Gurus, I have created a report in WebI XI and #INCOMAPTIBLE is displaying in all the fields in the report. There is only one data provider. How can I identify Incompatible objects. Is it to be fixed at universe level or in WebI. Can any one please tell me how to http://www.forumtopics.com/busobj/viewtopic.php?t=89776&sid=ed2d0c5f5b7fbf129236f586c552e3a2 fix it. Thanks in Advance Sree Raj Back to top AstroPrincipal MemberJoined: 15 Feb 2007Posts: 316Location: Bs As, Argentina Posted: Tue Jul 31, 2007 10:11 amPost subject: Re: # Incompatible error in WebI Report Check for multiple queries in that provider, maybe something is happening there._________________-Astro- Back to top sujit_patangePrincipal MemberJoined: 19 Jul 2005Posts: 346Location: NJ, USA Posted: Tue Jul 31, 2007 10:27 amPost subject: Re: # Incompatible error in WebI Report Raj, this could be synchronized SQLs within single DP. Click on View SQL and find whether you have more than one SQL? This could happen if you are having objects from tables from more than one CONTEXTs. Sujit Back to top raj_sree216Forum MemberJoined: 25 Aug 2006Posts: 6 Posted: Tue Jul 31, 2007 1:18 pmPost subject: Re: # Incompatible error in WebI Report Hi Sujit, You are correct. I have 2 SQL queries and exectued these queries seperately. 1st query is giving result set and 2nd query is not. could you please let me know how can I fix it. Is it to be fixed in universe or WebI. Thanks i
merged dimensions and the measures. If you want to use dimensions from other query and you can't merge them, http://boostips.blogspot.com/2013/02/businessobjects-merged-dimension.html you got an error message "Cannot drop here - the http://stackoverflow.com/questions/25178791/analysing-objects-that-belong-to-different-fact-tables-different-contexts object is incompatible". See pic below. To avoid this problem you have to create a detail variable object and associated it to the merged dimension. In the example above you want to use the phone numbers from Query2. Select the type as business objects "detail" and associated object. Now you can use this variable with your Query1 dimensions. To understand why this works with detail please refer to this document: http://michaelwelter.wordpress.com/2011/04/18/tips-for-merging-dimensions/ Tweet Posted by modü at 1:48 AM Labels: BI4, businessobjects, dimension, incompatible, merge, web intelligence, webi No comments: Post a Comment Newer Post Older Post in business objects Home Subscribe to: Post Comments (Atom) Search This Blog Loading... Labels businessobjects BI4 oracle web intelligence webi universe 2008 XI 3.1 backup internet explorer 9 merge olap password prompt query sql xcelsius 1930605 2010 ADAPT01590478 BI41 CLSID IDT Information design tool SQL Server SQL Server 2005 SQL Server 2008 SQL Server Database Engine Troubleshooting SQL Server adapt01710199 administrator architecture mismatch biar calendar column connecting connecting to SQL Server connection current date decrease diagnostic difference dimension freeze hint ie9 incompatible inconsistency increase infoview insert keycode lag lead long modify mode no data non-numeric numeric odbc office order report repository reset row sum time timestamp timezone transpose troubleshooting update username view mode workspace Blog Archive ► 2016 (1) ► February (1) ► 2014 (1) ► March (1) ▼ 2013 (8) ► November (2) ► August (1) ► May (1) ► March (1) ▼ February (3) BusinessObjects-Infoview freezes when click on "Do... BusinessObjects-Merged Dimension Incompatible Obje... BuisnessObjects-Order Prompt
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Analysing objects that belong to different fact tables (different contexts) up vote 0 down vote favorite My universe has gotten bigger; there are now 8 fact tables and around 20 dimensions. Because I have 8 fact tables, I defined 8 contexts. My assumption is that it is only possible to take objects that belong to a speciic context in order to analyse exactly those objects in one report. Conversely, that should mean, that it is not possible to take objects that belong to different fact tables (different contexts), and analyse them in one report (by one report I refer to one table). Is my assumption correct? business-objects share|improve this question edited Aug 7 '14 at 11:36 Kristof 3,27231132 asked Aug 7 '14 at 9:23 Adam 54921537 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote First some terminology; it might sound like nitpicking, but it avoids confusion: Document — A single Web Intelligence document which can consist of multiple reports and data providers Data provider — A collection of universe objects (dimensions, measures, details, …). This may result in one or more SQL statements when defined on a relational source. Report — Represented as a tab (at the bottom) within a Web Intelligence document (comparable to a Excel worksheet vs Excel Workbook). A report can contain data from any and all data providers defined in the same document. You can specify in the parameters of your data foundation whether or not to allow the selection of multiple contexts in the same data provider. If you allow this, selecting from multiple contexts in the same data provider will result in (at least) 1 SQL statement for each of those contexts. If you do not allow selection of objects from multiple contexts, you will receive an error message stating Incompatible objects when you try to refresh a data provider that v