Hi,
I have 3 cross tables, which show the following information:
APP Monthly Capacity Role:
- Rows: Role
- Columns: Month
- Measures: Available Capacity
APP Monthly Capacity Resource:
- Rows: Role, Name
- Columns: Month
- Measures: Available Capacity
APP Weekly Capacity:
- Rows: Role, Name
- Columns: Month, Week
- Measures: Available Capacity
When selecting a role in the crosstab APP Monthly Capacity Role , a month in APP Monthly Capacity Resource and finally a specific resource in the APP Monthly Capacity Resource cross table, the error "An error occurred while getting associative selections" occurs and in the Knowage.log it shows the error ORA-00920: invalid relational operator.
The datasets are the following:
APP Monthly Capacity Role
APP Monthly Capacity Resource
APP Weekly Capacity
The relationships between these datasets are as follows:
APP Weekly Capacity.MONTH <--> APP Monthly Capacity Resource.MONTH <--> APP Monthly Capacity Role.MONTH
APP Weekly Capacity.NAME <--> APP Monthly Capacity Resource.NAME
APP Weekly Capacity.ROLE <--> APP Monthly Capacity Resource.ROLE <--> APP Monthly Capacity Role.ROLE
Can you help me identify the problem?
Thank you very much.
