...
To remove a dimension mapping from a Longview dimension to a CXO dimension, run the following query with correct values for LVSourceConfigurationId and CxoDimension (you get these from running QUERY 3).
QUERY 6
| Code Block | ||
|---|---|---|
| ||
declare @lv_source_configuration_id uniqueidentifier = 'LV SOURCE CONFIGURATION ID HERE';
declare @cxo_dimension varchar(50) = 'CXO DIMENSION HERE';
declare @lv_dimension_name varchar(255) = (
select LVDimensionName
from DimensionMapping
where LVSourceConfigurationId = @lv_source_configuration_id
and CxoDimension = @cxo_dimension
);
update DimensionMapping
set LVDimensionName = NULL
where LVSourceConfigurationId = @lv_source_configuration_id
and CxoDimension = @cxo_dimension
delete from LVDimensionsExtractionConfiguration
where LVSourceConfigurationId = @lv_source_configuration_id
and DimensionName = @lv_dimension_name |
Update Symbol Names, Symbol Attributes and Dimension Description
To update symbol names, symbol attributes and dimension description for a LV dimension, run the following query with the correct LVSourceConfigurationId and DimensionName (you get these from running QUERY 4).
QUERY 7
| Code Block |
|---|
update LVDimensionsExtractionConfiguration
set SymbolNames = '...',
SymbolAttributes = '...',
DimensionDescription = '...'
where LVSourceConfigurationId = 'LV SOURCE CONFIGURATION ID HERE'
and DimensionName = 'DIMENSION NAME HERE' |