Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 275 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI 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