Skip to content

Instantly share code, notes, and snippets.

View rpbouman's full-sized avatar

Roland rpbouman

View GitHub Profile
select concat(
'mysqldump'
, ' --user=wcm_dwh'
, ' --password=wcm_dwh'
, ' --no-create-info'
, ' --where="'
, case p2.partition_method
when 'hash' then
concat(
p2.partition_expression, ' % '
<mql>
<domain_type>olap</domain_type>
<domain_id>SteelWheels</domain_id>
<model_id>SteelWheelsSales</model_id>
<selections>
<selection>
<!-- mql view = olap hierarchy -->
<view>product</view>
<!-- mql column = olap level -->
<column>product</column>