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?
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.
i need view like this.
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.
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
https://www.google.com/search?q=merge+2+rows+into+1+sql
SQL. It's not CASE WHEN'ing. It's merging / aggregating.
