Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Table Suppressing Rows | Excel/PDF Export

Accepted answer
94
Views
8
Comments

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

image.png

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.

image.png

Best Answer

Answers

  • SteveF-Oracle
    edited Nov 14, 2024 9:48PM

    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
    Chere-Oracle Rank 5 - Community Champion

    Vismay,

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

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

  • Vismay Barot
    Vismay Barot Rank 4 - Community Specialist

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

    image.png

    How could that be resolved?

    Thank You.

  • Ram-Oracle
    Ram-Oracle Rank 6 - Analytics Lead

    @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
    Vismay Barot Rank 4 - Community Specialist

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

    image.png

    This is what I see in URL.

  • Vismay Barot
    Vismay Barot Rank 4 - Community Specialist

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

    Thank You ☺