A Hi Naresh, Thanks for Making Fusion Videos,I learn more by seeing your videos and i have one doubt i have INVOICE_AMOUNT Column if data is there in column we have to display if data is not present we have to display like "the data is not found" is there any possible?
@@TechTalkwithNareshthanks for quick response!!! yes we can link data sets with columns having string data type at first i am not getting the option for creating the link but by drag and drop i created one.
@@TechTalkwithNaresh I have to create Purchase order detail (Master Child Report). There are two types columns - header columns and line columns. Headers column data is showing in report. Line columns data are blank. So is that the issue of sql query or what?
Hi Janhavi If it is showing the header data and you have issue with line data only means your query have some issue. Or that respective PO won't jave lines.
hello Naresh , could you please help me in linking gl_daily_rates,gl_daily_conversion_types,gl_periods if possible. Thanks!
@Sai Try to find the Primary key and join based on that. You can also get help for primary key in Oracle support.
@@TechTalkwithNaresh there is no such direct join primary /foreign from gl daily rates to gl period..so I thought of checking with you
A Hi Naresh,
Thanks for Making Fusion Videos,I learn more by seeing your videos and i have one doubt
i have INVOICE_AMOUNT Column if data is there in column we have to display if data is not present we have to display like "the data is not found"
is there any possible?
Hi Vishnu you can use nvl for such requirement in BIP.
hello sir, can we link data set with columns having string data type, coz for string data type column i am not able see create link option
@Lee I had not tryied it I also ave to try. I will reply u once I had done this.
@@TechTalkwithNareshthanks for quick response!!!
yes we can link data sets with columns having string data type
at first i am not getting the option for creating the link but by drag and drop i created one.
Hi, sir, data is not showing in data model/ report. what I need to do?
@Janhavi This issue is for all user or only your user?
@@TechTalkwithNaresh I have to create Purchase order detail (Master Child Report). There are two types columns - header columns and line columns. Headers column data is showing in report. Line columns data are blank. So is that the issue of sql query or what?
Hi Janhavi If it is showing the header data and you have issue with line data only means your query have some issue. Or that respective PO won't jave lines.