No Join in Tables
I have two isolated tabels in my universe design like below as its business layer separately.
At report level, iam trying to have Fiscal Year/period (Selection Options) as common query filter by having same prompt text, where iam trying to search value, at any point of time only delhi conn prompt LOV is apearing. Basically i want LOV's as union of both.
Appreciate your help.
Amit Kumar replied
no impact on the data. assigning custom LOV's are only limited with the display of LOV's in the prompt.with the custom lov's you can see all the values in the prompt list and the value you select in the prompt based on that you will get the data from two queries.
let say if you select prompt value from LOV's 010.2015 then same value pass in the Delhi and Mumbai queries.if values are not present in the Mumbai query for 010.2015 then you will not get the data.