Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

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
Powered by Mantis Bugtracker