https://community.oracle.com/products/oracleanalytics/discussion/comment/67101#Comment_67101 I've seen that, but I really don't understand why. I need to be able to associate roles to their inherited roles and this looks like the only table that has that information. I've tried to pull the information from an analysis…

https://community.oracle.com/products/oracleanalytics/discussion/comment/67080#Comment_67080 thank you!

That status has been changed to "needs votes" how do we vote?

https://community.oracle.com/products/oracleanalytics/discussion/comment/66479#Comment_66479 Sure so you will go to you report: Click Edit Report Click Properties Click the Formatting tab Scroll to the HTML Output section The option "View Paginated" set to True When I load the report this way it seem to display the first…

Thanks for the response. I did enable pagination and that allowed it to load better.

I see this one: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acapi/op-20210901-catalog-type-id-actions-getacl-post.html It looks like it would return what I'm looking for. However when I try a basic catalog api I get a 404: /api/20210901/catalog maybe this is not the same type of catalog.

https://community.oracle.com/products/oracleanalytics/discussion/comment/66335#Comment_66335 I am using oracle fusion cloud

I finally got this working by using this : <?If:CERT_NAME_P = ''?>All<?end if?> <?If:CERT_NAME_P != ''?><?CERT_NAME_P?><?end if?>

https://community.oracle.com/products/oracleanalytics/discussion/comment/64037#Comment_64037 So I'm trying to implement this and it's failing when I select two items. It says it's missing a parenthsis. I know your original comment is recommending to set to text field has comma seperated values. I'm wondering if this is…

https://community.oracle.com/products/oracleanalytics/discussion/comment/64058#Comment_64058 Just thinking through usability. If the screen just shows PDF Open, I would prefer it just export instead of opening the new tab with no data.

https://community.oracle.com/products/oracleanalytics/discussion/comment/64058#Comment_64058 I think I now realize I can click export from the gear icon and select pdf and it works as expected. I guess it's just that the preview doesn't show up which I select pdf. It is a few pages, so may be it just doesn't open if its…

https://community.oracle.com/products/oracleanalytics/discussion/comment/64058#Comment_64058 Sorry I wasn't sure you needed that also: Attached the report & data model https://us.v-cdn.net/6037859/uploads/3I93IIS1V5OI/v2-folder.catalog

https://community.oracle.com/products/oracleanalytics/discussion/comment/64056#Comment_64056 Attached is the report catalog. I also observed there isn't an export to CSV option either. I would appreciate help making that an option. I would expect it to export the same as Excel, but for large files, CSV can often be a…

https://community.oracle.com/products/oracleanalytics/discussion/comment/64039#Comment_64039 Thank you!

https://community.oracle.com/products/oracleanalytics/discussion/comment/64037#Comment_64037 How would I add an if statement to my layout?

https://community.oracle.com/products/oracleanalytics/discussion/comment/64033#Comment_64033 Yay this works. I'm hoping you can help me with one question that extends this situation. Since 'All' comes through as null when I put the parameters on my layout it shows up blank, but I get all results. I want my parameter to…

https://community.oracle.com/products/oracleanalytics/discussion/comment/64030#Comment_64030 Thank you for responding. I initially got a missing from error. I moved from to a new line. I then got an ORA-00907: missing right parenthesis error, but the parenthesis look fine. Not sure what needs changing. copilot recommended…