Parameters can be users presentation variables.

Very much needed enhancement.

Needed enhancement.

Same issue we are facing with simple datasets. Dataflow architecture is very bad. Every updates we are getting issues. Dataflows running over year is failing and support team pointing some documents and saying working as expected. We are fed up with regression and new techniques to use everytime.

you can use Parameters for filters.

I vote for it. It is hard to manage.

@Bret Grinslade - Oracle Analytics-Oracle Currently if reload data , it just reloads if all columns are matches. In Edit definition, we can upload with different columns. It works fine. Expectation is that it should show , new columns are adding and old columns deleting warning. So that user will know what is missing and…

Got it Avinash. Thanks for clarification.

I have played around it. After reviewing Logical SQL i found answer. Solution is

@Mike Durran-Oracle UX should be simple and easy to navigate. For everything creating parameter and use parameter is cumbersome to create and manage it. If you suggest as temporary workaround is good but idea should be considered worth.

@Jorge Olmeda Do you have any quick example. I am unable to reproduce now.

@Kees Sint Nicolaas It is working fine. Try with Net Sales @parameter("par_estimate")('')

@Manish Wadhawan Currently you can set border colors and style format. I vote for alternate color which is a already in OBIEE and missing in OAC.

@Avinash Krishnaram-Oracle We used to rename & Format the Grand Total header name for better visibility and self explainable. Very rare case , we renamed Sub Totals. But we should have font format option for Sub Totals of each column. For example if the table you mentioned , If we have Product column , then we should have…

OBIEE too having the option of table and Visualizations.

We do have typical scenario. I am using Role based filters. I think current Dataset Role based filters serves the purpose. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/role-based-filters.html

@Avinash Krishnaram-Oracle What is the solution for now. I can't use Parameters and we don't have option of column level SQL filter. Current my query output is with 1279 unique email ids which is beyond 1000 limit. Surprisingly , you reply is marked as "Best Answer" and status of question is marked as "Answer Accepted".…

Thanks @Federico Venturin It works. In I have not used Logical SQL parameter select MIN(Date) from <Dataset/Subject area> where Date >= CURRENT_DATE and used Initial Value as "First Available" and bind to table filters.

@SteveF-Oracle Before September 2023 update @Avinash Krishnaram-Oracle informed us about increase of limit. But never happened. Regarding use case: We have different use cases. We have multiple products and multiple supported versions. One bug required to fix in multiple products as well as multiple versions. For example…

Thanks @SteveF-Oracle For sure your suggestions help. I will play around. Meantime, I used Dataflow with Aggregate function. This seems to be working. I am validating. Honestly I am more interested in calculation within workbook. With your ideas , i will explore little more and find out best practices.