Oracle Analytics Cloud and Server

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

List Of Values

Received Response
12
Views
2
Comments

Summary

List Of Values

Content

Hello everyone,

I am new to BIPublisher. I have made a DataModel - Report from a Table with Employees.
Each Employee has all sort of information, such as Employee Name, Employee Type, Employee Hiring Date etc.

I want to use a List Of Values for Employee Type in order for the user to choose which types of Employees are displayed in the report,

and also I want to user a List Of Values of Employee Hiring Date.

Both columns are Text Columns.

My problem is that when combining two list of values the following happens:

For example,

I select Employee Type All and Date 4-12-2017 and the report translates it to Employee Type All OR Date 4-12-2017, displayed an undesirable result of all employee types and dates.

I want to display all employee types of this particular date, and not all employee types of all dates.

Can anyone help?

Thanks,

Ioanna

Answers

  • Ioanna Kat-Oracle
    Ioanna Kat-Oracle Rank 4 - Community Specialist

    Found the problem, I had not declared the parameter in my main data query...

    Thank youu

  • Ioanna Kat-Oracle
    Ioanna Kat-Oracle Rank 4 - Community Specialist

    For example:

    I put Employee Type: Type 1 and Date 04-12-2017 -> All Employees from Type 1 (all dates ) and all 04-12-2017 records appear

    I only want Employee Type 1 from this date to appear

    I put Employee Type:All and Date 04-12-2017 -> All Employees (all dates ) and all 04-12-2017 records appear

    I only want All Employee Types from this date to appear. Not All Employee Types in general.