Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE
Answers
-
Let me elaborate it again. There is a csv file. When you create a data model, you can create an csv file. The columns are all there and you can run them as a view. In this there is no sql involved. Now I create a data model. This is looking at a source
and it needs to pull multiple account numbers. The account numbers are in the csv file.
To further explain
G1( CSV file has the account number. There is no way to put sql logic here)
G2(Data model has sql here. How to call the elements of G1?
Here is what I am thinking
G2( SELECT * FROM Table where ACCOUNTNumber IN (G1.Account, G1.Account2)
I am thinking that it generates all elements of G1 as a large text. Let me know if this is possible.
Thanks0 -
Sorry but you keep thinking at OBIEE in the wrong way.
Why do you want "SQL logic" on the CSV? It isn't you writing SQL in OBIEE, the tool generate what it needs to get the data it needs. It isn't your problem how this is done.
If you import your 2 sources in the RPD and make a join between them that's all you need. Don't think it's a CSV, use the functions the tools gives you and make the join.
OBIEE will then manage that.
Stop thinking technically, think logically at the business meaning of what you need (that's why you paid $$$ for the tool).
0 -
Let me make sure I understand it. You want me to have a join between the two data models. I am ok with that. Just one thing if both were data sources, that would not be a problem
One has a data source and the other does not .
one is pulling data from tables
One is pulling the csv file
If I have logic that does an inner join, how would the tables know. The csv file is not an actual table.
One side we have columns of an actual table and other side is the csv file
Please see my screenshot. It will make more sense to you. One is G_1 and the other is G_2. You can see how both are colored different. I want the elements of G_2 to be called by G_1 as filters. Does that make sense
Remember I am not doing any sql logic on the csv file. That is why I want to keep my sql logic in G_1.
0 -
That's why I stopped replying in this thread...
0 -
user13510619 wrote:Yes it is analyses.
You remember you posted that as your first reply 6 days ago?
Because you said it was an analysis!!!!
And now you are posting a Publisher screenshot.
So, can you please clarify once (and stick to it) what tool are you talking about? OBIEE analysis or BI Publisher report?
Because guess what: it's totally different ...
0 -
Please bear with me. I am still very new to OBIEE. IT is oracle BI Publisher. I am sorry I did not clarify it. Let me know if I am able to implement that in Oracle BI publisher.
0 -
user13510619 wrote:Let me make sure I understand it. You want me to have a join between the two data models. I am ok with that. Just one thing if both were data sources, that would not be a problemOne has a data source and the other does not . one is pulling data from tablesOne is pulling the csv fileIf I have logic that does an inner join, how would the tables know. The csv file is not an actual table. One side we have columns of an actual table and other side is the csv filePlease see my screenshot. It will make more sense to you. One is G_1 and the other is G_2. You can see how both are colored different. I want the elements of G_2 to be called by G_1 as filters. Does that make sense
Remember I am not doing any sql logic on the csv file. That is why I want to keep my sql logic in G_1.
^----- Wow
That is NOT an analysis.
0 -
Are you familiar with Oracle BI Publisher?
0 -
I am but not a fan of it and also there's a special forum for BIP where actual BIP users / lovers reside. Asked the admins to move the thread.
0 -
Check if below post helps:
Kind Regards
Ashish
0
