0
RSDS_EnterpriseDW_SSAS
None
aff4f71a-780b-44c2-8733-785745c31bba
RSDS_EnterpriseDW_SSAS
=Parameters!PayeeIsMinority.Value
SELECT
NON EMPTY
{
[Measures].[Pay Amount]
,[Measures].[Fact Payable Amounts Count]
} ON COLUMNS
,NON EMPTY
{
[Payee].[Payee Type].[Payee Type].ALLMEMBERS
}
ON ROWS
FROM [PayablesPurchaseOrder]
WHERE
(
STRTOSET(@PayeeIsMinority)
,[Payable].[Payable Status Code].&[PE]
)
MDXQueryPayablesPurchaseOrderSELECT
NON EMPTY
{
[Measures].[Pay Amount]
,[Measures].[Fact Payable Amounts Count]
} ON COLUMNS
,NON EMPTY
{
[Payee].[Payee Type].[Payee Type].ALLMEMBERS
}
ON ROWS
FROM [PayablesPurchaseOrder]
WHERE
(
STRTOSET(@PayeeIsMinority)
,[Payable].[Payable Status Code].&[PE]
)PayeeIsMinority[Payee].[Is Minority].[All]Is Minority[Payee].[Is Minority]WITH MEMBER [Measures].[ParameterCaption] AS [Payee].[Is Minority].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Payee].[Is Minority].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Payee].[Is Minority].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Payee].[Is Minority].ALLMEMBERS ON ROWS FROM [PayablesPurchaseOrder]true
<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payee].[Payee Type].[Payee Type]" />
System.String
<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Pay Amount]" />
System.Int32
<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[Fact Payable Amounts Count]" />
System.Int32
RSDS_EnterpriseDW_SSAS
WITH
MEMBER [Measures].[ParameterCaption] AS
[Payee].[Is Minority].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Payee].[Is Minority].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Payee].[Is Minority].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS
,[Payee].[Is Minority].ALLMEMBERS ON ROWS
FROM [PayablesPurchaseOrder]
MDXQueryPayablesPurchaseOrderWITH
MEMBER [Measures].[ParameterCaption] AS
[Payee].[Is Minority].CurrentMember.Member_Caption
MEMBER [Measures].[ParameterValue] AS
[Payee].[Is Minority].CurrentMember.UniqueName
MEMBER [Measures].[ParameterLevel] AS
[Payee].[Is Minority].CurrentMember.Level.Ordinal
SELECT
{
[Measures].[ParameterCaption]
,[Measures].[ParameterValue]
,[Measures].[ParameterLevel]
} ON COLUMNS
,[Payee].[Is Minority].ALLMEMBERS ON ROWS
FROM [PayablesPurchaseOrder]
true
<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[Payee].[Is Minority].[Is Minority]" />
System.String
<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterCaption]" />
System.Int32
<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterValue]" />
System.Int32
<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />
System.Int32
=Space(3*Fields!ParameterLevel.Value) + Fields!ParameterCaption.Value
System.String
=Fields!Payee_Type.Value
=Fields!Payee_Type.Value
=Sum(Fields!Pay_Amount.Value)
="Total Payables: " & FORMAT(SUM(Fields!Pay_Amount.Value),"C2") & " ,Number of Payables: " & SUM(Fields!Fact_Payable_Amounts_Count.Value)
Output
Payable Amount
Primary
Primary
Black
0pt
False
0.5
NaN
NaN
NaN
Axis Title
False
0.5
NaN
Opposite
NaN
NaN
0.5
NaN
NaN
NaN
Axis Title
0.5
NaN
Opposite
NaN
NaN
Pastel
No Data Available
PendingPayablesByType_Query
2.625in
3.42583in
White
None
2.625in
3.42583in
1in
1in
1in
1in
String
[Payee].[Is Minority].[All]
Is Minority
true
Inch
b3b57bfe-8a34-4154-8c37-7f6f1f870d1f