Migrating function from Obiee to Quicksight

I am not really familiar with Obiee but you can see all the Quicksight functions here: https://docs.aws.amazon.com/quicksight/latest/user/functions-by-category.html There might not be exact replacements and the implementation and syntax may vary so looking at our documentation and exploring available functions is the way to go.

That being said, looking quickly at the Obiee doc and our Quicksight doc... here is what I would try:

1. AGO: try PRE_AGGREGATE function combined with date filtering. For example:

PRE_AGGREGATE(SUM({purchases}), [Date], [Date]-N, [Date]-M)

2. TODATE: PARSE_DATE('yyyy-MM-dd', '2023-07-11')
3. PERIODROLLING: periodOverPeriodDifference - https://docs.aws.amazon.com/quicksight/latest/user/periodOverPeriodDifference-function.html
4. CAST: https://docs.aws.amazon.com/quicksight/latest/user/changing-a-field-data-type.html
5. VALUEOF: not sure there is an equivalent for this but Quicksight supports parameters to pass values dynamically to the analysis (can be assigned to dataset or analysis level)
6. EVALUATE: Can you use common functions like SUM, AVG, MAX, MIN, and IFNULL, ....? Some details in this blog post might prove useful: https://aws.amazon.com/blogs/big-data/calculated-fields-level-aware-aggregations-and-evaluation-order-in-amazon-quicksight/
7. INDEXCOL: In QuickSight, you can reference columns by their names directly in calculations, without the need for an explicit INDEXCOL function

I also suggest to ask for guidance in our Quicksight community website: https://community.amazonquicksight.com/ if needed.

If this response helps, please Accept this response as answer.