Good idea, immediately voting for it- basically bringing rename column wizard, available in BI Administration Tool (and hopefully available in Semantic Modeler as well....) to self-service data set world.

Bret, nothing against discussion. But from your answer it seems, that you have not get the logic behind the report and especially complexity of query and numerous places in query, where “parameters” are passed. If you think, that you can somehow make it simplier and transform it into logical sql, i am more than curious.

@Gabby Rubin-Oracle Hi Gabby, I am opening again discussion within this Idea (which has been set to Delivered status). But there are new facts, which force me to open it again: Quite recently new release of OAS for 2023 has been launched and I was desperately looking in What’s New for Oracle Analytics Server' document…

@Bret Grinslade - Oracle Analytics-Oracle Hi Bret, not this will not work - reason is following: Physical SQL for particular report is realy very complex and cannot be rewritten into logical SQL - I am attaching real example of physical SQL, which we are using in physical layer in metadata (table definition using SQL) In…

@Gianni Ceresa I agree - if Product Management has strategy to "move" customers from "Classics" to DV, than part of this strategy must be plan to bring (in reasonable timeframe) features, which has been build in "Classics" (for 15+ years) also in DV. Unfortunately this is happening very slowly, since main focus is on…

I think you can leverage feature defined in metadata called Descriptor Id column (you define for "descriptive" logical column in BMM his "code" counterpart -Descriptor ID column. And if you have this descriptive column in dashboard prompt, then Id column value is passed to analysis as filter (see…

@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.