@Jahnavi-Oracle No, unfortunately this is not possible to "migrate" just data set (or couple of data sets) separately. The only way is to create "dummy" DV workbook, in which you include all data sets you want to migrate between environments and then export it via DVA package (which will include definitions of all data…

I think, that what you are looking for, are features called Calculated Items and Groups (https://docs.oracle.com/en/middleware/bi/analytics-server/user-oas/manipulate-members-groups-and-calculated-items.html) - which are available in "Classics" (you can define them in Answers). We (as customer) are missing similar feature…

Let me jump into discussion with my personal experience: "Integration" between dashboard prompt and embedded DV workbook on dashboard is very limited 1) filter values from dashboard prompt are always passed to DV workbook using equal condition (so forget other type of comparisons) 2) Presentation variables (set at…

@Gianni Ceresa Gianni, could you, pls, share, Bug No for this (if it is a published Bug) ? Thanks

Good motivation to create new Idea for this feature.

Hi @Amrita Gupta-Oracle , no this "feature" is not available in DV (for pivot table viz). I have already created Idea in Idea Lab (asking for inclusion): https://community.oracle.com/customerconnect/discussion/631392/make-calculated-items-groups-features-available-in-dv , so you can vote for this idea (to gain attention by…

So far, if I omit standard OAC documentation set , where is a book, dealing with Semantic Modeler: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acmdg/index.html and couple of blogs , describing first expierience with Semantic Modeller (like…

@Gianni Ceresa Good to know, that gool old analytics Webservices are working in cloud (OAC) as well...

Not sure, you have to ask Oracle Product Mgmt. But I would guess, that it is only available in on-prem, thus OAS (we are OAS customer and we are using this Web Service API).

Apologize for not having better answer :-(. Alternatively (but with significant effort) you could use WebService API for "good old" tradional UI (/analytics): https://docs.oracle.com/middleware/12213/biee/BIEIT/index.html - which has WebCatalogService and one of tis method is readObjects() - returning XML definition of BI…

Use Catalog Manager report for that purpose (for dashboard object) - it will give you, what you are looking for.

If you are OAC customer (I assume, this is your case), you can extract offline version of BI catalog from BAR archive and then you can a kind of automate traversing directory (offline BI catalog hase real directory structure on file system) and finding DV workbook definitions (under DV workbook folder there is file with…

As far as I know, OAC/OAS does not offer such functionality (for "classical" analysis, you could use "report" in Catalog Manager, listing columns used in analysis). You could possibly "parse" JSON definition of DV workbook, but this would require manual tasks, it is not something which you can automate. In my opinion, this…

@ANGEL SHIPP Amrita has been asking about embeding into classical Dashboard and what you are refering is embeding into web application via java scripts/HTML tags.

Pretty obsolete video , I would not rely on it at all.....

As far as I know, when embedding DV workbook (or more precisely canvas of DV workbook) into classical interactive dashboard, there are some limitations connected with "interactivity" of embedded DV canvas: * Data actions are not available * Conditional formatting is not available * Adding advanced analytics (forecast,…

There is no choice but to agree with everything, what Gianni summarized in previous entry - data governance/administration of DV objects is still very limited/clumsy and it is one of the biggest weakness of DV (as part of OAC/OAS suite) as such (although product as such is developing quite heavily and many improvements are…

@Jean-Pierre Hoedenaeken I guess you need to be "located", when making import, (in BI catalog structure) in folder, where you want to import this DVA archive (containing whole folder) and it should work. Just to maje it clear: DVA package/archive created from BI catalog folder contains only those DV objects (data sets,…

Do you mean on "target" environment, where you are about to import/restore DVA package ? If this is what you mean by your question, than no - import of DVA package also "restores" the definition of corresponding connection (used by data sets in DVA package).

@Jean-Pierre Hoedenaeken The only possibility (not very handy) is to backup individual data sets via DVA package (export of DV workbook) - this is meant for backup of DV workbook, but this backup (DVA binary file) - contains also all data sets, used by this DV workbook - their definitions, for file-based data sets also the…