Allo!

I'm new to AS 2005 and am receiving some errors when processing my
cube. I've just used the Migration wizard to copy the cube from '00 to
'05. Can someone please point me in the right direction to find a
solution to this error?

Thanks!

-Joey Pruett



Errors and Warnings from Response
The function expects a member expression for the argument. A tuple
set expression was used.



<Batch ProcessAffectedObjects="true"
xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Object>
<DatabaseID>Bill of Materials</DatabaseID>
<CubeID>Bill of Materials</CubeID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Processing Cube 'Bill of Materials' completed successfully.
Start time: 4/7/2006 3:59:44 PM; End time: 4/7/2006 4:06:45 PM;
Duration: 0:07:01
Processing Measure Group 'Bill of Materials' completed successfully.
Start time: 4/7/2006 3:59:44 PM; End time: 4/7/2006 4:06:45 PM;
Duration: 0:07:01
Processing Partition 'Bill of Materials' completed successfully.
6646577 rows have been read.
Start time: 4/7/2006 3:59:44 PM; End time: 4/7/2006 4:06:45 PM;
Duration: 0:07:01
SQL queries 1
SELECT [dbo_FactLineItem].[FactSurrogateKey] AS
[dbo_FactLineItemFactSurrogateKey0_0],[dbo_FactLineItem].[CollectionDimID]
AS [dbo_FactLineItemCollectionDimID0_1],[dbo_FactLineItem].[TimeDimID]
AS
[dbo_FactLineItemTimeDimID0_2],[dbo_FactLineItem].[ProductConfigDimID]
AS
[dbo_FactLineItemProductConfigDimID0_3],[dbo_FactLineItem].[TypeDimID]
AS [dbo_FactLineItemTypeDimID0_4],[dbo_FactLineItem].[LocCodeDimID] AS
[dbo_FactLineItemLocCodeDimID0_5],[dbo_FactLineItem].[ReleaseDimID] AS
[dbo_FactLineItemReleaseDimID0_6]
FROM [dbo].[FactLineItem] AS [dbo_FactLineItem]
Errors and Warnings from Response
The function expects a member expression for the argument. A tuple
set expression was used.

Sounds like there may be an issue with one of the calculations in your
MDX script (your calculated members from AS 2000).

Try going into the Calculations tab in the cube and doing a syntax check
(click on the little "spell check" icon).

If that does not work you could try opening up the script and commenting
out the all the calculated members and then adding bits back in until
you find the issue.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1144448252.530406.169340 (AT) i39g2000cwa (DOT) googlegroups.com>,
joeypruett (AT) hotmail (DOT) com says...

Thank you Darren. The syntax check passed, but I found the culprit
with your help:

ALTER CUBE [Bill of Materials] UPDATE DIMENSION [Release],
DEFAULT_MEMBER='[Release].[All Release].CHILDREN';

The Release dimension above was the only AS 2000 dim with a
non-default, default member specified. The AS '05 migration wizard
must have added this line into my scripts.

-Joey