-
-
关壮壮 数据达人Lv4
发表于2021-1-11 14:54
悬赏10
已解决
楼主
这个是过滤条件表达式
<=#mkfilter('dim(HKJD_EDW_ROOM_SUM.ROOM_TYPE_CODE) = @room_type_name and dim(HKJD_EDW_ROOM_SUM.BIZ_DATE) = @biz_date and dim(HKJD_EDW_ROOM_SUM.BRAND_CODE) = @brand_code and dim(HKJD_EDW_ROOM_SUM.REGION_CODE) = @region_code and dim(HKJD_EDW_ROOM_SUM.MANAGE_TYPE) = @manage_type and dim(HKJD_EDW_ROOM_SUM.HOTEL_CODE) = @hotel_code')#>
下边是错误信息
过滤条件表达式(<=#mkfilter('dim(HKJD_EDW_ROOM_SUM.ROOM_TYPE_CODE) = @room_type_name and dim(HKJD_EDW_ROOM_SUM.BIZ_DATE) = @biz_date and dim(HKJD_EDW_ROOM_SUM.BRAND_CODE) = @brand_code and dim(HKJD_EDW_ROOM_SUM.REGION_CODE) = @region_code and dim(HKJD_EDW_ROOM_SUM.MANAGE_TYPE) = @manage_type and dim(HKJD_EDW_ROOM_SUM.HOTEL_CODE) = @hotel_code')#>)错误:不合法的日期常量表达式:[mkfilter('dim(HKJD_EDW_ROOM_SUM.ROOM_TYPE_CODE) = @room_type_name and dim(HKJD_EDW_ROOM_SUM.BIZ_DATE) = @biz_date and dim(HKJD_EDW_ROOM_SUM.BRAND_CODE) = @brand_code and dim(HKJD_EDW_ROOM_SUM.REGION_CODE) = @region_code and dim(HKJD_EDW_ROOM_SUM.MANAGE_TYPE) = @manage_type and dim(HKJD_EDW_ROOM_SUM.HOTEL_CODE) = @hotel_code')] ,应如:2001-11-3
这个问题是出在哪了
<=#mkfilter('dim(HKJD_EDW_ROOM_SUM.ROOM_TYPE_CODE) = @room_type_name and dim(HKJD_EDW_ROOM_SUM.BIZ_DATE) = @biz_date and dim(HKJD_EDW_ROOM_SUM.BRAND_CODE) = @brand_code and dim(HKJD_EDW_ROOM_SUM.REGION_CODE) = @region_code and dim(HKJD_EDW_ROOM_SUM.MANAGE_TYPE) = @manage_type and dim(HKJD_EDW_ROOM_SUM.HOTEL_CODE) = @hotel_code')#>
下边是错误信息
过滤条件表达式(<=#mkfilter('dim(HKJD_EDW_ROOM_SUM.ROOM_TYPE_CODE) = @room_type_name and dim(HKJD_EDW_ROOM_SUM.BIZ_DATE) = @biz_date and dim(HKJD_EDW_ROOM_SUM.BRAND_CODE) = @brand_code and dim(HKJD_EDW_ROOM_SUM.REGION_CODE) = @region_code and dim(HKJD_EDW_ROOM_SUM.MANAGE_TYPE) = @manage_type and dim(HKJD_EDW_ROOM_SUM.HOTEL_CODE) = @hotel_code')#>)错误:不合法的日期常量表达式:[mkfilter('dim(HKJD_EDW_ROOM_SUM.ROOM_TYPE_CODE) = @room_type_name and dim(HKJD_EDW_ROOM_SUM.BIZ_DATE) = @biz_date and dim(HKJD_EDW_ROOM_SUM.BRAND_CODE) = @brand_code and dim(HKJD_EDW_ROOM_SUM.REGION_CODE) = @region_code and dim(HKJD_EDW_ROOM_SUM.MANAGE_TYPE) = @manage_type and dim(HKJD_EDW_ROOM_SUM.HOTEL_CODE) = @hotel_code')] ,应如:2001-11-3
这个问题是出在哪了
最近看过此主题的会员
3个回答
起止日期组件参数需要用@参数名_s和@参数名_e来区分开来 ，@参数名_s表示开始时间，@参数名_e表示结束时间
xxxl 发表于 2021-1-11 15:04
起止日期组件参数需要用@参数名_s和@参数名_e来区分开来 ，@参数名_s表示开始时间，@参数名_e表示结束时间 ...
那块有介绍这个么,我看见文档里没有
