Dilek, it seems to be quite "messy" with lot of places where things happen… For example, when I reload a dataset based on a query, what seems to be giving me some useful information is looking in W_ETL_RUN_OBJ by using the object_id column, and from there taking the run_wid column value to query W_ETL_LOG with obj_wid…

Hi, I didn't check these details directly because didn't have a need so far. Assuming your RCU schemas are on an Oracle database, you could enable audit logging for those schemas (just BIPLATFORM should be enough, the other schemas are supposed to be for other things) and you will be able to see what happen when you…

This is typically one of the issues I have with the BAR import behaviour: full replacement, no way to merge things. Merging would be a valid option for the security. Because of this every upgrade from OBIEE to OAS results in missing policies. This is why what I now do is to never import security from BAR files, but instead…

Hi, Did you import and override the security of your OAS? If you did, you "lost" the privileges required to access the semantic modeler, because those didn't exist in your old OBIEE security model. You need to grant your admin role the lost policies again to have access to it. If you check MOS (or even the upgrade doc I…

Ok, so this depends on what OTBI provides… (I don't have OTBI, all I know is that it is a kind of "old" OBIEE with a number of pre-built subject area for you to use). Can you check the WSDL of OTBI (the OBIEE part, not Publisher) to check if the WebCatalogService service has the copyItem2() and pasteItem2() methods? These…

Once you found or created the idea, post back the link in here: it could drive some extra up-votes :)

With the WebCatalogService you can get the XML of any object, including analyses (I used it a lot to read every single catalog object in the past, analyses, dashboards, filters, agents etc.). What product (name and version) are you using? Is the "Analyses" the "classic" analysis (not DV, not Publisher)? What methods did…

At some point there was a feedback space in the Cloud Customer Connect forum, but I don't know if it's still there and where. Somehow there should be a place for feedbacks there. As it is fully independent from here, managed by different people, you should try to find a way to post that feedback in Cloud Customer Connect.…

Hi, Welcome to the Oracle Analytics community and forum. Your question is about BICC and some PVOs in there. Both aren't Oracle Analytics products. BICC is a Fusion product, and the PVOs are related to Fusion products and their data. These products are covered in a parallel, and independent forum: In there you can see lot…

Hi, The historical SOAP webservice includes one for the catalog that has methods to download objects from the catalog. Or even just get an object content (the XML of the object). Look at the WebCatalogService methods. It comes with a WSDL, any SOAP client should be able to generate the required code for a request based on…

This being the Oracle Analytics forum, it doesn't cover Fusion PL/SQL packages. And there are also not standard reports in OAC/OAS: both products are empty, you define reports, workbooks, analyses as you want, but there is nothing "standard". If you are using FDI, the question can be moved to appropriate category. If you…

Hi @C Hammond , Welcome to the Oracle Analytics community and forum ! While not having access to an OTBI right now to check, I'm quite sure that there aren't more features than what OBIEE/OAS has from that point of view. If you have access to the analysis XML code, yes. Because all the properties of each columns are…

Peter, Please do not double post. It's a unique forum, double posting in multiple categories is not going to help you much, but will leave around lot of abandoned threads. Closing this one, keep replying to the other one:

How dare you!! 😯 I love my server, with full access to everything, mostly the BIPLATFORM database schema that let me do all I need without bothering finding an official tool or process :D But I'm with you for patching and other "boring" tasks.

The topic has already been raised with product management. Mostly when trying to define a valid deployment process in an enterprise environment. That's how I had the chance to discuss it a bit with PMs and have a first hint of what was coming with the move of DV objects to the catalog. It was a while ago already, but the…

I saw that behaviour, and it was driving me crazy: I have the option to include or exclude something, but whatever I do I have that connection following me and bothering me in the new environment. That is what killed my trust in the DVA concept overall. That thing is too much of a black box for me, and so far I blamed the…

Please do not double post. Closing this one as the other one got a reply…

Hi, What product (name, OAS or OAC, and version) are you using? And what does "large" mean in your case? How many columns and rows approximatively? Thanks :)

Hi, My first question would be: does your RPD have any error or warning? Can you fix those? Over the various releases, from OBIEE to OAS, the system has become a bit more strict in how things should be modelled, trying to be more predictable on how it will behave based on your model. What concerns me a bit in your…

Hi, The catalog archive/unarchive is a catalog operation, not something that is "owned" by publisher but a feature of the catalog used by Oracle Analytics (shared with Oracle Analytics Server, Cloud etc.). The file you get, is a binary file that is compressed in an undocumented way that isn't designed to be manipulated by…