Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0038609 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| design defect | [Modules] Analytics | major | always | 2018-05-23 18:48 | 2022-02-01 08:08 | ||||||
| Reporter | ngarcia | View Status | public | ||||||||
| Assigned To | Triage Platform Base | ||||||||||
| Priority | urgent | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Any | Database | Any | Java version | |||||||
| OS Version | Database version | Ant version | |||||||||
| Product Version | SCM revision | ||||||||||
| Regression date | |||||||||||
| Regression introduced by commit | |||||||||||
| Regression level | |||||||||||
| Review Assigned To | |||||||||||
| Regression introduced in release | |||||||||||
| Summary | 0038609: Filter is showing different records depending on how the dimension is built | ||||||||||
| Description | Filter is showing different records depending on how the dimension is built. If a dimension is defined as a property navigation, only the available records are shown | ||||||||||
| Steps To Reproduce | As System Admin role: In Process Request window schedule 'Update Time Dimension Refs + Tree Closure Table' to be run immediately As group admin role: Go to Cube Definition window Add the following dimension to 'Sample Purchase/Sales Order Line Cube': salesOrder.salesRepresentative Create a Sales Order with 'POS Order' document type and today's date Add a sales representative to it Add a product with stock and book it Create a record in Analytics Process Configuration window: Forward Start Date: today In Process Request window schedule 'Clear Analytics Fact Table' to be run immediately In Process Request window schedule 'Forward Update Analytics Fact Tables' to be run immediately Go to Analytics Sales Detail View and check only one record is shown (only one sales rep is in OBANALY_FACT_ORDER table) Go to OB Analytics window and select 'Sales Details Fact Cube' Add Sales Representative in Filter Check all the users of the client are shown Select 'Sample Purchase/Sales Order Line' cube Add Sales Representative in Filter Check that only the sales representatives assigned to orders are shown | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files |  FilterByPath.png [^] (119,923 bytes) 2018-05-23 18:48
FilterByColumn.png [^] (142,394 bytes) 2018-05-23 18:48
| ||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0104880) caristu (manager) 2018-06-01 14:30 |
Moved to design defect. This behavior is happening because of how the cubes are being generated by the Mondrian4SchemaGenerator. For derived properties the dimension is built by joining the properties, causing to show just the records present in the source table. This change implies a refactor in the cube generation that should be handled as a project instead of a regular issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2018-05-23 18:48 | ngarcia | New Issue | |
| 2018-05-23 18:48 | ngarcia | Assigned To | => platform |
| 2018-05-23 18:48 | ngarcia | File Added: FilterByPath.png | |
| 2018-05-23 18:48 | ngarcia | Resolution time | => 1528840800 |
| 2018-05-23 18:48 | ngarcia | File Added: FilterByColumn.png | |
| 2018-05-23 18:49 | ngarcia | Issue Monitored: networkb | |
| 2018-06-01 14:27 | caristu | Issue cloned | 0038688 |
| 2018-06-01 14:27 | caristu | Relationship added | related to 0038688 |
| 2018-06-01 14:27 | caristu | Resolution time | 1528840800 => |
| 2018-06-01 14:27 | caristu | Type | defect => design defect |
| 2018-06-01 14:30 | caristu | Note Added: 0104880 | |
| 2018-06-01 14:30 | caristu | Status | new => acknowledged |
| 2018-06-01 14:31 | caristu | Summary | Filter is showing all the records available in the instance instead of only the ones available in the table the cube is based on => Filter is showing different records depending on how the dimension is built |
| 2018-06-01 14:31 | caristu | Description Updated | View Revisions |
| 2018-06-01 14:31 | caristu | Steps to Reproduce Updated | View Revisions |
| 2022-02-01 08:08 | alostale | Assigned To | platform => Triage Platform Base |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |