mdx 查百分比时 查询字符串错误

[Reasoncool]

我用ADOMD.NET 开发前台显示 返回cellSet 指向下面语句是 提示：字符串格式不对 以检测到是 “/”和“%” 的问题 但是不知道怎么解决 请帮忙

WITH MEMBER [Measures].[成本/销售额] AS
'[Measures].[LyNoPV]/[Measures].[CubePV]' , FORMAT_STRING = '0.00%'
SELECT NON EMPTY
{[Measures].[CubePV],[Measures].[AdPagePV],[Measures].[LyNoPV],[Measures].[成本/销售额]}ON COLUMNS,
NON EMPTY topCount({([Dim Father Ad].[Ad Name].[Ad Name].ALLMEMBERS )},3000,([Measures].[成本/销售额]))ON ROWS
FROM [AnalyticsDW]

[华芸智森]

成本/销售额
---------------------
把 / 换成全角试试.

[Reasoncool]

不行呀

[Reasoncool]

问题在这里 [Measures].[LyNoPV]/[Measures].[CubePV] 的 /

成本/销售额 改称 www 也不行

WITH MEMBER [Measures].[www] AS
'[Measures].[LyNoPV]／[Measures].[CubePV]' , FORMAT_STRING = '0.00%'
SELECT NON EMPTY
{[Measures].[CubePV],[Measures].[AdPagePV],[Measures].[LyNoPV],[Measures].[www]}ON COLUMNS,
NON EMPTY topCount({([Dim Father Ad].[Ad Name].[Ad Name].ALLMEMBERS )},3000,([Measures].[www]))ON ROWS
FROM [AnalyticsDW]

[华芸智森]

测试了一下.可能通过. AS2000

WITH MEMBER [Measures].[www] AS
'[Measures].[Store Sales]/[Measures].[Store Cost]' , FORMAT_STRING = '0.00%'
SELECT
{ [Measures].[www] }ON COLUMNS,
{ [Product].AllMembers } ON ROWS
FROM [sales]

[Reasoncool]

查询分析器里 这一句 没有问题 前台adomd.net Ｃ＃开发时 作为命令提交 不可以

[华芸智森]

有可能有除零,你试把 [Measures].[CubePV] =0 OR = NULL 的值 Filter .

[Reasoncool]

好了 多谢您