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.
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
Very Nice Video .Thank you very much for knowledge sharing .
@Bala Thanks for Acknowledgement. Subscribe to get latest updates.
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
Ive learnt and put this into use, great content. it is appreciated. thank you.
@Lehumo welcome. Subscribe to get latest updates.
Thank you . Great content and easy to understand
@Vakeesh Welcome, Subscribe to get latest updates.
I need a column data to print in number format even after making the cell as number its still not coming in number format any suggestions please.
@User Which Reoprt you are trying? Which format the data having actually? Provid more details so I can check.
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.
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.
Great content. very simple and efficient
@Dasaradhi Thanks for Acknowledgement. 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.
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,
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.
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
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.
how to apply conditional formatting (if and else) on the excel template
@Abhishek I will be quite same as rtf template.
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.
Explanation very nice ,can you make video multiple sheets in Excel
@Dasari I will try to upload asap
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'
Thank you so much!!!
@User Welcome Subscribe to get latest updates.
very detail explanation
@,Pardhu Thanks
how to display data that sorted in ascending orders?
@Leung Sort the data in Data Model query and then display.
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 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.
Thanks Naresh!
Welcome !!!!
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
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.
Hi Sir, Can you please explain the conditional formatting in Excel RTF Template?
@Divya I will try to upload the video on same asap.
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 👍