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.
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
What am I doing wrong here? There is only one selection in the Target Canvas??
In BIP. I was able to group tables. Is this possible in OAC
I creates a parameter "Role Name" and then I put the Role name field in the filter and made a bind to the parameter, When I add the value in the parameter, it works. When I delete it from the parameter it give me <empty> How do I get rid of the <empty>
Hi, all, I have been struggling with connecting to Teradata in OBIEE Admin tool. I can't import Metadata to the RPD that exists. I am not sure about if it is due to my config of ODBC Teradata is incorrect or anything else? Please find the following errors as attached: Many thanks for your help!
Hi Team, Has anyone upgrade OAS system from the 2024 to 2026 version? if yes, could you please share the resposne files. Regards, Chand
