Oracle Communities

Oracle Analytics and AI

Child Item

Table Suppressing Rows | Excel/PDF Export

Greetings, we’re using Table Visualization with Suppressing Rows to get the required visual:

Now, the problem is with Exporting:
Excel's Suppressing Rows doesn’t stay intact which defeats the purpose.
And, PDF is Not Scrollable.

Also, can somebody attach Documentation for Slack.

Find more posts tagged with

Accepted answers

Ram-Oracle

@Vismay Barot This is faw instance and system settings page is not accessible.This is as per design.please refer below doc id

FAW\|FDIP\|FDI\|NSAW: How To Access OAC System Settings? (Doc ID 2915472.1)

All comments

SteveF-Oracle

Hi Vismay,

I tested with simple test of Customer Segment and Order Id from sample_order_lines.xlsx and the row suppression worked ok, and displayed the same in Excel.

Can you provide more details and screenshots of OAC (I am making an assumption you are using OAC since you did not specify) and Excel output?
Can you test with the sample tutorial ?

https://docs.oracle.com/en/cloud/paas/analytics-cloud/tutorial-export-to-excel/index.html#before_you_begin

Here is the section of the documentation that discusses Slack integration.
Set Up Social Channels For Sharing Visualizations

Other comments, welcomed.

Chere-Oracle

Vismay,

Check the setting, "Repeat Rows on Excel Exports for Tables and Pivots," in the "Other" section of System Settings.

SteveF-Oracle

Excellent point, Cheryl ( @Chere-Oracle )! I completely forgot to check that.

Vismay Barot

I (an Administrator) as well as our Implementation Team aren't able access "System Settings".

How could that be resolved?

Thank You.

Ram-Oracle

@Vismay Barot could you please clarify if you are using faw/fdi instance.From oac dv/ui url of fdi instance ,check for instance name and see if it has oax keyword in it.

Vismay Barot

Greetings @Ram-Oracle , thank you for the prompt response.

This is what I see in URL.

Ram-Oracle

@Vismay Barot This is faw instance and system settings page is not accessible.This is as per design.please refer below doc id

FAW\|FDIP\|FDI\|NSAW: How To Access OAC System Settings? (Doc ID 2915472.1)

Vismay Barot

Greetings, since the Form requires "Support Identifier" which I am unaware of. I'll circle back with Implementation Team.

Thank You ☺