Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Code Block
languagexml
title脚本源码
#template
SELECT {[Measures].[店铺数],[Measures].[销售额]} 
ON COLUMNS , 
(
{% if (系列 != null) %}
[汉东商品].[系列].[系列].[{{系列}}]
{% else %}
[汉东商品].[系列].[系列]
{% endif %}
,
[汉东商品].[Order Flag].[Order Flag],
[汉东商品].[年季].[年季]) ON ROWS 
FROM [汉东BI分析]