Hello mam u tell me in the given document format then told u make a BIP report then how to find table name by using given columns name and which one is lov in that report
I have created an Analysis report using the Payables subject area. It is always giving as 'No results Found'. Added Accounts Payables Administrator and Specialist role to the user. When a query from the Invoices search screen I can see the data but not sure am I missing something.
Hi - You will have to use "Real Time" Analysis. Besides provisioning roles to the concerned user, you will have to provide data access. Navigation : Setup & Maintenance -> Manage Data Access Set for Users.
Thank Raj. Its worked. I have given business unit access to users by using Manage Ref Data Access... But here I have observed another thing is when clicking on view report option for Payables Aging Report it is not even to see the report. But I can see the report output when I have submitted through Scheduler Job. Any roles required again to run 'Aging Report' from BI Page.
Either of the condition can be used for AND (flex_value IN (:p_val) OR LEAST(:p_val) IS NULL) or, AND (flex_value in (:p_val) OR 'All' in (:p_val||'All'))
Thank you so much. You explained it so smoothly.
This video was very helpful. Thank you!
Nice. I want to add group by & max function in this how I can be achieve?
How do I add more column once report has been created. The column is present in the data model
thank you a lot.
Hello mam u tell me in the given document format then told u make a BIP report then how to find table name by using given columns name and which one is lov in that report
GOOD JOB BRO ETA BOLCHE KE??
I have created an Analysis report using the Payables subject area. It is always giving as 'No results Found'. Added Accounts Payables Administrator and Specialist role to the user. When a query from the Invoices search screen I can see the data but not sure am I missing something.
Hi - You will have to use "Real Time" Analysis. Besides provisioning roles to the concerned user, you will have to provide data access. Navigation : Setup & Maintenance -> Manage Data Access Set for Users.
Thank Raj. Its worked. I have given business unit access to users by using Manage Ref Data Access...
But here I have observed another thing is when clicking on view report option for Payables Aging Report it is not even to see the report. But I can see the report output when I have submitted through Scheduler Job. Any roles required again to run 'Aging Report' from BI Page.
Hi Raju
can you make video otbi analysis using agent ?
How to pass multiple values in the parameter with an option to handle null value ?
Either of the condition can be used for
AND (flex_value IN (:p_val) OR LEAST(:p_val) IS NULL)
or,
AND (flex_value in (:p_val)
OR 'All' in (:p_val||'All'))