Project:
| View Revisions: Issue #38609 | [ Back to Issue ] | ||
| Summary | 0038609: Filter is showing different records depending on how the dimension is built | ||
| Revision | 2018-06-01 14:31 by caristu | ||
| 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 |
||
| Revision | 2018-06-01 14:31 by caristu | ||
| 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 | ||
| Revision | 2018-06-01 14:30 by caristu | ||
| 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 available in the System (all clients) are shown select ad_client_id, count(1) from ad_user group by ad_client_id Select 'Sample Purchase/Sales Order Line' cube Add Sales Representative in Filter Check that only the sales representatives assigned to orders are shown select count(distinct salesrep_id) from c_order o, c_orderline ol where ol.c_order_id = o.c_order_id |
||
| Revision | 2018-06-01 14:30 by caristu | ||
| Description | Filter is showing all the records available in the instance instead of only the ones available in the table the cube is based on for dimensions defined by identifier. If a dimension is defined as a property navigation, only the available records are shown | ||
| Copyright © 2000 - 2009 MantisBT Group |
 |