2012 年 6月 20 日随笔档案 - chunshen

2012年6月20日

摘要： WITH MEMBER [D_Acct_II].[PID].&[50].[毛利润] AS [D_Acct_II].[PID].&[501]-[D_Acct_II].[PID].&[502]MEMBER [D_Acct_II].[PID].&[50].[净利润] AS [D_Acct_II].[PID].&[501]-[D_Acct_II].[PID].&[502]-[D_Acct_II].[PID].&[503]-[D_Acct_II].[PID].&[504]-[D_Acct_II].[PID].&[511]-[D_Ac 阅读全文

posted @ 2012-06-20 21:54 chunshen 阅读(221) 评论(0) 推荐(0) 编辑

参数_门店

摘要： WITH MEMBER [Measures].[ParameterCaption] AS [D_Store].[门店].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [D_Store].[门店].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [D_Store].[门店].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[P 阅读全文

posted @ 2012-06-20 21:34 chunshen 阅读(151) 评论(0) 推荐(0) 编辑

参数_时间

摘要： WITH MEMBER [Measures].[ParameterCaption] AS [Time].[YM].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Time].[YM].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Time].[YM].CURRENTMEMBER.LEVEL.ORDINAL MEMBER [Measures].[T] AS strtovalue([Time].[YM].CURRENTMEMBER 阅读全文

posted @ 2012-06-20 21:31 chunshen 阅读(146) 评论(0) 推荐(0) 编辑