leave it blank in report when data in MultiProvider is blank or Not Assigned.

[Former Member]

Dear SAP Experts,

I create Query from Query Designer to report data from MultiProvider.

In my report, it show "#" when data in MultiProvider is blank or Not Assigned.

Is it possible to leave it with blank. My customer don't want to show it in "#".

Thank you

Zilla D.

[Former Member]

Option 1:

You can filter the dimension where fields not equal to not assigned.

Option 2:

You can create a variable make the formula as

if(a="#") then "" else a

here "a" is your field.

Regards,

Rajendra

[Former Member]

From my picture above, In column Day 1 and Day 2, it show # for Not Assigned.

For Rajendra Cheraku's  suggestion in option 2, How can I create variable to solve this problem?

Please suggest me.

Thank you

Zilla D.

[Former Member]

Hi,

If you are creating Webi report based on this BEx query then follow this.

In the Day1 column write below formula instead of "=Day1"

=if (Day1="#") then "" else day1

follow the same to Day2 just changing from Day1 to Day2

Regards,

Rajendra

[former_member226862]

Also you could create WEBI detailed variable that contains formula Rajemdra is suggesting. When using WEBI variable WEBI requires that report contains characteristic that WEBI variable is base on (maybe there are other ways how to use variable but this works for me). Usual scenario for me is that I add characteristic and detailed variable based on that particular characteristic then I hide dimension/characteristic in WEBI report.

I prefer using variables because it allows me to move columns around, sometimes even remove column from report temporary without losing formula however there is nothing wrong with approach suggested by Ranendra - just personal preference.

[Former Member]

I create this query via Query Designer and my user open it via BEx Analyzer(Business Analyzer) not WEBI application in  BOBJ.

So, I cannot create the variable with Characteristic.

[former_member226862]

First of all - this is SAP Business Objects thread, not BEx.

There is no standard solution for your problem to suppress '#' and 'Not assigned' in BEx Analyzer. There is Visual Basic code that can be used to intercept and suppress '#' and 'Not assigned' in BEx. If you search forums you will find it. It's relatively simple code however it does require to know enough about SAP BW, Excel, BEx Analyzer, Visial Basic to develop solution that works.