Oracle Communities

Oracle Analytics and AI

Child Item

ToDate() function fails.

I am trying to use the ToDate() function in an FDI workbook to get: TODATE(Gross Sales, year). I am getting this error while trying to create the calculation:

Internal Assertion: Condition levelExprPtr.get(). file server/Query/Optimizer/ServiceInterfaceMgr/Utility/SQOIUMetadataConverter.cpp. line 6568.

I am also having trouble using the AGO() function. The calculation validates, but the query errors out.

Any help appreciated.

Find more posts tagged with

FDI

Accepted answers

RVohra

@Paul Therrien , Welcome to the Oracle Analytics Community!

Can you confirm if it is a date aware measure, it should directly come from the fact and not be calculated / derived KPI.

Alternatively, see if FILTER can be used instead of TODATE

FILTER(
"Gross Sales",
"Calendar Date" >= TIMESTAMPADD(SQL_TSI_YEAR, 0, CURRENT_DATE)
)

Hope it helps!

All comments

RVohra

@Paul Therrien , Welcome to the Oracle Analytics Community!

Can you confirm if it is a date aware measure, it should directly come from the fact and not be calculated / derived KPI.

Alternatively, see if FILTER can be used instead of TODATE

FILTER(
"Gross Sales",
"Calendar Date" >= TIMESTAMPADD(SQL_TSI_YEAR, 0, CURRENT_DATE)
)

Hope it helps!

Paul Therrien

I am retyping my response to RVohra, because I do not see that my response was saved. So I apologize if this response is a duplicate.

RVohra,

Thanks for the feedback. I do not know how to confirm that the measure is data aware. We are working with a 3rd party that has created this subject area. I also had an issue working with the AGO() function with this same measure and they are working on fixing this, so the indication is that there is a configuration issue in the subject area that needs to be addressed.

Thanks for the FILTER() function alternative. I think this will come in handy for other calculations.

RVohra

Thanks for the update!