Thank you, it has been very helpfully, just a question exist a function or sometime close to the NVL function in rtf template, i mean the template put a zeros in the fields of null values (blank fields), thank you
@Icoroz In rtf you can rectrict it using if else condition. Or the other way is use the nvl in data model. Thanks,.......... Subscribe to get latest updates.
Naresh I followed your query and I am getting data in the report. I modified the query for my business requirements, the sample has data, however, when I run the report I do not get any data. Just the blank report.
@Siresh You are able to get data in data model. If yes you have to get in to report. Cross check you had created the report using same data model or not. Also chek the correct template is associated with the report.
Hi Naresh, Thanks for the vidoe. What if we have multiple data sets like (G_1, G_2), what can be the solution. Kindly advise. Thanks and Regards, Partha
Hi Naresh, I have a requirement of a BI report which has a output that gives a separate line with sum of balances for each account number. I'm not sure for an appropriate approach on this. Please assist me on this.
Hii bro Very very useful for your all videos bro I am fresher candidate for this Oracle fusion technical module's So it's really very helpful for ur all videos Can you upload a videos how to get percentage in otbi dashboard Example: While creating dashboard we r using 4 or 5 analysis report right each analysis report I need total head count percentage in dashboard
Thank you . Great content and easy to understand
@Vakeesh Welcome, Subscribe to get latest updates.
Thank you, it has been very helpfully, just a question exist a function or sometime close to the NVL function in rtf template, i mean the template put a zeros in the fields of null values (blank fields), thank you
@Icoroz In rtf you can rectrict it using if else condition. Or the other way is use the nvl in data model. Thanks,.......... Subscribe to get latest updates.
Very Nice Video .Thank you very much for knowledge sharing .
@Bala Thanks for Acknowledgement. Subscribe to get latest updates.
Naresh I followed your query and I am getting data in the report. I modified the query for my business requirements, the sample has data, however, when I run the report I do not get any data. Just the blank report.
@Siresh You are able to get data in data model. If yes you have to get in to report. Cross check you had created the report using same data model or not. Also chek the correct template is associated with the report.
Ive learnt and put this into use, great content. it is appreciated. thank you.
@Lehumo welcome. Subscribe to get latest updates.
Hi Naresh, firstly thank you very much for the great content. what is best way to format the columns for eg: date, number , text etc. thank you
@Vakeesh Welcome. Do you want to know the data type for those columns.
Very nice video, I was looking for this from quite long finally found a good video on this. Thank you very much for sharing this
@Sapna Welcome subscribe to get latest updates
my sick leave balance is >6 then my sick leave payout column is sick leave * 0.25 *sick leave balance is greater thn 6 then highleted in green
@User You can apply based on conditions.
If we need to combine one column in G1 we need to include one column from G2 in same line as in G1 and G2 . So how can we give grouping
@Sairam Please write detail requirement on nareshtech21@gmail.com.
Hi Naresh ,
Is there any workaround if we want to have the column format as number not as text ?
@Subhankar You can define the column with number data type. Or you can convert to number by using to_number function.
Great content. very simple and efficient
@Dasaradhi Thanks for Acknowledgement. Subscribe to get latest updates.
Thanks Naresh for this video. Do you have a query that returns payroll YTD balance? Thank you
@Allison Thanks for acknowledgement. I don't have the ready query for payrolls.
@@TechTalkwithNaresh thank you. If you ever build one, please share it so i can practice 😊
Sure
how to make script for if condition based on specific coloum in XDO_GROUP_?, for example grouping only for coloum source='tax'
@Narasi You can give where condition. Where source='tax'
Hi Naresh,
Thanks for the vidoe.
What if we have multiple data sets like (G_1, G_2), what can be the solution.
Kindly advise.
Thanks and Regards,
Partha
@Parthasarathy You can map the both group by same way.
Hi Naresh, I have a requirement of a BI report which has a output that gives a separate line with sum of balances for each account number.
I'm not sure for an appropriate approach on this. Please assist me on this.
@Pooja can you share a example, or tell more about the requirement.
@@TechTalkwithNaresh I have sent an email with my requirement
@Pooja Ok I will check and revert for same
@@TechTalkwithNaresh waiting for your response.
@Pooja I had replied to your mail, with required details.
how to apply conditional formatting (if and else) on the excel template
@Abhishek I will be quite same as rtf template.
Thank you so much!!!
@User Welcome Subscribe to get latest updates.
why we need excel template when rtf template is there?
@Abhishek It depends on the client requirements. If we have the 30-40 column in rtf so achieving that is bit difficult, so we use excel template.
Explanation very nice ,can you make video multiple sheets in Excel
@Dasari I will try to upload asap
Thanks Naresh!
Welcome !!!!
how to display data that sorted in ascending orders?
@Leung Sort the data in Data Model query and then display.
very detail explanation
@,Pardhu Thanks
how to add if one column is greater than 6 then the result of that higleted colour is green
@User Can you please elaborate more detailed so we can get that
Hi Sir, Can you please explain the conditional formatting in Excel RTF Template?
@Divya I will try to upload the video on same asap.
Nice 👍 Video could you please make videos on ORACLE APPLICATIO N CLOUD ,ORACLE OAF,ORACLE ADF IN HINDI?????
@Muhammad I will try to upload new videos on mentioned topics. Subscribe to get latest updates.
Hii bro
Very very useful for your all videos bro
I am fresher candidate for this Oracle fusion technical module's
So it's really very helpful for ur all videos
Can you upload a videos how to get percentage in otbi dashboard
Example:
While creating dashboard we r using 4 or 5 analysis report right each analysis report I need total head count percentage in dashboard
@Manikandan I will try to upload the video asap. You can acchive this using properties of OTBI, try to explore it.
@@TechTalkwithNaresh where I archive otbi property
@@manikandanm7260 Go through my OTBI videos I had explain properties in OTBI.
@@TechTalkwithNaresh yeah sure bro
In this video metadata sheet where that table come from
@Sriram We have to create the dat in metadata sheet.
It's XDO_METADATA not XDO_MATADATA
@Phoenixrangoli 👍