How to find a string inside another string in BIP?

Use contains function inside the conditional region statement in BIP as below

How to change Local DB Password?

1. Browse to the below folder in Windows Explorer


SiebelInstallationFolder\Client\bin


2. Click on "dbisqlc.exe"

3. In "Login" tab Enter the "User ID" as "DBA" and "Password" as the Siebel server's Enterprise name


4. In "Database" tab select the local db in which you wish to change the password for the user and click OK


5. In "Interactive SQL" window, enter the following command and Execute 


grant connect to identified by

Using Variable in Conditional Region

Use the syntax below to use the variable in Conditional Regional (If Statement in BI Publisher Report)

VB Macro to split single column into multiple row delimited by Alt + Enter

Sub tst()    
    Dim X As Variant
    Dim iIndex As Integer


    iIndex = 1
    For i = 1 To WorksheetFunction.CountA(Worksheets("Sheet2").Range("B:B")) + 1
        If Range("B" & i).Value = "" Then Exit For
        X = Split(Range("B" & i).Value, Chr(10))
        Range("D" & iIndex).Resize(UBound(X) - LBound(X) + 1).Value = Application.Transpose(X)
        'For j = iIndex To iIndex + UBound(X)        
            '    Range("C" & j).Value = Range("A" & i).Value       
        ' Next
        iIndex = iIndex + UBound(X) + 1
    Next
End Sub

VB Macro to split data in single cell into multiple rows.  Assumptions 1: Data in the row is split by "Alt + Enter", Assumption 2: Data to be split is available in column B