Comparing User prompt dates

building semantic layer
1

I have an issue with creating DailySales, MTD, YTD, PYTD measures. I think I can do this with @propmts in Select clause of the objects and multiple dataproviders at Web I (4 Queries and Merge dimensions). But I am getting some database syntax errors. Most of the threads in the forum used standatrd date / SYSDATE for comparisons. But I want to capture the User selected date.

Can somebody help me with the Syntax? I tired To_Char and To_Date combinations too. Database is Oracle.

The following doesn’t parse. Error here:

Table.Settle_Date between trunc(@prompt(‘Enter SettledDate:’,‘D’,Mono,Free,Persistent,User:0),‘YYYY’) and trunc(@prompt(‘Enter SettledDate:’,‘D’,Mono,Free,Persistent,User:0) )

shamanth (BOB member since 2007-03-01)

2

Shamanth,

You, already, have a post regarding this, here:-

https://bobj-board.org/t/138596

Mak 1 :uk: (BOB member since 2005-01-06)

3

Closing this topic to avoid a fragmented discussion. Please continue in the linked topic.

Thanks for understanding.

Marek Chladny :slovakia: (BOB member since 2003-11-27)