Below given is the step-by-step guide to migrate from CE 10 CMS & Crystal Reports to BO XI Release 2 CMC Environment (along with Business Intelligence Administration Launch Pad guide)&Os&hell…Read More

LCMBIAR- For moving content between same version of the product (in this case all Bi4.x versions are considered same) - a new tool is used, its called promotion management.With this tool yo… Read More

1) Logon to SAP2) Go to /ncmod T-code3) Enter Project details and select "Components". Now click on Display button. 4) Click on Function Exit. Click text next to include. Double click o… Read More

Create header in cross tab - WEBIUsually for cross tabs if we put required text above the crosstab data part it would replicate (i.e. it wont merge) the same header in all columns.So he… Read More

The below article provides information on how to use Promotion Management tool in SAP Business Objects BI Platform 4.0 or above to transport various objects (Webi, universe, d… Read More

Transport or Migrate BEx Query changes from one environment to anotherIn order to transport/migrate BEx query from lower environments to higher environment, follow below steps: 1)… Read More

AUTOMATION OF SCHEDULED JOBS LINKING TO BO REPORTS CURRENT SCENARIO:If BOBJ reports are scheduled to run on daily recurrence and for some reason if BW loads get delayed or failed, BOBJ… Read More

In order to modify any existing BEx query in lower environments first step is to lock the query for which follow below steps:1) Login to SAP Logon Dev system2) Go to Transport Connection on… Read More

SQL * Plus File commands - Oracle1. SAVE filename2. GET filename3. START filename4. @ filename5. EDIT filename6. SPOOL filename7. EXITSQL> L1. Select lastname, manager_id, dept_no2* from… Read More

In earlier post http://angeldeeps.blogspot.com/2010/04/sql-plus-oracle-editing-commands.html I discussed about list of editing commands used in SQL * plus - Oracle.Here, I am going… Read More

A table in a dataset is used to populate a list box with employee name from the employee table. With the dataset the name of the table and field must be known at design time. if they are mis… Read More

Drawing simple lines on a Windows form is not easier as there is no Line control. Still you can make a line by using a Panel control and setting its width or height to a few pixels. But if y… Read More

Travel:Olive Mountain HillView - Best Resorts in WayanadOlive Mountain is a joint venture of Babu Varghese and Thomas K. Paul. It is situated at the lower slopes of elegant chembra peak, the… Read More

This code demonstrates how to Add/Insert, Update, delete, edit in Devexpress aspxgridview. Sorting and changing position of columns is by default enabled. Only to disable it you need to spec… Read More

This code shows how its easy to use a Bar chart in your Web applications.To start with first of all download and install Devexpress controls from www.devexpress.comHere I am going to make a… Read More

This code snippet demonstrates the use to create a log file to store either your error or informational thing like storing executed queries etc.Here you need to pass the message when you cal… Read More

This code demonstrates how WinGrid allows the user to sort on both single and multiple columns by clicking on the column headers. The UltraWinGrid allows user to sort by setting the .HeaderC… Read More

This code demonstrates using the Column Chooser functionality to display a dialog similar to Microsoft Outlook's Field Chooser where the user can choose columns to display in the&n&hell…Read More

This code shows how to obtain a card view layout with the help of Infragistics WinGrid. WinGrid helps you to easily print and export your data in the form of excel or PDF document.1. Bind gr… Read More

The following code demonstrates using SHA1 algorithm to hash a password:In VB:Imports System.Security.Cryptography Public Function ComputeSHA1(ByVal textToHash As String) As String Dim S… Read More

DirectCastperforms better than using CType when casting from an object to a more specific type because it does not use runtime helper functions.The below example shows way to cast from type… Read More

SQL FunctionsTypes of FunctionsSingle Row Functions - 1. Single row functions: •2. Manipulate data items •3. Accept arguments and return one value •4. Act on each row ret… Read More

Table - Basic unit of storage; composed of rows  and columnsNaming Rules -  1. Table names and column names: •2. Must begin with a letter 3•3. Must be 1&n&hellip…Read More

This code shows usage of validations in Devexpress controls.ASPX Page    Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dx" %>    Namespace="DevExpress.We… Read More

Pivoting is an operation in which you need to build a transformation such that each record from any  input stream, such as, a  nonrelational database table, must be converted into… Read More

SQL * Plus editing commands -1. A[PPEND] text2. C[HANGE] / old / new3. C[HANGE] / text4. CL[EAR] BUFF[ER]5. DEL6. DEL n7. DEL m n8. I[NPUT]9. I[NPUT] text10. L[IST]11. L[IST]… Read More

The Differences between SQL and SQL * plus commands are as follows :SQL -1. A language2. ANSI standard3. Keywords cannot be abbreviated4. Statements manipulate data and table definitions in… Read More

Read this article to load a service : http://angeldeeps.blogspot.com/2010/03/load-list-of-services.htmlprivate void cmdStartService_Click(object sender, System.EventArgs e) { try { msvc… Read More

Spool [pathdirectory] Spool will record all your statements in a text file which will be created in the path specified by you in pathdirectory. Until and unless you swtich off the spool it w… Read More