bobjexperts.blogspot.com
SAP BODS Experts: BusinessObjects Data Services
http://bobjexperts.blogspot.com/2011/04/businessobjects-data-services_21.html
Join us on Facebook. Thursday, 21 April 2011. Posted by SAP BOBJ Experts. BusinessObjects Data Services is a complex platform for the data integration process and constitutes the latest version of Business Objects application. In comparison with previous versions of BO ETL (BusinessObjects Data Integrator), a Data Quality module is the integral part of Data Services. The SAP BusinessObjects Data Services platform has a modular structure and consists of the following tools:. Among other, these objects are:.
bobjexperts.blogspot.com
SAP BODS Experts: Some cool options in SAP DS
http://bobjexperts.blogspot.com/2015/03/some-cool-options-in-sap-ds.html
Join us on Facebook. Saturday, 7 March 2015. Some cool options in SAP DS. Posted by Mohammad Shahanshah Ansari. I find couple of cool options in SAP DS and used to apply in almost all the projects I have been doing. You may also give a try if not done yet. Hope you would like these. You can see all these options in designer. Right Click the Job Click on Properties Then click on Execution Options. You can change this value of. Maximum value you can set is 64000. Refer the below screen shot for reference.
bobjexperts.blogspot.com
SAP BODS Experts: April 2011
http://bobjexperts.blogspot.com/2011_04_01_archive.html
Join us on Facebook. Friday, 22 April 2011. Data services, Read-only, Repository. Often I hop into the BOBJ technical forums lately. Only few topics really seize my attention, others I don’t know much about or I don’t want to plow into it. One such discussion was the possibility of creating two logins for a local repository with one account having the capability to change and other to just read only. Can this be done within the management console? What is a local repository? 2Associate DS Read Only Login.
bobjexperts.blogspot.com
SAP BODS Experts: About Us
http://bobjexperts.blogspot.com/2011/04/about-us.html
Join us on Facebook. Monday, 18 April 2011. Posted by Mohammad Shahanshah Ansari. Welcome to the SAP BOBJ DS Experts. If you have a any comment regarding your experience at BOBJ Experts Blog, feel free to contact us at bobjexperts03@gmail.com. Subscribe to: Post Comments (Atom). How to create a database links in Data Services using SQL Server. By Mohammad Shahanshah Ansari Sometimes you need to use multiple databases in a project where source tables may be stored into a data.
bobjexperts.blogspot.com
SAP BODS Experts: Custom function to get database name from a datastore in DS
http://bobjexperts.blogspot.com/2015/03/custom-function-to-get-database-name.html
Join us on Facebook. Saturday, 7 March 2015. Custom function to get database name from a datastore in DS. Posted by Mohammad Shahanshah Ansari. Getting function name from a datastore could be useful if you have configured more than one datastores in your project. This helps avoiding code change while migrating objects from one environment to another during the code promotion. Below is step by step procedure to create custom function to get the database name from a datastore and call it in a Batch Job.
bobjexperts.blogspot.com
SAP BODS Experts: Advantage of Join Ranks in BODS
http://bobjexperts.blogspot.com/2015/03/advantage-of-join-ranks-in-bods.html
Join us on Facebook. Saturday, 7 March 2015. Advantage of Join Ranks in BODS. Posted by Mohammad Shahanshah Ansari. What is Join Rank? You can use join rank to control the order in which sources (tables or files) are joined in a dataflow. The highest ranked source is accessed first to construct the join. Best Practices for Join Ranks:. Define the join rank in the Query editor. Default, Max and Min values in Join Rank:. Where Join Rank to be used? When code is not full push down and sources are with huge ...
bobjexperts.blogspot.com
SAP BODS Experts: Quick Tips for Job Performance Optimization in BODS
http://bobjexperts.blogspot.com/2015/03/quick-tips-for-job-performance.html
Join us on Facebook. Saturday, 7 March 2015. Quick Tips for Job Performance Optimization in BODS. Posted by Mohammad Shahanshah Ansari. Ensure that most of the dataflows are optimized. Maximize the push-down operations to the database as much as possible. You can check the optimized SQL using below option inside a dataflow. SQL should start with INSERT INTO……SELECT statements. Index Creation on Key Columns:. In BODS ‘Select Distinct’ is not pushed down. This can be pushed down only in cas...Ensure that w...
bobjexperts.blogspot.com
SAP BODS Experts: Substitution parameters in SAP DS
http://bobjexperts.blogspot.com/2015/03/substitution-parameters-in-sap-ds.html
Join us on Facebook. Saturday, 7 March 2015. Substitution parameters in SAP DS. Posted by Mohammad Shahanshah Ansari. What is substitution parameter? Substitution parameters are used to store constant values and defined at repository level. Substitution parameters are accessible to all jobs in a repository. Substitution parameters are useful when you want to export and run a job containing constant values in a specific environment. Scenario to use Substitution Parameters:. Defined at Job Level. 8226; The...
bobjexperts.blogspot.com
SAP BODS Experts: May 2011
http://bobjexperts.blogspot.com/2011_05_01_archive.html
Join us on Facebook. Thursday, 5 May 2011. Group Counter in Task List. Alphanumeric Group Counters in DS. I was thinking to write some posts for our blog from the day we launched this blog but due to work pressure and time constraints I was unable to do so. But I feel, in spite of being so busy in my daily work I must take out some time for technical writings as well. This post of mine is a step forward meeting the objectives of this blog. Hope you would like it. By Mohammad Shahanshah Ansari. 3 In dataf...
bobjexperts.blogspot.com
SAP BODS Experts: How to use Custom SQL in Lookup_Ext Function?
http://bobjexperts.blogspot.com/2015/03/how-to-use-custom-sql-in-lookupext.html
Join us on Facebook. Saturday, 7 March 2015. 8203;How to use Custom SQL in Lookup Ext Function? Posted by Mohammad Shahanshah Ansari. The purpose of the Custom SQL in the Lookup Ext function is to improve the performance by limiting data while retrieving into memory, in case doing pre-load cache. You can use aggregate functions as well and perform calculations. If anything looks complex to implement in DS but easier at database level then this feature can be useful. Example to use an aggregate function u...
