Hidden calculated members produce wrong results in scope assignments

Welcome, guest Sign in | Your Profile | Help

HOME

YOUR DASHBOARD

CONNECTION DIRECTORY

SQL Server Home Downloads Feedback Surveys

Hidden calculated members produce wrong results in scope assignments by teo

Active

Type:	Bug
ID:	508308
Opened:	11/4/2009 1:36:28 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

Changing a calculated member definition to hidden produces wrong results in subsequent scope assignments. We tested this on SQL Server 2008 CU4

Related reference which reports a similar issue:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=434253&wa=wsignin1.0#details

Details (expand)

English

SQL Server 2008 SP1

Analysis Services

Windows Server 2003 (all x64 editions)

US English

1. Deploy the cube (will be provided on request).
2. Run the following MDX query:
select {[Dataset].[Dataset].[Actual], [Dataset].[Dataset].[Budget], [Dataset].[Dataset].[Actual vs. Budget $ Var.]} on 0,
{[Measures].[Borrowings / Assets]} on 1
from viking
3. Notice that the Actual vs. Budget $ Var. value is 0.410% as it should be.
4. Open the cube script definition and change and hide the Borrowings / Assets calculated member as follows:
CREATE MEMBER CURRENTCUBE.[Borrowings / Assets]
AS
IIF ( ([Financial Report].[Financial Report Hierarchy].&[-1], [Measures].[Period End Balance]) = 0, NULL,
(
([Financial Report].[Financial Report Hierarchy].&[-2], [Financial Report].[Interest Bearing Indicator].&[True], [Measures].[Period End Balance])
-
([Financial Report].[Financial Report Hierarchy].&[-13], [Financial Report].[Interest Bearing Indicator].&[True], [Measures].[Period End Balance])
)
/
([Financial Report].[Financial Report Hierarchy].&[-1], [Measures].[Period End Balance])
)
,
FORMAT_STRING = "#,##0.000%;-#,##0.000%",
VISIBLE = 0 , DISPLAY_FOLDER = 'Balance Sheet Composition', ASSOCIATED_MEASURE_GROUP = 'KPI Measures';
5. Run the query again. The variance result now is 24.979% and this is wrong.

Scope assignment results vary based on the visibility of the affected calculated members.

Constant results.

X64

0 attachments

Posted by Microsoft on 11/6/2009 at 11:16 AM

Thanks, Teo for taking time to log this. We'll take a look and get back to you on our findings.

Sherry Irwin
Analysis Services

Posted by teo on 11/6/2009 at 12:13 PM

Sherry,

We open a support case for this: 109110478247966. Jon Burchel is the escalation engineer.