You can check this video I created about the tool Cloud Miner: The SQL Developer Equivalent for Oracle ERP / HCM / SCM Cloud th-cam.com/video/7f6gIB3rNCg/w-d-xo.html
Hi Arun, would you know why the BIP report is not capturing all of the data when I added a new parameter, initially I only have the Period and Account parameters which works just fine and get all the transactions based on the parameter but after I've added another parameter which is related to the "Location" the report behaves differently wherein unless you select certain "location" it will not generate all even though "All" has been set as value. Thank you!
Hello, Thank you for the video. Instead of adding the vendor name as a column is there a way to show vendor name (single value) on top of the table in the report output since that value is repeated. In other words, how to display the parameter in the report output without explicitly showing it in a column.
Hi Arun, would you know how to have a date range as parameter in the BIP report like for example I want the invoice creation date for certain number of days instead of using the accounting period since some AP invoices created might not be posted on the same accounting period. Thank you!
Hi Arun, I have 6 parameters out of 6 parameters 3 are mandatory and remaining 3 should fetch all data. Even i tried to select all and multiple select on parameter options. But it is not fetching data. Please upload video for my doubt.
Run the BI report from the Data Model. The way you want it. Check if you are seeing data. If not that means you need to modify the SQL. Let me know what you see
Hello, thanks for the content. How to set REPORTNAME parametric? Like, "FILENAME_$YYYYMMDD" YYYYMMDD represents first day of the current month. Ty in advance.
Excellent presentation. Perfect for what I am trying to accomplish. You have a nice, logical and calm way of preseting the material.
Thank you. Appreciate the feedback.
You're an Underrated Gem 😇
Appreciate the kind words
@@atarunraj Expecting more fusion technical contents in future .... I Hope you will get more attention bro ❤
Let me know if you have suggestions for content. Thanks. It will help if you share the channel and videos with friends, colleagues, etc.
@@atarunraj Sure I will share with my friends
Thank you very Much Arun. Looking forward to the next video for list of values.
Uploaded the example. Hope you like it.
@@atarunraj Thank you Arun. much appreciated
Hi Arun, I appreciate your work and good information. what is the tool that you have been using to query the backend data using SQL?
You can check this video I created about the tool
Cloud Miner: The SQL Developer Equivalent for Oracle ERP / HCM / SCM Cloud
th-cam.com/video/7f6gIB3rNCg/w-d-xo.html
Hi Arun, would you know why the BIP report is not capturing all of the data when I added a new parameter, initially I only have the Period and Account parameters which works just fine and get all the transactions based on the parameter but after I've added another parameter which is related to the "Location" the report behaves differently wherein unless you select certain "location" it will not generate all even though "All" has been set as value. Thank you!
Can you provide a screen shot or the query ? You can connect me on LinkedIn to message me directly
Hello, Thank you for the video. Instead of adding the vendor name as a column is there a way to show vendor name (single value) on top of the table in the report output since that value is repeated. In other words, how to display the parameter in the report output without explicitly showing it in a column.
Yes we can. Let me make a quick video on that next
@@atarunraj Hello: Have you made a video on that. If yes, can you please share because this requirement is in many of our reports.
Hi Arun, would you know how to have a date range as parameter in the BIP report like for example I want the invoice creation date for certain number of days instead of using the accounting period since some AP invoices created might not be posted on the same accounting period. Thank you!
I can definitely create an example and share it on my blog / linkedin.
That’s great, looking forward to seeing it. Thank you!
Hi Arun , do you know where could I find the Requester name and approver name in the Requisition tables. I can see the ID but not the names. thank you
Hey. Which table are you using to get the IDs.
@Arun sorry I didn't explain earlier. POR_REQUISITION_LINES_ALL from Requester_ID. thank you again
Hi Arun, I have 6 parameters out of 6 parameters 3 are mandatory and remaining 3 should fetch all data. Even i tried to select all and multiple select on parameter options. But it is not fetching data. Please upload video for my doubt.
Run the BI report from the Data Model. The way you want it. Check if you are seeing data. If not that means you need to modify the SQL. Let me know what you see
Hello, thanks for the content. How to set REPORTNAME parametric? Like, "FILENAME_$YYYYMMDD" YYYYMMDD represents first day of the current month. Ty in advance.
I am not clear on what your requirement is. Report name cannot be dynamic.
Are you may be looking at generating the report output name dynamically?
@@atarunraj yes, exactly. Can you help me?
hi how can we pass the date parameters
You can setup the parameter type to be of date. I can make a video