Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 40 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 18 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
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.
Best Answer
-
@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!
0
Answers
-
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.
0 -
Thanks for the update!
0