Also, do you get the same performance issue when you run the SQL directly on the OBIEE server using SQL*Plus?

Did you run the RCU utility to create the schemes on the new database? Although this article applies to Oracle, the steps should be the same for SQL Server I believe. Document 2177562.1 OBIEE 12c: How To Change Your OBIEE Connections When You Have Moved Your RCU Database To A New Host View in My Oracle Support Full Site:…

You've got a duplicate thread - and @Gianni Ceresa has answered your question about BMM layer & Presentation layer modelling there.

Under your Database > Physical Schema in the physical layer, you just need to create a Physical Table and in its properties , under the General tab, change the Table Type to Select. Paste your SQL into the window, you may have to manually create the columns in the Columns tab and that should be it.

quickest way to validate the XML is to open the instanceconfig.xml file in a web browser. If you can see the XML, then it's well formed.

Right Click on the Database icon and click on copy then paste in your text editor of choice and you should get output (just an excerpt) similar to this: DECLARE DATABASE "DBName" AS "DBName" TYPE Oracle11gFEATURES ('LEFT_OUTER_JOIN_SUPPORTED' = 'Yes','RIGHT_OUTER_JOIN_SUPPORTED' = 'Yes','FULL_OUTER_JOIN_SUPPORTED' =…

To add some detail to @Christian Berg, you'll have to do this transformation in your ETL process ideally (or in an Opaque view - not ideal though) using some sort of PIVOT function to transpose your rows to columns (you didn't mention your data source). If it's Oracle, then this might be of help -…

+1

Have you looked at @Gianni Ceresa's blog posts on customising OBIEE styles 7 skins? https://gianniceresa.com/2017/02/obiee-12c-custom-style-using-shared-folder/ https://gianniceresa.com/2016/12/obiee-12c-custom-style-ear-file/

Have you checked the XML syntax of your updated instanceconfig.xml file?Is it well-formed? As @Gianni Ceresa said, check your log files as well.

probably, yes but you need to restart the whole stack not just the node manager. Also, either you change the node manager port or you get rid of whatever it is that is conflicting with its port or change that to use another port. As mentioned previously, you need to resolve both issues...

I'll avoid that one as well from now. I don't want any copyright infringements

what have you checked so far? Have you compared the log file for execution of these analyses run as Admin users and the BIAuthor users? Does the query in the nqQuery log file look the same? You haven't mentioned OBIEE version, OS etc as well...

Short answer is no. One instance per Rpd. What is your use case?

That's your call. You need to verify that a port is free and use the free port If you're on Linux, you can use a command like this one: netstat -tunlep | grep LISTEN | awk '{print $4}' to get a list of used ports so you can safely use one not in the list the command provides.

https://docs.oracle.com/middleware/1221/core/ASADM/ports.htm#ASADM030

2 things here: you have a port conflict issue and you just mentioned that your LDAP account is locked. It looks like you've answered your own question, once you sort these 2 issues out, your OBIEE instance will be back up and running...

Have you looked at any logs for guidance? Which version ? Which OS?

1st thing would be to change it to Oracle OCI instead of ODBC.