SSRS Report VendSpendCategoryInvoice

(0) Share

Report

Posted on by David Vanechaute

In AX2012 R2 there is a SSRS report called "Spend by procurement category and vendor invoice classification", which is found in Procurement and Sourcing> Reports> Statistics> Spend Analysis.

When you run the report there is a drop down called "Procurement Category"

We have no procurement categories setup, but yet this drop down list is showing some. The report uses the datasets ProcurementCategory and VendInvoiceTrans. We have no records in either of these two tables with values for a procurement category.

Might someone be able to tell me exactly where the values that are showing in this drop down list are being populated from?

Thanks

David

All responses (2)

Answers (1)

David Vanechaute 75 on at

Like (0)

Report

RE: SSRS Report VendSpendCategoryInvoice

Thanks so much. :)
Verified answer

zhifeng on at

Like (0)

Report

RE: SSRS Report VendSpendCategoryInvoice

We can see this report's data source is from SSAS cube and procurement category is from parameter field:

And this value is fetched by following command:

WITH

MEMBER [Measures].[ParameterCaption] AS '[Procurement category].[Procurement category name].CURRENTMEMBER.MEMBER_CAPTION'
MEMBER [Measures].[ParameterValue] AS '[Procurement category].[Procurement category name].CURRENTMEMBER.UNIQUENAME'
SELECT
{[Measures].[ParameterCaption], [Measures].[ParameterValue]} ON COLUMNS ,

{Filter([Procurement category].[Procurement category name].MEMBERS
,NOT [Procurement category].[Procurement category name].CurrentMember.IS_DATAMEMBER)
}ON ROWS
FROM [Purchase Cube]

If we open SSAS cube design, we can see Procurement category from below tables: