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.

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

Column level SQL filters is much needed in workbook. It is a good option in OBIEE classic. New parameter binding option works similar to it but it is limited to 1000 values. If limit is more than 1000 , so it is not working fully to replace the existing SQL which is dynamic. I have raised this to Product management. They…

@Gabby Rubin-Oracle I can understand the performance issue. Probably you can think of providing proprieties options. By default off for all. Usually we don't need this option for all columns for few columns require.

@Mostafa Morsy-Oracle Sum aggregations is always an issue. Need different calculation or aggregation based on context. I am able to get what i want with UI Aggregation method. Only issue is these options not available in Overalay charts. Still I am not clear in concepts in calculations for below. If you have any examples…