About me

This is my personal blog containing postings related to Business Objects.

It contains my personal views, thoughts and opinions and is not affiliated nor endorsed by Business Objects or my employer.

Your comments to my posts are welcomed and encouraged, but they are moderated to avoid irrelevant or spam comments. So please bear with me if they take a while to appear – my day job comes first!

I hope you find this content helpful and of use.


16 Responses to “About me”

  1. Ketan Dave Says:

    Thanks for your insight and information , very practical and useful


  2. Michael Says:

    How can I submit a question regarding Business Objects?


    • weldblog Says:


      You can post a question right here if you like. I will do my best to answer.

      But please note, I do not work for or represent SAP/Business Objects. So any views or opinions are my own.

      • Suman Lavanuru Says:

        suppose if you have 5 columns in a report. how do you apply count to
        select null values from each column of the report, what is your approach. And once after applying
        the count, if i click on the count of 1st column null value it has to show in which rows the null
        values are present. what will be your approach. plz answer this scenario.

      • weldblog Says:


        Not too sure I understand what you are trying to achieve.

        Can you provide an example?

  3. Sami Sharma Says:

    Hi. I have a question on alternating row colors in webi. I went to the properties and set 2 for the frequency in the “Alternate Row/Column colors” and have the specified color. Do you know why it’s showing as one color and not alternating the colors with white in between? Is there any other settings I need to change.
    I’d appreciate your opinions. Thanks, Sam.

  4. Max Says:

    Good to find your site. I have a question. Can you apply the same colors to the same objects/dimensions used in all the graphs? Thanks.

  5. Chris W Says:

    Hi there,

    Love the blog 🙂

    I have a question relating to the RunningSum function and its context and reset dimensions.
    Do you think you might be able to help? (Appreciate I haven’t given you much detail here!)
    So far I cannot find a similar situation to mine in forums online


    • weldblog Says:

      I will try to help. Provide some more detail and we’ll take it from there.

      I might reply via a blog article though so that everyone can benefit from the answer.

  6. Matt Says:


    Hoping you can help me with something. I would like to create a variable that will check the date/time stamp of my data and then perform one of two RelativeDate calculations based on the result of the check. I’m getting a “format incompatible with regional settings” error on the time stamp portion of the below example.

    For example:
    =if [dateobject]>= 04/01/2013 07:00:00 AND [dateobject}<= 05/01/2013 07:00:00 then RelativeDate([Object];-.20833)
    else RelativeDate([dateobject];-0.16667)

    Thank you in advance for any suggestions or assistance.

    • weldblog Says:

      First thing I would do is to check the format of dateobject. It may be different to your regional date settings. The easiest way around this is to wrap the dateobject within a FormatDate statement that is compatible with your regional settings. Something like this might work:

      If(FormatDate([DateObject];”dd/mmm/yyyy hh:mm:ss”) > “04/OCT/2013 07:00:00”;

      Also note that Web Intelligence doesn’t use If Then Else statements. You start with the If, but you separate the true/false outcomes with a semi colon.

      Give that a try.

  7. May Says:


    Hope you could help me here. I want to sort out free format text object which contains keywords. For example,


    Find “blue” from the object and replace the entire object with “azul”, find “yellow” then replace with “amarillo”, “red” into “rojo”. When neither “blue”, ”yellow” nor ”red” was found, replace the object with “not found”. So in the above example, “ggg/hhh/xyz” will be displayed as “not found”.

    Thanks in advance for your assistance.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: