Ignore:
Timestamp:
05/04/22 19:36:40 (3 months ago)
Author:
GarthBraithwaite_STG
Message:

db - updated the ds create to key off of SO3 and "Country" and cleaned out dup SO1 and SO3 usage. Added map_name cleanup to set to None vs DEFAULT. Added more select tests. Added test for VALUE_ATTR and null measure value.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/db/src/main/scripts/mysql/migrate/6_data-iv_dimensions.sql

    r25052 r25198  
    163163
    164164
     165/* Clear the DEFAULT map name to none if the view doesn't have a geo dim */
     166update INDICATOR_VIEW set MAP_NAME = 'None'
     167where CATEGORY_DIMENSION_NAME not in (select NAME from DIMENSION where GEOGRAPHY_FLAG='x');
     168
     169
     170
    165171/* spot test */
    166172select * from INDICATOR_VIEW where PERIOD_DIMENSION_NAME = 'YearDefault' order by NAME;
Note: See TracChangeset for help on using the changeset viewer.