cancel
Showing results for 
Search instead for 
Did you mean: 

Need help/suggestion in creating a prompt object

Former Member
0 Kudos

Hi,

I need to create a date field to use as prompt in WebI report using the below logic

Tables: Dimension, Stock

Joined on StockID with 1-->N mapping

Logic:

Select Dimension.StartDate where Start date IS NOT NULL

Else Stock.CreatedDate from Stock when Dimension.Flag = 'T'

Note: One more complication is that Dimension and Stock tables are not at the same granularity, Dimension table is summarized and Stock table is detailed

Any help is highly appreciated

Environment: Oracle 11g, BO 4.0 SP04, Universe is built as .UNV in UDT

Thanks,

Mitch

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Select Dimension.StartDate where Start date IS NOT NULL

Else Stock.CreatedDate from Stock when Dimension.Flag = 'T'

Try this formula

Case

When Dimension.StartDate IS NOT NULL

Then Dimension.StartDate

When ( Dimension.Flag = 'T' )

Then Stock.CreatedDate

Else <anyotherdate or other condition>

End

Former Member
0 Kudos

Thanks for your answer Nikhil


I heard that, in IDT, we can write custom SQL for getting Dynamic LOV's. Is this method possible in UDT as well


Asking this because the 2 table related in this logic are at different granularity and it is advised to me to, group by lower granularity table condition and use it with other table

Answers (0)