on 01-28-2015 12:10 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.