我目前有一个为UDA工作的CrossJoin。但是,我们希望改为使用"属性值"。不知道如何在Essbase的CrossJoin中正确使用Attribute语法。我评论了UDA的部分,它非常有效。但是,"属性"部分不起作用。感谢您的指导。
CrossJoin(
CrossJoin(
CrossJoin(
CrossJoin(
CrossJoin(
CrossJoin(
CrossJoin(
CrossJoin(
{[AC_910006]},
{[EN_TotBevEMEAElim]}),
/*
{UDA([Customer].CurrentMember,"EUR_Intra")}),
*/
{Filter(Descendants([CU_Intra],Levels([Customer],0)),
[Customer].CurrentMember.[IntraCoCust] = "EUR_Intra")}),
{Descendants([Orig_Entity],Levels([Orig_Entity],0))}),
{Descendants([Total_Sizes],Levels([Size],0))}),
{Descendants([Total_Types],Levels([Type],0))}),
{[FC],[EUR],[USD]}),
{[FY22]}),
{[Jul]:[Dec]})"
如果我读得正确,请尝试
Withattr ( [Customer], "==", "EUR_Intra" )
对于多个属性,可以使用"相交"命令。
Intersect ( Withattr ( [Customer], "==", "EUR_Intra" ), Withattr ( [Customer], "==", "EUR_Extra" ) )
这里有一个有用的链接:https://docs.oracle.com/cd/E57185_01/ESBTR/mdx_withattr.html
Steve