Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to retrieve a value based on a date selected by the user in OBIEE
Answers
-
I know that nobody here owes me anything, I am not demanding anything, You are wrong in your opinion, so, do not write things that I am not doing.
About open multiple threads, I am tired of repeating that I did not know that was not allowed to rephrase my question in other threads for other time zones, other people, I am new here, Do you understand I was the sin.
and you are like gossiping because you are not adding anything technical, just you have time for this.
0 -
Hi Gianni,
We are OK now (Hahana, and not everyone, I am not bipolar, just that we talked in another post).
I wanted to ask you. In my specific case, if I have to do the analysis of a Statement of profit and loss, and my company work with 2 currencies (NIO = Nicaragua and CRC= Costa Rica), and they want to see it all in a single analysis, so they are requesting me to convert the amounts from these currencies to dollars, with an exchanged rate, and I have the limitation that I do not have the exchange rates that I need available in any of my dimensions,
So, what Can I do in this use case to achieve my goal? This is my actual challenge, well, for me as a not senior.
Thank you for your useful answer.
0 -
As said the answer is to model it in the RPD via a lookup table (or at least have the table with the exchange rate available).
As apparently you can't touch the RPD (but then what's the point of having to do a job if you can't do it the way it's supposed to be done?), something that was also posted earlier in the thread is a direct database request.
You write your own query and this query will return you everything. And "everything" means really everything and not just an exchange rate. So your amounts, the exchange rate and in the query you calculate directly the USD values. Because you can't mix a DDR and an analysis (mix columns of both together) you have to forget your analysis and return the same data in the DDR.
Write your query, and done.
Are you using the tool? We agreed the answer is not as SQL Developer (a free tool) would do the same.
But that's live ...
0 -
Ok Gianni,
I think we are done with this thread, finally!. I think that this is my final solution,
As I am the only one in BI in my company, I can do the change in the RPD. You are not going to believe me, I thought something like what you told me as well (lookup table), but I was unsure (unsure girl) on how good could have been this solution, I had different ideas to address this, and I was not sure about any of them.
Now, @Christian_Berg, you can be more much glad than before that Gianni helped me a lot.
Gianni, thank you for all your time invested on this thread. This is a public recognition award. You have been our today hero.
By for now.
Have an excellent day.
Best regards
0 -
Close. You have to wait until the lookup actually finds my handle and then you can click on it.
@Eimis Pacheco <-- like this
0 -
So, based on what the FAQ and OTN rules suggest, you can maybe close the thread? For now it's still This question is Not Answered.
0 -
If I wasn't off being "employably" busy ... what you need to do is model a lookup table to return the exchange/conversion rate ... +1 to my friends for sticking around!
0 -
Thanks, Little by Little I am getting to know the usage of this tool.
0 -
Gianni is. I'm just being funny from the sideline :-)
0