filter with date session variables — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

filter with date session variables

Received Response
1
Views
1
Comments
3193829
3193829 Rank 5 - Community Champion
edited Aug 13, 2024 6:20PM in Oracle Analytics Cloud and Server

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

Answers