Oracle Analytics Publisher

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

How to get data in repeating groups horizontally in BI Publisher RTF Template ?

Received Response
51
Views
4
Comments
Rank 1 - Community Starter
edited Dec 5, 2024 10:44AM in Oracle Analytics Publisher

For Example :

  • If a person have timecard data for monday, tuesday, wednesday, then the output should be like -

MONDAY

TUESDAY

WEDNESDAY

11.50

16.50

14.5

  • If another person have timecard data for monday, tuesday, wednesday, thursday, friday and saturday, then the output should be like -

MONDAY

TUESDAY

WEDNESDAY

THURSDAY

FRIDAY

SATURDAY

11.50

16.50

14.50

11.50

12.00

10.00

How to acieve this in BI Publisher RTF Template?

Thanks in Advance :)

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 4 - Community Specialist

    Hi @Thiagu V,

    you can use the conditional area: you can create two different tables, in which you set that the first table appears with the first condition and the second with another condition.

    Let me know.

    Regards

  • Rank 1 - Community Starter
    edited Dec 5, 2024 10:05AM

    Hi @_vero_ ,

    Firstly thanks for the reply.

    But here in this case we cannot put conditions manually for each employee.

    We should get output automatically based on the data for each employee.

    Note: Above mentioned tables are just for example.

  • Rank 4 - Community Specialist
    edited Dec 5, 2024 10:12AM

    Hi,

    I don't think it's possible to create an automated thing like this on the publisher. I would make 7 tables in a conditional area, where the condition variable does a count of the days an employee is associated with, and only shows the table that has the number of columns corresponding to the days. I think it's a good workaround, tell me if I explained myself well and if I understood the problem.

    Thank you

    Regards

  • Rank 1 - Community Starter

    sample xml -

    sample output -

Welcome!

It looks like you're new here. Sign in or register to get started.