Monday, March 12, 2012

Error when browsing processed Cube

Hi,

I get an error after making calculation changes to a cube.The AS solution builds and processes fine, but when I browse to the region of the cube where the MDX change has impacted I get the following error: "An Error 0xE0040200 occurred. No Further information was provided." The popup box is titled as: Microsoft Pivottable List. I've got this same error on my PC running the September CTP, and a development server running the RTM.

i.e. if I change the following working piece of MDX in a calc

Aggregate(

{ [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc BSC Time Dim Calculations].DefaultMember } * PeriodsToDate( [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember.Level, [BSC Time Dim].[YearID - HalfYearDesc - QuarterDesc - MonthDesc].CurrentMember )

)


to, for example:

555

I get this error.

Any idea of what this could be?

Thank you.

I also get this error when the browser shows a three level time dimension (Year / Period / Week) on the rows and a Cumulative dimension with three members (Total / YTD / PTD) on the columns. The common denominator with the original error reported is the use of the PeriodsToDate function which is used in the two calculated members YTD and PTD shown below:

CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[YTD]
AS Sum(PeriodstoDate([d Time].[Time].[Year],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[d Special].[Cumulative].[PTD]
AS Sum(PeriodstoDate([d Time].[Time].[Period],[d Time].[Time].CurrentMember)
,[d Special].[Cumulative].&[Total]),
VISIBLE = 1;

The problem goes away when I drag the Year level out of the browser just leaving Period and Week.

There appears to be nothing wrong with the cube since I can view it through Panorama Novaview with no problem. The view that causes the error in the Visual Studio browser can be produced without error.

|||

Hello, I am getting the same error. Did you find the workaround or fix for this.

Thanks.

|||

Hi,

I was also getting this error when using the Visual Studio SQL2005 Ananlysis Service project cube browser. But when I use MDX query in Microsoft SQL Server Management Studio and then browse the given cube and caluclated members and hand write the code in I don't get the error.

I think it may be a bug with the 2005 browse tool and calculated members.

hope this helps

Cheers

Tamzyn

|||I also get this error after installing the SP2 CTP. The error seems to come when using writeback tables and custom rollup formulas.|||

was receiving the same error message. 0xE0040200

was able to resolve the problem so that my calculations would appear.

removed the dimension that contained my named calculates from the cube under cube structure.

readded the dimension but did not select materialize (figured I could do this while in development)

reprocessed the cube.

worked

|||I tried removing the dimension from the cube and then readded it without materialize. Makes no difference at all, I still get the same error.

No comments:

Post a Comment