Doubt on Not Assigned

[Former Member]

Hi Experts,

Recently i designed a webi report. In that report i am getting data like this.

I want to replace Not assigned as NA. Please suggest me how to do that.

Thanks,

Sravani.N

[Former Member · Accepted solution]

You can use an IF statement in every column to replace the result

for eg If([Dimenison1]="Not Assigned") then "NA" else [Dimension1].

similarly use this for every dimension in the table columns

[Former Member · Accepted solution]

Hello Manish,

Here my source is BEX. where i need to apply the formula. In BEX or WEBI.

Thanks,

Sravani.N

[Former Member · Accepted solution]

Webi

[Former Member · Accepted solution]

In Webi where you have dragged your dimension over there replace with this formula alongwith ur dimension name

[Former Member]

Hi mate,

     Manish way is correct. The formula is:  =IF(field1="Not Assigned", "NA", "field1")

Regards.

[Former Member]

even if then else statement works no hassle of brackets

[Former Member]

Thanks for ur reply manish.....and also i have another doubt, suggest me. I have Column header name as Document Number. I want to display this name as Document in first line, Number in second line in webi report.

Name : Document Number as

            Document

            Number

[Former Member]

Hi mate,

     It's like click in the header cell and write: ="Document" and add a field and the same: ="Number",

But do you want it in 2 cells or in the same cell but one over the other?

Best

[Former Member]

Thanks for your reply Can Vill.

Here i am taking source as BEX. The column is coming from BEX. Here column header is the object name. Here my doubt is there any possibility to change the name of the column header in WEBI without change the name in BEX.

Thanks

Sravani.N

[Former Member]

yes you can play around with the name a little bit. use the substr , concatenation and nameof function for the dimenion and you could be able to make it appear in different lines and so on.

For eg my dimension is "Document level status"

Then i could use it as = substr(nameof([Document level status]);0;8) + "

"+ substr(nameof([Document level status]);10;5) + "

"+ substr(nameof([Document level status]);17;6)

its just an example not exact formula i dont have a system right in front of me so just wrote to the best of my knowledge.

but basically you can use the text in different ways here + is the concatenation oeprator and if you give a line in the formula between "" then it take up as a new line in header.

try it out and let us know if it helps

[Former Member]

Yes, the sample that I provide it's just drag and drop the field (without change name in BEX)in webi report and change the header name with the text, and you can choose if you prefere to add a field and put each word in each field.

Regards