Single record view - possible in answers? — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Single record view - possible in answers?

Received Response
11
Views
3
Comments
Morten_J
Morten_J Rank 3 - Community Apprentice
edited Aug 13, 2024 6:11PM in Oracle Analytics Cloud and Server

Hi, is it possible to create a form-like single record view in answers?

BI Publisher is not an option, using BICS.

What I'm after is something like this:

Name: John Doe         Address: Road 99

Phone: 12334              Email: mmmm@lll.com

Struggling to find the correct view for something like this.

Please advise.

Morten

Answers

  • Chris Arnold
    Chris Arnold Rank 5 - Community Champion

    Yes, I believe you can do this by using a Narrative View.

    For instance, look at your Criteria for your report. Let's say you have your columns in the Criteria tab in this order:

    Name

    Address

    Phone

    Email

    So, in the Narrative section of your Narrative view you could put this in there:

    Name: @1   Address: @2  [br/]

    Phone: @3  Email: @4  [br/][br/][br/]

    Give that a try.

  • Shams Abbasi
    Shams Abbasi Rank 5 - Community Champion

    Yes you can do it,

    as Chris Mentioned using Narrative

    Nar.png

  • Morten_J
    Morten_J Rank 3 - Community Apprentice

    Thanks guys, this works perfectly!

    Thanks,

    Morten