Can I have this variable in universe

building semantic layer
1

Hi ALL,

       I want to have a promt variable in my universe, i created this varibale which is not parsing in universe,i might need to do some functionality changes,pls tell me what i need to do:

This is difference between 2 dates one is predifined promt another is a varibale in universe.
max(case whenTABLE1.COL1 IS NULL then round(@Prompt(‘Enter Date’,‘d’,) - to_date(TABLE1.COL2,‘yyyy/mm/dd’))
when to_date(TABLE1.COL1,‘yyyy/mm/dd’) > @Prompt(‘Enter Date’,‘d’,) then round(@Prompt(‘Enter Date’,‘d’,) - to_date(TABLE1.COL2,‘yyyy/mm/dd’))
when to_date(TAVLE1.COL1,‘yyyy/mm/dd’) < @Prompt(‘Enter Date’,‘d’,) then round(to_date(TABLE1.COL1,‘yyyy/mm/dd’) - to_date(TABLE1.COL2,‘yyyy/mm/dd’)) else to_date(TABLE1.COL1,‘yyyy/mm/dd’) - to_date(TABLE1.COL2,‘yyyy/mm/dd’)
end)+1

madhu@P (BOB member since 2008-08-04)

2

Hi,

Are you creating this Variable in the WHERE Clause of an object?
Or are you trying to create this as a condition.

If you are trying to create it as a separate condition then you need to assign this @prompt to some object

like @select(CLASS/OBJECT) IN @ Prompt

Thanks
Siddhartha

siddhartha.dubey :india: (BOB member since 2006-09-13)

3

Hi Siddharth,
Thank You for the reply, well im trying to create in select statement ,but one of my value has to come from the promt that user enters in report, but i got the solution i need to format the promt to match with the other Date format im using in the querry.

Thanks again,
Madhu.

madhu@P (BOB member since 2008-08-04)