Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
filter with date session variables

3193829
Rank 5 - Community Champion
Hi
I have a date column whose data type is DATETIME, I am using Filter condition in BMM to filter out a dimension with the date session variable but i am getting error "[nQSError: 22024] A comparison is being carried out between non-compatible types.".
my logic is Filter(paint."sales" Using paint.dates = VALUEOF(NQ_SESSION.App_Date_8))
I have duplicated the dates column and made the data type to DATE but it didnot help.
how can the metrics be filtered using date session variable.
Regards,
Kalpana
0
Answers
-
In the analysis, have you tried casting both sides as date?
0