@Gianni Ceresa There is a typo in GHI contract end date. I have corrected it. I can easily create calculation for monthly amount. Logic is simple and easy. My business logic is how much we are spending in each month on all contracts. Contract period varying from 1 month to 5 years. Appreciated if you provide some syntax or…

Customer_Name IN (@parameter(pv_customername)('') - Will provide parameter values as a default value. Customer_Name IN (@parameter(pv_customername)(Customer_Name) - Will provide the value you mentioned irrespective of parameter value.

Thank you @Avinash Krishnaram-Oracle for quick reply and action. It will help.

@FrazerP User needs to manually set the default stage for each workbook to "Original State". States →Manage states @Avinash Krishnaram-Oracle As we discussed earlier, it is very much confusing to users and almost all users are getting confused with this. Also manually set the state for each workbook by each user is not…

You can do it in two ways. Using Parameter Binding. Bind your list filters with Current Date Parameter. Using Expression date filter XXX_Date = Current_Date

I am able to solve for change of employees between months. Yet find solution on another conditions. Here is the Parameter created and bind to employees UID. SELECT XSA('xxx@abc.com'.'Capacity Reports')."Columns"."Emp UID" s_1 FROM XSA('xxx@abc.com'.'Capacity Reports') WHERE (("Columns"."Emp UID" IN ( SELECT saw_0 FROM…

@BalagurunathanBagavathy-Oracle @Gianni Ceresa Thanks for immediate reply. Actually, I want to do it dynamically list the employees based on two months selections. So, It should be done workbook. After doing some experiments, almost got a solution through using Parameters with logical queries. Hopefully it will work. Keep…

@Avinash Krishnaram-Oracle Parameters backend search results increased to 10000 but binding values and output resultset is still 1000 only. This is the limitation of list filters causing problem. I am playing with Expression filters to achieve my requirements.

@BalagurunathanBagavathy-Oracle Parameter will serve the purpose the use case explained in this example but parameter have limitation of fetching 1000 users . Due to this I am unable to use Parameters. Actually my use case is little more complex. I have 4000+ employees working on different product in each month. I need…

@BalagurunathanBagavathy-Oracle Expectation is as below. Emp ID Jan-25 May-25 9060 Yes No 99122 No Yes

Filter using SQL expression which allowed to use SQL Queries in classic is most useful feature when we deal with complex filters. Newly enhanced parameters works similar to it but it has limitation of values output in binding. @Gabby Rubin-Oracle @Avinash Krishnaram-Oracle Appreciated if you consider this useful SQL…

It is Oracle Analytics Cloud.

@Avinash Krishnaram-Oracle @Gabby Rubin-Oracle We badly need to increase of display values of Parameters results or need solution of SQL expression filters. In OBIEE Classic , it is easy to filter the data through SQL expressions which is missing in OAC . Currently we are using logical expression through parameters. But…

This is much awaited feature and it is commonly used by consumers in OBIEE

Excellent idea. It is excellent one for present.

One more feature which exists in OBIEE classic and missing in OAC DV.

it is already available in OAC. If you are using server, you will see it in next upgrade.

Two options. Create a column using calculations if timestamp1 = timestamp2 as yes else no. Use this value in Viz to highlight. In classic we can achieve using conditional formatting directly but OAC conditional formatting is not as good as Classic OBIEE.

Thanks for suggestion. I have reported a Idea Consumer should allow to export the complete Viz through custom settings. — Oracle Analytics

Buttons functionality and Bookmarks management is available in Qlik. It is very much useful.