Text variable Syntax in Webi

[former_member203111]

Hello experts,

can anyone please help me creating a syntax for webi.

I have a webi report built on BEx query, I need to create a header of that webi report showing Report Name, Day of the Month and Current Period, something similar to that..... "Sales Progress Report Day 20 of 28 (65%) Period 09 2015"

I want to show report name the current day of the period and the period in the header.

How can I create the webi syntax

Please advise, will appreciate your help.

Regards

[amitrathi239]

Hi,

try something like

=DocumentName()+" Day "+FormatDate(CurrentDate();"dd")+" Period "+ FormatDate(CurrentDate();"MM yyyy")

If you are looking for different font colour then you can create different rules.or can place three blank cells and adjust the position..

even you can hardcode the report title also.

Amit

[former_member203111]

Hi Amit,

Thanks for your reply.

dont worry about the color coding, i just used it to make it easy to understand.

Note that Day 22 of 28 (65%) is a text variable in bex query and changes everyday

Period 09 2015 also varies every period.

Can you help me formulate the exact syntax based on my color coded description above.

will appreciate

Thanks

[Former Member]

To concatenate strings, use the + symbol

So, the red part will be =DocumentName()

If you have Day 22 of 28 (65%) as a full text string from your Bex Query then you'd build up your string to be:

=DocumentName()+" "+[Day x of y String]

Then if your Period 09 2015 is a string from Bex then it's going to be

=DocumentName()+" "+[Day x of y String]+" "+[Period String]

However, if you don't have the period string set up in Bex, you could create it as a variable, called Period String, defined as:

="Period "+FormatDate(CurrentDate();"MM yyyy")

Regards,

Mark