Categories
OBIEE - concat rows with strings
Hello all -
I am working with web analytics and trying to concatenate multiple rows of strings against a dimension. I have a session ID (column) which has multiple rows of data (another column) and would like to have this column strings together vs. being separated on a row basis.
Example - for the first one, I'd like the strings to be on one line against the "Session_ID" separated with commas. I have tried using the concat function in OBIEE but it is not properly adding them together. Any suggestions are welcomed as I hope that can provide some guidance.
Thank you,
Andrew
Answers
-
Hi Andrew,
Yeah that's not how OBI works ;-)
Best you go for something like LISTAGG in an EVALUATE to acheive this.
0 -
Christian, thanks so much for your prompt reply. I will give that a shot here soon and will keep you posted.
0 -
Just to add a small (obvious) detail, the exact function you use (like LISTAGG) will depend on which database you are using.
0 -
Yeah that's why I said "something like" ;-)
0 -
I know I was at the risk of stating the obvious. Should have kept quiet
0 -
No you shouldn't. It's good to point it out!
I was just trying to be funny since it's Friday night.
0