Incompatible Object Error Business Objects
Contents |
Default Formatting In WebIntelligence → Tips for MergingDimensions April 18, 2011 81 Comments I've noticed lately that there seems to be a lot of confusion about merging dimensions in Web Intelligence. I've spent a fair amount of time on BOB answering questions about this datasync error in business objects topic. So, perhaps it's time to put together a comprehensive document covering this topic. incompatible objects in business objects universe After all, merging dimensions is one of the most powerful features of Web Intelligence. Tip 1: Adding “Incompatible” dimensions to the block business objects merge dimensions Have you ever noticed that, sometimes when you try to add a dimension to a block that includes merged dimensions, you sometimes get an "Incompatible object" error? Let me explain why this happens, and then we'll extended merged dimension in webi look at ideas on how to fix it. Dimension objects and Detail objects have a fundamental difference: Dimension objects usually represent a different level of granularity. For example, State and City might be two dimension objects in your universe. City is a lower level of granularity than State. So, when you add City to an existing block that already includes State, the measure objects will be aggregated at a lower level of granularity.
Business Objects Merge Variables
Detail objects, on the other hand, typically do not represent a lower level of granularity when used with their related dimension. For example, if I have Sales Revenue broken down by Customer in a block, and then add the Eye Color detail object, Sales Revenue will not be aggregated at a lower level. It will stay at the level of Customer. This is how detail objects work. So, if I have two queries merged on State, and try to display another dimension, that is not merged, such as State Capitol, Web Intelligence doesn't know how to aggregate the measures at the lower level of State Capitol, since that dimension doesn't exist as a merged dimension. Of course, you and I both know that each State only has one State Capitol, so it's not really a lower level of granularity. But Web Intelligence doesn't know that. So we have to tell it. The way we tell is as follows: Create a detail variable. In this case, maybe we call it Capitol. Make it a detail of the State merged dimension. The formula for this variable is: =[State Capitol] We can then add the variable to the block, as Web Intelligence sees it as a detail of State, rather than a different level of granularity. Note that the
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java
Webi Forcemerge()
Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management business objects merged dimensions variable SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back kba: 1203620 CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael https://michaelwelter.wordpress.com/2011/04/18/tips-for-merging-dimensions/ Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre bracke Locutus Dennis Stevenson Craig Borysowich Richard DukeGanote mircea_luca iudithm Clinton Jones Nikki Klein AbhaiTripathi Iqbalyk bluesguyAZ59 blrvenkat jakarman COMPANIES GeoTrust Juniper Networks HP, Voltage Security and ... Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Business Intelligence http://businessintelligence.ittoolbox.com/groups/technical-functional/businessobjects-reportinganalysis-l/webi-cannot-drop-here-incompatible-object-error-4698434 Groups Ask a New Question Business Objects Reporting & Analysis For discussion on Business Objects Reporting & Analysis , please visit the Business Objects group. More Business Intelligence Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Webi 'Cannot Drop Here Incompatible Object' Error ShruthiV asked Mar 19, 2012 | Replies (5) I am trying to run a WebI report out of a single qu
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio http://businessintelligence.ittoolbox.com/groups/technical-functional/businessobjects-dev-l/incompatiable-object-error-in-webi-report-4103505 Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and https://communities.bmc.com/thread/116051?start=0&tstart=0 Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre bracke Locutus Dennis Stevenson Craig Borysowich Richard DukeGanote mircea_luca iudithm Clinton Jones business objects Nikki Klein AbhaiTripathi Iqbalyk bluesguyAZ59 blrvenkat jakarman COMPANIES GeoTrust Juniper Networks HP, Voltage Security and ... Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Business Intelligence Groups Ask a New Question Business Objects The Business Objects group is a forum where peers share technical expertise, solve problems, and discuss issues related to business objects merge Business Objects. Home | Invite Peers | More Business Intelligence Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Incompatiable Object error in WEBI report Stephen Raj asked Mar 21, 2011 | Replies (4) Hi, I am just using one universe in BO XIR3.1 to generate one WEBI report(WEBI Rich Client). I am just puling some objects in query panel and trying to run the report, but It is not running and giving following error message. com.businessobjects.rebean. wi.ServerException: A filter is defined on an object that is incompatible with the obj
AdvocacyBeta ProgramsSupport CommunityIdeas and RFEsAdvocate HubOne BMC Beta Process (BMC)Customer Experience (BMC)HelpCommunities TipsCommunities YouTubeBMC Social Central (BMC Only)CommunitiesFree TrialsLog inRegisterCommunities Free TrialsSupportDocumentationAbout BMCNewsLog inRegister Products Events BMC Engage CommunityAgenda & RegistrationDevelopersDeveloper CommunityDeveloper PortalPartners Partner DirectoriesTechnology Alliance Program (TAP)Solution Provider Portal (SPP)User Groups All groupsLocal User GroupsEvent CalendarCustomer ProgramsBeta ProgramsSupport CommunityIdeas and RFEsAdvocate HubOne BMC Beta Process (BMC)Customer Experience (BMC)Help Communities TipsCommunities YouTubeBMC Social Central (BMC Only)Search the BMC CommunitiesSearch the BMC CommunitiesCancelError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in BSM Dashboards and Analytics All PlacesProductsAtriumBSM Dashboards and Analytics 3 Replies Latest reply on Sep 30, 2014 3:49 AM by Abhay Bagalkoti The query cannot run, because it contains incompatible objects. See your Business Objects administrator. (Error: WIS 00008) Hetal Joshi Sep 29, 2014 10:33 PM Hi ,I am using BMC Analytics. I have imported ITSM universe and using Universe Designer I am trying to insert a join between HPD_HELP_DESK_ASSIGNMENT_LOG and HPD_WORK_LOG tables.I saved and exported universe after that.Parameters are set for Context, measures and operand tick boxes.I am getting error:The query cannot run, because it contains incompatible objects. See your Business Objects administrator. (Error: WIS 00008) when I run the queryPlease share your suggestions.Thanks, I have the same question Show 0 Likes(0) 1832Views Categories: Applications, Best Practices, Developer Guides, Podcasts and Videos, Analytics, Dashboards, Articles, Datasheets, Reports, Solution Briefs, White Papers Tags: none (add) analyticsContent tagged with analytics, forContent tagged with for, incident-managementContent tagged with incident-management This con