Sherry, I will test this later, but I feel sure this is the correct answer. And since you posted it first, you get the 'Correct Answer' credit.

Oops. Nevermind. Although I started to just delete the post, I figured I might as well contribute the solution. Make sure there isn't an extra blank space in front of the email address in the FMC configuration.

Yup. Reminds me of a classic line from the 1976 movie 'All the President's Men': "Follow the money."

Thanks, Gianni. Good answer. I understand the theory. Still, in practice, it seems to me that if there is an enhanced version of OBIEE that they can (and do) unzip and install on their machine "A", it should be possible to make it available for us to download and install on our machine "B". If the software is good enough…

Perfect. Thanks, Gianni!

No sweat, bro. I just filled in the little details. Knowing which highway to travel is the big thing!

Thank you, Christian. FYI to others, as Christian indicated, navigate to Services => Data Sources. On the Summary of JDBC Data Sources page, click any entry under the Name column in the displayed table. Then click the Configuration tab and the Connection Pool subtab. I found the reference to the RCU schema in the…

Thank you, Sherry. Severity2 - Severe Loss of ServiceProduct Version11.1.1.7.0Status84 - Closed, not feasible to fix Status = Closed, not feasible to fix. "It doesn't work, we know it doesn't work, and we don't intend to fix it." Nice.

Yup, tried that too. I can manually delete it if it is there, and I have done so. I have even deleted it after clicking 'Apply' and just prior to clicking 'Activate Changes'. The click on 'Activate Changes' then creates it, and two minutes later, after fussing about "the file is locked" it throws the error.

Yup, I did all of that. Many times. After the failure, I released the configuration, restarted the machine. Everything restarts just fine with the old RPD, as you noted it should. But then attempting to deploy a new RPD throws the same error. It won't update nqsconfig.ini. I must have tried this a dozen times. Whatever is…

How do I do that? I tried deleting the file, but it is (of course) locked by the bi_server1 process, so I can't delete it. Is there a command to release the lock?

More information: The file that is apparently locked, as noted in the error message above, is c:\{mwhome}\user_projects\domains\bifoundation_domain\config\fmsconfig\biee-config.lock. But it is the very act of clicking 'Activate Changes' that creates that file. So it appears that the process that is complaining about the…

This has become a very interesting, and I hope very useful, thread for others to reference. After reviewing the excellent information from Mark Rittman's team, it appears that the answer to my question is that we cannot use OBIEE to set permissions or to delete the uploaded Excel-based datasets, although we may be able to…

Do you know if there are any thoughts of EVER making the blended mashup data sets available for use outside of VA?

Thank you, Gianni. I understand more clearly now. I have now uploaded an Excel file called strategy327 for use in a VA project. Upon saving that project under My Folders, and after signing out / signing in to Analytics, I can see the strategy327 data source available for selection under New...Analysis. I can also see it…

Christian, I hate to appear to be dense, but I'm having trouble figuring out how to do what you are showing me. I'm working in OBIEE 12.2.1.2.0. My goal is to use VA to create a mashup dataset using columns from an OBIEE subject area plus related information from an Excel spreadsheet. I can create that dataset as part of a…

Ping. As far as I know, it is not possible (currently) to use the data mashup datasets from Visual Analyzer anywhere else (e.g. Answers, BI Publisher). Is that correct? And is anyone aware of any plans to create that type of interactivity between the different portions of the OBIEE product suite?

Don't you just hate it when you do something uber-dumb? I was using that very same Oracle document (or a close sibling) and I simply stopped scrolling down, otherwise I would have seen exactly what you suggested. Brain damage. Loaded with it. Thanks again, Sherry.

AH-HAH!!! You are absolutely correct - wrong place indeed. Thank you!

I believe I figured out an answer - and it was totally by accident and totally unexpected. Here are the very simple steps that you can follow to create a subtemplate that will not return extra, unwanted blank rows. Main template: Here are the contents of the fields in the main template: One additional observation: I have…