"???? '<named set="" alias="">' ?? ??? ???? ???? ?? ?? ????????, <named set="" alias="">, ????? ???? ???? ???" ?????? ?? ?? SQL Server 2012 ???????? ?????? ??? ???? MDX ?????? ????????? ????...

???? ?????? ???? ??????
???? ID: 2739928 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?? ?? ???? Multidimensional ????????????? (MDX) ?????? ????? Microsoft SQL Server 2012 ???????? ?????? (SSAS ???) ???? ?? ??? ?????? ????, ???? ????? ?? ???? ?? ?????? ????? ??????? ???? ??:
???? '<named set="" alias=""></named>' ?? ??? ???? ???? ?? ?? ????????, <named set="" alias=""> </named>, ????? ???? ??? ???

?????
  • "????? ??? ??? ????"?? ???????? ???? ?? ??? ?????? ??? ?? ??? ??????????? ???
  • ??? SSAS 2008 R2 MDX ?????? ??????????? ????????? ???? ???

?? ?? SSAS 2012 ??? AdventureWorks SQL ????? 2008 R2 ??????? ?? ??????? ????? ?????? ?? ????????? ???? ??? ?? ?????? ?? ???, ???? ?????? ????? ???????:
WITH 
SET XQE_NS10 AS
Filter
(
[Product].[Product Categories].[Category].MEMBERS
,
Count
(
Filter
(
CrossJoin
(
[Product].[Product Categories].[Category].MEMBERS
,[Product].[Status].[Status].MEMBERS
)
,
(
[Measures].[Reseller Freight Cost]
,[Date].[Fiscal].[XQE_MDF_CM0]
)
> 20000
)
,IncludeEmpty
)
> 0
)


/* The named set [XQE_SA0] is defined in context of the COUNT operation */

MEMBER [Date].[Fiscal].[XQE_MDF_CM0] AS
IIF
(
Count
(
Descendants
(
[Geography].[Geography].CurrentMember
,[Geography].[Geography].[Country]
) AS [XQE_SA0]
,IncludeEmpty
)
> 0
,Aggregate

/* [XQE_SA0] is subsequently used in AGGREGATE */
(
[XQE_SA0]
,[Date].[Fiscal].DefaultMember
)
,NULL
)
SET XQE_NS0 AS
[Geography].[Geography].[Country].&[Canada]
SELECT
{XQE_NS0} ON 0
FROM [AdventureWorks]
WHERE
[Measures].[Reseller Freight Cost];

????

?? ?????? ????? ???? ?? ??????? SSAS 2012 ??? ??????? ?? ???? ?? ???? ??? ?? ???? ??????? ??????? ??? ???????? ???? ???? ?? ???????? ???? ???? ?? ?????

??? ???????????? ????? SSAS 2008 R2 ??? ????? ??? ???????, ??? SSAS 2012 ??? ????? ???

??????

Microsoft ?? ?????? ?? ?? ?? "?? ?? ????" ???? ??? ???????? Microsoft ???????? ??? ?? ?????? ?? ???

????? ?????????

?? ?????? ?? ???????? ?? ?? ???, ????? ??????? ??? ?? ?? ??? ?? MDX ?????? SSAS 2012 ??? ???? ????????? ??????? ?? ???? ?? ?? ????? ?? ???????? ?? ???? ?? ??? ?? ????? ?????

???? 1

???? ???????? ??????? ?? ???? ???? ??? ?? ???????

???? 2

???? ??? ?? ???????????? ???? ?? ??? ????????? MDX ?????? ?? ????? ????? ?????? ?? ???, "?????" ??? ??? ????? ???? ??? ?????? ??? ?????? ?? ????? ??? ???? ?? ???, ?? [XQE_SA0] ???? ??? ????? ?????????? ?? ??? ???????????? ?? ???? ???:
([Geography].[Geography].CurrentMember,[Geography].[Geography].[Country])
???, ????? ??? ??????????? ????? ?????:
WITH 
SET XQE_NS10 AS
Filter
(
[Product].[Product Categories].[Category].MEMBERS
,
Count
(
Filter
(
CrossJoin
(
[Product].[Product Categories].[Category].MEMBERS
,[Product].[Status].[Status].MEMBERS
)
,
(
[Measures].[Reseller Freight Cost]
,[Date].[Fiscal].[XQE_MDF_CM0]
)
> 20000
)
,IncludeEmpty
)
> 0
)
MEMBER [Date].[Fiscal].[XQE_MDF_CM0] AS
IIF
(
Count
(
Descendants
(
[Geography].[Geography].CurrentMember
,[Geography].[Geography].[Country]
) AS [XQE_SA0]
,IncludeEmpty
)
> 0
,Aggregate
(
Descendants
/* instead of referencing [XQE_SA0], substitute the MDX upon which it is based */
(
[Geography].[Geography].CurrentMember
,[Geography].[Geography].[Country]
)
,[Date].[Fiscal].DefaultMember
)
,NULL
)
SET XQE_NS0 AS
[Geography].[Geography].[Country].&[Canada]
SELECT
{XQE_NS0} ON 0
FROM [AdventureWorks]
WHERE
[Measures].[Reseller Freight Cost];

??????

???? ??? ???? ??????? ?? ??? AdventureWorks ??????? SQL Server 2008 R2 ?? ???, ????? Microsoft CodePlex ??? ???? ?? ????:
Microsoft SQL ????? ?????? ?????

???

???? ID: 2739928 - ????? ???????: 25 ??????? 2012 - ??????: 1.0
???? ???? ???? ??:
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Business Intelligence
  • Microsoft SQL Server 2012 Web
??????: 
kbsurveynew kbtshoot kbexpertiseadvanced kbmt KB2739928 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:2739928

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com