That's a valid point @Christian Berg In Jenny's case, this will work but I totally agree with you and mentioned earlier that a more robust solution would be to create this as a logical column in rpd.

Hi @user1636556 I just remembered some new functionality introduced in OBIEE 12c, you could use the Column Save As functionality: Which you can then access in other Analyses from here:

I'm not quite clear on Row 3 in your example. Also, what is it that you're not able to achieve?

I'm not sure you can do this unless you create the column in your repository with the CASE statement and name the column accordingly. Sent from my iPhone

Could you provide a screenshot as the URL column property that you mentioned is how it should be done.

So what has changed?

Could you try refreshing user GUIDs to see if this resolves the connection issues you seem to be facing?

Can you search for OPMN.log file and post any errors from it here?

Hi @1055274 Have you taken a look at this?

Let us know how you get on.

Is your connection pool using the same user that you connected to your Netezza DB to execute the SQL successfully? If the user is different, you'll need to prefix the GROUP_CONCAT function with the user. For example: USER1.GROUP_CONCAT

Try this

There are a few more steps required to modify the OBIEE instance to point to new database. Take a look at this

Have you tried looking at this?

As everyone else has said, lots of practice will prevent the occurrence of these type of issues. I don't believe there is a way that you can "get back" your repository. Have you looked at the Rpd to see if it is something you can fix?

Are you using ODBC or OCI in your connection pool? Do these work on server in terms of connecting to your underlying database?

As @Gianni Ceresa mentioned, it depends on whether @user13697368 is referring to OBIEE 11g or OBIEE 12c. User GUIDs don't exist in OBIEE 12c. Could you provide some more information like screenshots, log files( sawnlog.log, nqserver.log), OBIEE version numbers etc if you want to get some help from this forum

Something like this should do the trick: EVALUATE_AGGR('LISTAGG(%1,%2) WITHIN GROUP (ORDER BY %3 DESC)',OBIEETableName.OBIEEColumnName,';',OBIEETableName.OBIEEColumnName)

Hi @Wolfrm If you have access to call Oracle Analytic functions via EVALUATE, you could try using LISTAGG

You could also take a look at this Oracle document that describes in detail how @Gianni Ceresa suggested that you implement your requirement If for instance you want to pass parameters (prompts) from your dashboard to your BI Publisher report.