I have got a requirement to write a report. I pull 5 columns from the universe. One of them is a due date column. I should let the user enter 2 parameters Effective Date and Age days. These two (effective date and age days) do not exists as objects in the universe nor they exists in tables to be added to universe.
Once the user enters these two parameters i’ve to take the User entered effective date and subtract from due date object and get the age days. Whatever user enters as age days parameter must match my calcuated age days and i should display only those records.
How can i accomplish this task? How do i create dummy variables in universe? How can i accept user response and bring into report selection?
thanks
supersundar (BOB member since 2007-03-01)
What is you database ?
You don’t need dummy variables but simply a pre-defined condition where you create the appropriate filter:
It should look like this
Due Date = Prompt (effective date) - prompt(Age Days)
Marc Doucet 
(BOB member since 2007-07-11)
Can anybody tell me how to create a dummy variable in xi universe?
what must be its select clause and where clause?
is it recommended to have dummy object as dimension or prompt?
Thanks,
Raja
rajeeva 
(BOB member since 2009-04-26)
Please check this topic for standalone prompt concept.
If we want to prompt the user to enter a value (if we have nothing in our db related to it), I think that is the only way to go for.
Jansi 
(BOB member since 2008-05-12)
Other way i can think of is create a derived table with the values that you want to prompt for
e.g the follwoing can be your derived table query
select “IL” as PROD_CODE from dual
UNION
Select “BL” as PROD_CODE from dual
UNION
Select “KL” as PROD_CODE from dual
and then create a prompt for PROD_CODE as LOV
Hope this helps
Thanks
Siddhartha
siddhartha.dubey (BOB member since 2006-09-13)