Oracle got back to me and it is a known bug after all. Thanks for your suggestion though, I will try comparing XML and see if there is a tag causing this somewhere.

It's not the normal logical SQL..if you take the SQL from the presentation layer that it is sending to the BI server, this SQL doesn't work. 

Yes i saw where you can limit drill down to a specific level, but with an unbalanced heirarchy this wouldn't work. We will probably have to make modifications to the cube. Thanks

I have checked the same repository between the 11g instance (getting the descendant error) and 12c. Instead of the error in 12c, we get the "no results" screen which is correct, since that level would have no more data under it. However, is there a way in OBIEE to not have the link for further drill-down once it has…

That's how it was imported by default into the OBIEE repository. I unchecked ragged, but it doesn't seem to have any effect. Still the same error.

It's unbalanced "department" dimension. In some areas it can go 8 levels deep, other areas only 3. 

Yes I have this configured successfully running as a task. The trick is that under "Actions" for your task, you need to specify the directory for start.cmd in the "Start in (optional):" box. Put your directory to DOMAIN_HOME\bitools\bin there, and only specify "start.cmd" in the "Program/Script:" box. I have the task…

Yes I had all of these set (weblogic 12c docs say customtrustkeystore property is deprecated for 12c and only identity is needed) KeyStores=CustomIdentityAndCustomTrust CustomIdentityAlias=aliasforkeystore CustomIdentityKeyStoreFileName=C:\Certs\\ CustomIdentityKeyStorePassPhrase= CustomIdentityKeyStoreType=jks…

No reported errors in nodemanager.log, it starts up fine using the keystore (and yes i added customidentitykeystore properties to nodemanager.properties) and it reports listening on SSL at correct port

Those links are more about integrating an OBIEE object onto a portal or sharepoint rather than retrieving data from SharePoint. One option may be to use the built-in XML URL from a list on sharepoint, and then use that XML as the XML Gateway data source in OBIEE:…

Thanks..that is my observations as well. Tableau is not really an option as no semantic layer and not a fan of the desktop model. I like the promise of VA, it can use existing subject areas and curated content, but not including at least a basic sharing/export functionality is ridiculous!

I'm not very familiar with the packaged BI Apps, but I believe they operate off Essbase/cubes. Another consideration is that Tableau doesn't integrate very well with cubes..it can't package the data into an extract, and has to work from the server directly. This introduces additional performance and security concerns.

Talked with Oracle support and it turns out this indeed a bug with the RCU in 12c. As of right now, schemas can only be created with the SYS account directly in the RCU or Config assistant. Creating the scripts beforehand and running data load seperately does not work. No timeline for a fix, but development is aware of the…