Categories
- All Categories
- 121 Oracle Analytics News
- 21 Oracle Analytics Videos
- 14.4K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
How to unite two rows in one
Hi. I have a situation like below - two lines with same code 0080573511 i first column and different names ABC and DEF in second.
I need to unite names to get one line with code and name ABC DEF
How? I's this even possible?
Answers
-
Conceptually you're starting off on the wrong foot there. The concept of a "row" is 1000% artificial in OBI. Just because it's a "row" in the database doesn't mean anything to OBI. I can construct an OBI "row" out of an XML file, a database table, a Hadoop cluster and an Essbase cube in no time at all. It will look like a "row" but it isn't one. The RPD and model abstracts that whole concept.
Your question's answer lies in the database / the source. Aggregation / Windowing functions and then expose your new "row" to OBI.
OBI works with models. Not SQL code which is what you will need if your data is stored in a relational database.
0 -
i need view like this.
0 -
It's clear what you want, but you're thinking as if OBI was SQL Developer with graphics. It's not. It's an analytical platform.
0 -
I know but I was wondering if there is any chance to use something like sql code CASE WHEN or something in new column to get this result.
OK thx for help
0 -
https://www.google.com/search?q=merge+2+rows+into+1+sql
SQL. It's not CASE WHEN'ing. It's merging / aggregating.
0