error 0xE0040200 when browse a cube

I am using AS 2005 + SP2.

I got error 0xE0040200 when browse a cube with a calculation member for a dimension, the calculation is defined like the following.

iif([Time].[Calendar].currentmember.prevmember is null or
([TimeSeries].[Period].&[1], [Time].[Calendar].currentmember.prevmember) = 0, null, ROUND(((([TimeSeries].[Period].&[1],
[Time].[Calendar].currentmember) -
([TimeSeries].[Period].&[1], [Time].[Calendar].currentmember.prevmember))/([TimeSeries].[Period].&[1], [Time].[Calendar].currentmember.prevmember)),4))'

I think the problem is around "([TimeSeries].[Period].&[1], [Time].[Calendar].currentmember.prevmember) = 0", because when I change the "=0" to "is null", the error disappears.

Can anyone know why the "=0" won't work? BTW, the same calculation works well in AS 2000.

Thanks

It seems that it is a bug of cube browser in AS 2005.

When I browse the cube in Excel with AS 9.0 OLE DB provider, everything is fine.

has anyone experienced the same?

Thanks
Michael

error 0xE0040200

Hello,

I′ve got this problem when I′m creating a new cube with the Microsoft Visual Studio 2005 8.0.550727.42 (RTM.050727-4200) and my operative system is Microsoft(R) Windows(R) Server 2003, Standard Edition. It isn′t the first cube I′ve created in this project, but it′s the the first time I get the problem.

Could someone help me?

Can you provide bit more informatio about the problem.

At what point you are getting the error?
Is that at deployment time or you get the error while running Cube Wizard?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||I′m getting the error when I′m browsing the cube using the third level of a hierarchy. It happens whit all the hierarchies of the project so I think It isn′t a problem of the hierarchy.|||

Try installing SP1 of SQL server and see if the same problem happens.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Error (bug?) when hiding subtotals in Report Builder report from AS2005 cube

I consequently get an error

message in Report Builder (version 9.0.2047.0) when I make a report

without subtotals when I have the Key attribute of a dimension in

combination with a measure.

The following Report is OK, but when I unselect Show Subtotals, I get an error message.
Date | Count Result
-
10-10-2003 | 200000
-
Total | 200000

The error message is:
For more information about this error navigate to the report server on the local server machine, or enable remote errors
-
Semantic query execution failed.
-
Query execution failed for data set 'dataSet'.
-
An error has occurred during report processing.

I

have tried experimenting with the GroupingBehaviour on

EncourageGrouping or DiscourageGrouping, but without success. I seem to

be the only one with this problem.

I am using Reporting Services 2005 in combination with Analysis Services 2005 (9.00.2153.00)

Because I don't know if the issue is related to Reporting Services or Analysis Services I posted in both forums.

This is probably Reporting Services problem.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.