if Else condition not working in Webi 3.1

building reports webintelligence
1

Hi,

I am facing issue in webi:
I have 3 dimenion objects: L04, L05, L06.
And these 3 objects are optional prompt in the WebI report.
So, when Region is selected in the prompt, the corresponding country needs to be displayed in a column in the web, similarly when country is selected in the prompt Branch data needs to be displayed.
For ex: When EMEA is selected all countries of EMEA like EMEA DACH,EMEA ADH,etx should be displayed.

All these values needs to be dsiplayed in only one column in the WebI report. So,I have created a variable with the following condition:

=If(IsNull([L04_Prompt]) And IsNull([L05_Prompt]) And IsNull([L06_Prompt]);
[Data].[L04 Profit Center];
(If(Not(IsNull([L04_Prompt])) And IsNull([L05_Prompt]);
[Data].[L05 Profit Center];
(If(IsNull([L06_Prompt]) And Not(IsNull([L05_Prompt]));
[Data].[L06 Profit Center];[Data].[L04 Profit Center])))))

where: L04_Prompt= prompt value selected. For ex: EMEA.

This condition is not displaying the right result. Could you please provide any solution for this issue.

Thanks
Sindhu

sindhu_cs (BOB member since 2009-04-24)

2

I had to use Length(userresponse(“prompt”))=0 instead of isnull.

Nithya (BOB member since 2005-09-07)

3

Hi Nithya,

Thanks for your suggestion.
Its working… :slight_smile:

I have one more issue:

There are 3 objects: Region, COuntry, Branch.
All this 3 are prompts:
So, when Region ex: EMEA is slected, I want to see all the countries related to EMEA. But report is displaying only the countries which is having the data.

Could someone please provide solution for this.

Thanks
Sindhu

sindhu_cs (BOB member since 2009-04-24)

4

You could do this in several ways. In the universe, you can have an outer join and if you want to just do this on the reporting side. You could get the region, country, branch (Dims you want to display even without data) in an other query and use these with the measures from the first query.

Nithya (BOB member since 2005-09-07)

5

Nithya,

I am not getting you, can u explain step by step

1.How to solve the same in Universe?

2.How to solve the same in WebI/DeskI?

<Explain here>

Thanks & Regards
Pradeep

bopradeep :india: (BOB member since 2009-08-03)

6

Need to include a data provider say query2 for all country details and link with it with the query1(existing DataProvider) of country object.

Use the Country.Query2 object in your table. this will result in all countries.

Tony Joe (BOB member since 2006-12-05)