Another option is to get Fusion Data Intelligence (FDI) which offers support for data augmentation using cpq connector and build visuals in OAC (Which comes with FDI). Check details of setup here: https://www.ateam-oracle.com/post/transforming-oracle-cpq-data-into-insight-with-fdip

Please check https://docs.oracle.com/en/cloud/paas/analytics-cloud/acmdg/work-row-level-security.html

What connection is your dataset based of? Can you share sample output of the dataset you are using to test? Do you have subject areas as well - if yes can you enable indexing for subject area and see if this works?

The right way to test this will be to deploy the rpd and use answers to display this session variable. Does this show error? Attach screenshot of this. View Data in rpd is not the right test. Also there should be connectivity to the database used for populating this variable from the obis server(assuming that this…

You can share a page by setting permissions for user or approle via the access tab, however direct url to access the custom page is not available. Once access is shared by setting permissions, the user should be able to see the page in the page layout window.

For replace datamodel error, please check obis diag log for more details on reason for failure. For dataset, you can check if this KM helps: Dataset Creation Failed With "Create Dataset Failed" Error Message For New User In Oracle Analytics (Doc ID 3045074.1)

Please also check the workbook theme setting where you can set custom colors/fonts for your workbooks:

Not sure what specific documentation you are looking for here is the public doc for OAC Dataflows: You can source from a dataset that is file based and write to a target table which is a oracle db connection. Thanks Gayathri

OAC DV dataset cannot read files from sftp server. You will have to place file in OCI object storage and you can use OCI Resource connector to read from object storage. Thanks Gayathri

I don't think you can get direct reference to the new page via URL. The intended feature is to switch/pick a page using the page tile UI option. Other comments welcome.

Hi Please check this doc link: Since this is a 2 year old thread, if you have any follow-up questions, kindly post your issue/question as a new thread. Thanks Gayathri

You can expose 2 additional columns in the report which are non-editable columns - one will have formula for USER session variable and other for repository variable (which would capture sysdate) and include these column ids or position in the insert template.

As Wayne mentioned , you can recover the content by restoring from a snapshot which was taken previously. Please check "Can Oracle help to restore lost content" in Backup FAQ

You can setup filters at multiple levels - if you only have data filters set at application role level, then yes all data is visible to the user unless there is vpd set at db level. Authors could setup data filters at dataset level or even for individual workbooks. In your case , probably it makes sense to define a new app…

User_H03AE Was it Gianni's suggestion that helped you identify the issue with the excel file? If yes please mark his response as accepted answer so its clear what the issue is for other readers. thanks Gayathri

@User_P0XGZ This is an old post. Please open a new post and provide details of the issue seen. Thanks Gayathri

When you upload the private key file in Upload Center, make sure you choose File Type as 'SSH Private Keys'. Then when you go to setup Object Storage connection, this file will automatically appear in Private Key file dropdown.

Please refer to product documentation and this blog to understand user/role setup in OAC:

In IDCS the general best practice is to assign Groups to Roles (Not assign users to Roles directly). So if the former is the setup you have, then what you need to do is to remove the Group membership from ServiceViewer Role in IDCS. This will in turn remove the BIConsumer App Role membership for the users who belong to…

If your user has BIServiceAdministrator Application Role assigned then none of the data filters will be applied. You need to create a new user in IDCS and assign this user to a non-admin Application Role such as BIConsumer or BIAuthor and then check if the row level security is being assigned. You will have define this row…