How to get results for two different column values not for common values

Question

Hi,

We have two fields 1. Business Unit and 2. profit Center. Both LOV fields has same Lookup values.

Below is the scenario I wanted to generate the Report if Business Name and Profile Center values are different not the Common values.

NameOpportunity IDBusiness NameProfit CenterTest 1123ABCABCTest 2456ABCXYZTest 3678ABCXYZ

I tried with the below filter but its showing error.

(DESCRIPTOR_IDOF("Sales - CRM Opportunities and Products Real Time"."Business Unit"."Business Unit Name")) <> (DESCRIPTOR_IDOF("Sales - CRM Opportunities and Products Real Time"."Opportunity Extension"."Extension Attribute LOV 005"))

How do we achieve for this.

3866826 · Answer

Hi 3999508

Can you create one more column and do the comparisons using case when and then use the resultant column in your filter. Basically, bin the data and complete the comparisons.

NewCol:

case when col1<>col2 then 'accept' else 'reject' end

In the filter section:

NewCol = 'accept'

This will automatically expand into case when at the close. Since its an expression on the column, you will automatically be able to see how the its interacting.

Next, in the manage sessions (after you have ran the report), you can check how the query is behaving to understand this better.

And finally, you can decide what you want to do with that extra column that you created.

To the others who thing they own OBIEE and its community:

I totally understand both the perspectives. Sometimes being compassionate rather than being a troll actually helps. The question is simple and maybe just maybe I don't understand it properly but I am still trying to move ahead in a direction that can actually lead us somewhere. You don't have to always be a pope in all the discussions. Know-it-all doesn't actually have to mean that you have to suck at explanation. There are a lot smarter yet compassionate people outside.

Simply ask for more information. This is a community, Nobody asked you to be a gatekeeper.

Thanks

Joel Acha · Answer

just to reiterate what has already been pointed out by @Gianni Ceresa and @Christian Berg, the only way that you will get any help from these forums is by providing as much information as possible. Remember that no one here has access to your systems every bit of diagnostics information helps us to understand your issue/scenario.

Gianni Ceresa · Answer

Hi,

3999508 wrote:I tried with the below filter but its showing error.(DESCRIPTOR_IDOF("Sales - CRM Opportunities and Products Real Time"."Business Unit"."Business Unit Name")) <> (DESCRIPTOR_IDOF("Sales - CRM Opportunities and Products Real Time"."Opportunity Extension"."Extension Attribute LOV 005"))

Do you mind posting the error you get?

That would help in giving you more precise hints of what to look at or try.

Thanks