cancel
Showing results for 
Search instead for 
Did you mean: 

BO webi Report Issue

Former Member
0 Kudos

Hi,

We have a BO webi report in that for one column we are dispalying City name and City Code ,Now i want to split that column  to one value

Currently the column values are showing as below:

Column Name

--------------------

USBWG; BOWLING GREEN

From backend only we are getting two values in the report

Please let me know wheather we can split that column value to like below

Column name

------------------

USBWG

Many thanks in advance.

Thanks & Regards,

Kumar V

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member182342
Active Contributor
0 Kudos

Hi Kumar,

Create a variable as shown below

=substr([Column_name];1;(Pos([Column_name];";"))-1)

or

=Left([Column_name];(Pos([Column_name];";"))-1)

It will Resolve your issue.

Regards,

Anish

Former Member
0 Kudos

assume you have DImension ABC you try below formula

=Substr([ABC];Pos([ABC];"/")+6;Length([ABC]))

Substr(input string; integer start length; integer length);

Former Member
0 Kudos

Hi,

Just use Left(Trim(<Object Name>);5)

Thanks,

Sakthi.

Former Member
0 Kudos

Hi Kumar ,

r u using any formula for merging those two field  or its already  merged from DB side (City name and City Code).

Thanks

Anurag Srivastava

Former Member
0 Kudos

Hi Anurag,

It's already mergerd in DB side.

is there any approach where we can break City Name and City Code in webi Report?

Thanks & Regards,

Kumar V

gleo_SRAM
Active Contributor
0 Kudos

Hi Kumar,

You can create a variable in your webi report that strips out text from a dimension.  Are you city codes all the same length?

You can use the LEFT or RIGHT functions to extract the City Code.

With regards

Gill

Former Member
0 Kudos

Hi Leo,

Many thanks for responding.

City Codes maximun length is 6 and Minimun length is 5

By this variation can we split using the above functions whicu u said if yes can u kindly give mw one example which will help me for my case.

Thanks & Regards,

kumar V

gleo_SRAM
Active Contributor
0 Kudos

Hi Kumar,

In your Webi document, right click on Variables in your Available Objects panel.  Select create new variable and the syntax will be as Sakthi has added below.  Remember your object name goes in square brackets!  [CITY]

Use this variable in your table and not the current dimension that t

With regards

Gill

Former Member
0 Kudos

Many thanks Leo it's working .

Thanks & Regards,

Bharatkumar V

gleo_SRAM
Active Contributor
0 Kudos

That's great Bharatkumar,

There are a huge amount of formula in Webi, I have yet to come across something that can't be done 🙂

With regards

Gill

Former Member
0 Kudos

Yep there are many formulas where we can write in webi..i just tried with left function with out trim....

Thanks & Regards,

Kumar V