Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to get results for two different column values not for common values
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.
| Name | Opportunity ID | Business Name | Profit Center |
|---|---|---|---|
| Test 1 | 123 | ABC | ABC |
| Test 2 | 456 | ABC | XYZ |
| Test 3 | 678 | ABC | XYZ |
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.
Answers
-
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")If you are getting an error - why do you not post the error here? We can not magically know what the error is and if you're not being exact with your problem description it's hard to provide any help.
Also: You aren't providing any information on your environment.
Or simply think about this: You're sick. You call a doctor and tell him "It hurts there." and nothing more. Can he diagnose you? No.
You come here expecting (free) help for your issue. Do your part by writing quality questions with as much detail as possible to show that you're actually interested in having this resolved in a meaningful way rather than the question once more being just a "do my homework" question.
0 -
Hi Christian,
Thank you for the smart Answer, Appreciated!
I have posted it here to get help. I believe this community is to help each other and if anyone is new to OBIEE, this community can help you.
Apparently I have given a scenario and provided the syntax. if you are a developer you can understand the syntax and provided your feedback. Here I didn't ask you to do my homework or any other. If you can help please you can but don't judge me asking you to complete my homework.
0 -
3999508 wrote:Apparently I have given a scenario and provided the syntax. if you are a developer you can understand the syntax and provided your feedback.
Right, of course, because everything in IT has exactly one and only one possible issue or outcome so context doesn't matter. And also a sharing the actual error message is unimportant it seems.So let's try this once more:
3. Give information about your environment, such as versions of software you use. This is essential, as versions change and other users might run into a similar problem never knowing if the thread they read was about their version.
==> This has not been done.
5. Tell us what you have already tried to solve the problem. Help the others to get the big picture and show that you haven't just dumped your work on the forum users.
==> This has not been done.
7. Screenshots help to understand visual problems. It’s hard to describe problems with are only visual like “my fields are not aligned”. Make screenshots and add them to your post.
8. Provide stacktraces as text if you are asked to provide one. This way we can look at each part.
==> Now this is where it helps to think about what helps others to understand your problem. Nobody except your can see your screen. Nobody except you sees the error. Nobody sees your logs which you also did not provide.
0 -
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
0 -
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.
0 -
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
0
