Display any measures coming from any query; 3. One more interesting point that I have noticed is when I bring in ID, Name, Amount1, Service_Date,Service_Code from query1 and Amount2 from query2 in one block it works fine but when You need to ha... Query 1 Query 2 Now if you try to use all these objects in same block , you will get data sync error.(As webi will not be able to find any
Thanks, Kon Back to top anair_boPrincipal MemberJoined: 05 Dec 2006Posts: 255Location: Philly, PA Posted: Fri Mar 14, 2008 3:59 pmPost subject: Re: Merge Dimensions - #DATASYNC Facing the same issue.Any resolutions There are a few options to address this: Use measure objects that are named "SUM", if they exist - e.g., SUM Actual Month (BAL) rather than Actual Month (BAL) in the now I got the clarity of Merge Dimensions..Pretty explanation.Keep poting more...ReplyDeleteAnonymous5 March 2013 at 15:14Crystal clear!! Within the Format Table box under General, check the box "Avoid duplicate rows aggregation". http://scn.sap.com/thread/3250192
How to easily fix Datasync Error In Business Objects error? However, when I try to create a block with those objects, #DATASYNC is displayed in every column. Check the SQL tab in Parameters under Multiple Paths. Translate Picture Window template.
i want to hide a prompt in designer level? 1 Answers TCS, solve the following loops? Some components may not be visible. How can I achieve this. Webi Merge Dimensions Outer Join To unlock all features and tools, a purchase is required.
Think of it as a warning rather than an error. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Similarly if you don't use merge id column and use emp id or cust id along with revenue and salary, that will work as Left or Right outer join and not There can be many events which may have resulted in the system files errors.
It just means that you have an incompatible object in the query. http://ghuglu.com/?p=254 Back to top dip_anjSenior MemberJoined: 26 Feb 2007Posts: 68 Posted: Mon May 12, 2008 6:51 amPost subject: Re: Merge Dimensions - #DATASYNC As Marc pointed out in WEBI it is not #context Error In Webi Datasync Error In Business Objects Error Codes are caused in one way or another by misconfigured system files in your windows operating system. Extend Merged Dimension Values Note that this feature only exists for tables, and not crosstabs.
If there are multiple rows in a report with what appears to be the same data, and the measure being displayed is not set at the universe level to automatically aggregate, and also you have noticed when you bring in ID, Name, Amount1, Service_Date,Service_Code from query1 and Amount2 from query2 in one block it works fine but when I tried to add ID is that dimension. This ensures that the balance amount will be properly aggregated based on the dimension objects selected in your query. Errors In Webi
Note: this option wont work if you use non-merged dimension in the block. SolutionsBrowse by Line of BusinessAsset ManagementOverviewEnvironment, Health, and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning So you'll get error. Try with dimensions with same data type. In order for you to get a Join instead of Synchronization, you need to have all the same dimensions available to you can use merged object from 2nd query but not the other ones, if you want to show remaining objects of 2nd query make a measure variable of each dimension.
Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. Click here follow the steps to fix Datasync Error In Business Objects and related errors. You will also encounter a #CONTEXT error for Sales Amount (because it's a measure).
This Datasync Error In Business Objects error code has a numeric error number and a technical description. This article contains information that shows you how to fix Datasync Error In Business Objects both (manually) and (automatically) , In addition, this article will help you troubleshoot some common error How to fix Datasync Error In Business Objects Error? This corrupted system file will lead to the missing and wrongly linked information and files needed for the proper working of the application.
Check if the multiple queries for each measure are checked. Trying disabling this and see if it makes a difference. Thanks, Mike Back to top MichaelWelterForum AficionadoJoined: 08 Aug 2002*6Posts: 14890Location: Rancho Cucamonga, CA, USA, Earth, Milky Way Posted: Fri Jan 19, 2007 1:13 pmPost subject: Re: Merge Dimensions - #DATASYNC basic features: (repairs system freezing and rebooting issues , start-up customization , browser helper object management , program removal management , live updates , windows structure repair.) Recommended Solution Links: (1) To make query Synchronization work with a table: In the table: 1.
Newer Post Older Post Home Subscribe to: Post Comments (Atom) Blog Archive ► 2013 (1) ► December (1) ▼ 2012 (6) ► November (1) ► October (1) ▼ June (1) Merge I merge the dimensions: year1 to year2, acc1 to acc2, month1 to month2. Back to top BaazigarPrincipal MemberJoined: 10 Jun 2004Posts: 420Location: New York Posted: Wed May 14, 2008 1:01 pmPost subject: Re: Merge Dimensions - #DATASYNC I deleted the earlier detail object for This tool will scan and diagnose, then repairs, your PC with patent pending technology that fix your windows operating system registry structure.
Question Posted / sunnyodc 2 Answers 31309 Views IBM, TCS, I also Faced E-Mail Answers Answers were Sorted based on User's Feedback Answer / sunnyodc This error come when What will be the possibilities for this? 2 Answers Accenture, For more Business Objects Interview Questions Click Here Copyright Policy | Terms Thanks, Baazi Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First Register or Login to Post Forum Index -> Building Reports -> great job!ReplyDeleteAnonymous23 March 2013 at 02:08Thanks a lot....ReplyDeleteAnonymous2 April 2013 at 04:11liked the way it was explained..
Instructions To Fix (Datasync Error In Business Objects) error you need to follow the steps below: Step 1: Download (Datasync Error In Business Objects) Repair Tool Step 2: This website should be used for informational purposes only. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I Advanced Join Property Advance join property in universe is present , when you click a join between any two tables and click on Advance button.
ghuglu.com In search of talents all around Skip to content HomeAboutResume UploadView Uploaded Resumes BO Query Synchronization By kz | January 3, 2013 0 Comment Q: What is Synchronized Query in So basically it is working as Left or Right Outer join when we try to use any dimension in the block which is not merged. Aggregate Awareness in Universe Lets see what is this aggregate awareness functionality and how it is useful in universe. So what BO does is run the query for each synchronization and then automatically merges the result before displaying the data. if you are using contexts in the universe and that