@Subhakara Netala-Oracle Hi, look, pls at Idea, I have created in September 2021: (still in Submitted status - so without attention of Product Development so far) This idea is requiring exactly the same as yours. So pls, drop your Idea and vote for this one - to have synergy and more votes collected. You can add your…

@Philippe ROGIERS-Oracle Hi Philippe, look pls, at following Ideas: both created by me (one is pretty old one). I think, that what you are requiring in this Idea is "subset" of what is in Ideas above. So pls - for synergy - vote for my Ideas - this will give better chance to be implemented. Thanks and regards Michal

Basic functionality for governance/admin which is missing. Calling for those for more than 2 years (it should be part of API, which must be available not only in OAC, but in OAS as well).

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