@Subhakara Netala-Oracle Pls, look at Idea, I have created in June 2020 (now in "Under Oracle Review" status): https://community.oracle.com/products/oracleanalytics/discussion/10008/ability-to-easily-change-connection-assigned-to-external-database-data-set-in-dv . It deals with very similar topic as yours, so pls, vote for…

OK, standard OAS documentation - thanks.

@Shantaram-Oracle Can you, pls, instead of pasting picture with table of diagnostic tools share URL for original resource of this info ? Thnks.

@Jean-Pierre Hoedenaeken Hi Jean-Pierre, I have created similar Idea to yours recently - see: https://community.oracle.com/products/oracleanalytics/discussion/18803/dv-parameters-usage-reference-in-data-set-definition-reference-in-physical-sql-definition. So I would kindly ask you(for synergy and more votes) to vote for…

Question to Product Mgmt: According to the referred blog this functionality is only available for OAC - what about OAS, is there a plan to implement this functionality as well ?

Question to Product Mgmt: How this will be solved/delivered for OAS ? From referenced blog, this auditing functionality is solely available for OAC. Thanks

@Alan Lee - Oracle-Oracle .Hi Alan, looking forward for better way to migrate DV objects between environments. Current status via DVA package is very very limiting. What I would suggest as well for improvement (except being able to change/assign different Connection on target environment) is possibility (when chosen) to…

We are again at missing API for DV objects - there are already Idea created for that : https://community.oracle.com/products/oracleanalytics/discussion/9976/api-for-data-visualization-in-oracle-analytics-server-oac Hopefully it will be soon addressed. In OAS, you have to option to query metadata(DV object definition…

Gabby, thanks for explanation, i understand, that parameters are "just at the beginning of their journey" and will be further developed/extended. My idea, I think, falls under first bullet: additional use cases coverage. Anyway, good to have them in OAS 2023 - thanks for that.

@PeregoD In advanced tab of analysis definition, there is Logical SQL refered (passed to BI Server - as execution engine - translating logical SQL into physical SQL statement), it is not physical SQL statement, where you can use hints for forcing execution of physical SQL against Oracle DB - so your requirement does not…

In general, being able in DV to visualize data from graph db (in Oracle 23c it will be nativelly included in relational Db) would be very useful option.

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…