so what you're saying is that I should definitely do it? Only joking... You've scared me off enough to do it manually. Thanks for the hypothetical solution though. Appreciate it Christian.

ooooo this is exciting... I like to live dangerously Hypothetically, if someone was to do this, what could they do?

I ended up giving up and just using the datamodel.cmd downloadrpd/uploadrpd process in the same automation stream. Working great now... Just needed that extra step.

Update: Tried importing BAR file, restarting, then using updateConnectionpool and reloading metadata. Still doesn't work. No password is saved in the connection pools. Does this process write to any log file?

Love your work as always Christian

Not sure if you've seen this but might be relevant.ORA-12504: TNS:listener was not given the SID in CONNECT_DATA

Joel, do you know whether Oracle has given any indication as to when 12c might become unsupported?

Apologies if I misunderstand what you're trying to do but can't you just create an extra column in your analysis which groups up the machines into your categories and then just prompt on that new column? EDIT: You don't even need to display that calculated column. Just create it as a filter using a case/if expression.…

Do you have to restart OBIEE after a BAR migration? I wasn't sure. So automation process should be: 1. Export BAR 2. Export connection.json 3. Import BAR 4. Restart destination application 5. Import connection.json Would you need to restart a 2nd time after the connection import?

"export_service_instance.cmd ssi barfilename.bar" to export.

I used "importarchive.cmd ssi barfilename.bar encryptionpassword=password" to import.

Note: I'm using Windows so using datamodel.cmd Note2: The json file contains the encrypted passwords after exporting

These are the steps I followed: 1. Exported BAR file from Prod 2. Exported connectionpool information using listConnectionpools 3. Imported BAR file into DR 4. Imported connectionpool information using updateConnectionpools After step 3, the RPD has no username/password/db info etc. After step 4, the RPD has username and…

I'm as surprised as you are!!! Writing to SSD too. I think you underestimate the horrible design of this report

Ended up working this out. It turned out to be that our 12c environment was, for some unknown reason, logging as if it was set to a loglevel of 5 even though in the RPD options, it specified a loglevel of 2. Overriding with a session variable got rid of 208 seconds of overhead!

Thanks Christian. 10 years ago, the business pressured us to build a report that I knew would come back and bite us on the butt. It seems today's the day that's happened. Unfortunately, it's used by 300+ users per day and is, by far, the most used dashboard we have. This is going to be fun to explain to the manager in the…

982332 wrote: If you are looking to populate Report Date to the last record then have a calculated column CASE WHEN Date_Dim.Date = Reported_Date THEN Reported_Date ELSE NULL ENDCalender DateProcedure DateReport DateProcedure numberCalCulated_Column1/1/20191/1/20195/1/2019123456 2/1/20191/1/20195/1/2019123456…

I doubt you'll be able to do it if you don't have the ability to change the way the semantic layer is created. We'd also probably need to know whether the fields you've listed come from a single table or multiple. For example, if one table had a date for every day and your second table just had a few dates, then all you…

Probably heaps of different ways you could do this but if it were me, i'd be using a narrative view with custom html. https://docs.oracle.com/cd/E12096_01/books/AnyUser/NarrativeView.html

Ended up fixing this issue by setting weblogic plugin to "yes" in the weblogic console bi_cluster settings. Not sure how this fixed it but I'm not complaining.