Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
List Of Values

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
-
Found the problem, I had not declared the parameter in my main data query...
Thank youu
0 -
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.
0