SSAS Reports and the Cubes that Source the Data

by | Updated August 15, 2016 | Dynamics AX

I have run into some SSAS reports but I have never been able to find a full list of them anywhere. I thought it would also be nice to know which cubes source data to these reports. I ran into a situation where cube data needed to be reloaded. After reloading the cube, we still weren’t seeing the updated data in the report.  It turned out that the SSAS report had queries that used another cube so that cube also needed to be reloaded with the new data.  Because of this, I thought it would be good to build up a list of the SSAS reports with their cubes.

To find which reports were SSAS I went to the DynamicsAXOLAP datasource (SSRS Reports – Report Datasources) and ran the cross references for it.  You can do this by right-clicking on the object and selecting Add-Ins – Cross References – Used by. The prerequisite is that you need to have updated the cross references. Below is a list of SSAS reports and the cubes that source data for them. I used Microsoft Dynamics AX 2012 R3 CU9 to get this info.


SSRS Report Name Cube
AccountantInvestmentAnalysis General Ledger Cube
Accounts Payable Cube
AccountantLongTermSolvency General Ledger Cube
Accounts Payable Cube
AccountantOperationalEfficiency General Ledger Cube
Accounts Payable Cube
AccountantProfitabilityAnalysis General Ledger Cube
AccountantShortTermSolvency General Ledger Cube
AccountingManagerInvestmentAnalysis General Ledger Cube
AccountingManagerLongTermSolvency General Ledger Cube
AccountingManagerOperationalEfficiency General Ledger Cube
AccountingManagerProfitabilityAnalysis General Ledger Cube
AccountingManagerShortTermSolvency General Ledger Cube
CFOInvestmentAnalysis General Ledger Cube
CFOLongTermSolvency General Ledger Cube
CFOOperationalEfficiency General Ledger Cube
CFOProfitabilityAnalysis General Ledger Cube
CFOShortTermSolvency General Ledger Cube
ControllerInvestmentAnalysis General Ledger Cube
ControllerLongTermSolvency General Ledger Cube
ControllerOperationalEfficiency General Ledger Cube
ControllerProfitabilityAnalysis General Ledger Cube
ControllerShortTermSolvency General Ledger Cube
CreditAndCollectionOperationalEfficiency General Ledger Cube
Accounts Payable Cube
CustExpectedCashNextXDays Accounts Receivable Cube
CustReceivablePeriodDetailReport Accounts Receivable Cube
General Ledger Cube
CustReceivableClassificationPeriodWebpart Accounts Receivable Cube
CustSalesPastPeriodChart General Ledger Cube
Accounts Payable Cube
CustTopCustomersbyYTDSales Accounts Receivable Cube
EMSEnergyConsumption Environmental Sustainability Cube
EMSEnergyConsumptionDetail Environmental Sustainability Cube
EMSEnergyCost Environmental Sustainability Cube
EMSEnergyCostGraph Environmental Sustainability Cube
EMSGreenhouseGasEmissions Environmental Sustainability Cube
EMSGreenhouseGasEmissionsByProcess Environmental Sustainability Cube
LedgerCashInflowvsCashOutflow General Ledger Cube
LedgerControllerActivityAnalysis General Ledger Cube
LedgerControllerRatios General Ledger Cube
LedgerGrossProfitinthePastXPeriods General Ledger Cube
LedgerTotalAcctReceivablesPastXPeriods General Ledger Cube
LedgerTotalAcctsPayablePastXPeriod General Ledger Cube
LedgerTotalExpensesByPeriod General Ledger Cube
OutstandingDebtByPeriod General Ledger Cube
ProdBusinessOverviewWebpart Production Cube
ProdDefectRatioDetail Production Cube
ProdDefectRatioWebpart Production Cube
ProdEfficiencyDetail Production Cube
ProdLeadTimeDetail Production Cube
ProdOnTimeProdRateDetail Production Cube
ProdPlannedVsActualDetail Production Cube
ProdPlannedVsActualWebpart Production Cube
ProjKPI Project Accounting Cube
ProjTotalBudgetCost Project Accounting Cube
ProjTotalBudgetCostDetail Project Accounting Cube
ProjTotalBudgetCostProject Project Accounting Cube
ProjTotalBudgetCostProjectDetail Project Accounting Cube
ProjUtilizationEfficiency Project Accounting Cube
ProjUtilizationEfficiencyDetail Project Accounting Cube
RetailBottom10Products RetailCube
RetailGMROIIByCategory RetailCube
RetailGMROIIByProducts RetailCube
RetailSalesByCategoryByStore RetailCube
RetailSalesByHour RetailCube
RetailSalesByRetailCategory RetailCube
RetailSalesByRetailCategoryEP RetailCube
RetailSalesByStaff RetailCube
RetailSalesByStore RetailCube
RetailSalesByStoreRoleCenter RetailCube
RetailSalesByTerminal RetailCube
RetailSalesPerformanceByProduct RetailCube
RetailSalesPerformanceByProductEP RetailCube
RetailSalesRetailCategoryRoleCenter RetailCube
RetailSalesYearOverYear RetailCube
RetailStoreMetrics RetailCube
RetailTop10Products RetailCube
RetailTop10Stores RetailCube
RetailTrendByChannel RetailCube
RetailYoYByChannel RetailCube
SalesAnalysis Sales and Marketing cube
SalesVsTarget Sales and Marketing cube
smmCampaignMonthDetails Sales and Marketing cube
smmLeadsAnalysis Sales and Marketing cube
smmNewLeadsTrend Sales and Marketing cube
smmPipelineAnalysis Sales and Marketing cube
smmPipelineByProcessStage Sales and Marketing cube
smmPipelineMonthOverMonthClosingTrend Sales and Marketing cube
smmPipelineWinAnalysis Sales and Marketing cube
smmSalesDetails Sales and Marketing cube
TreasurerAssetAnalysis General Ledger Cube
Accounts Payable Cube
TreasurerLiabilitiesAnalysis General Ledger Cube
Accounts Payable Cube
TS_DeliveryPerformanceDetail SalesCube
TS_DeliveryPerformanceWebpart SalesCube
TS_InvoicedPurchaseAmountDetail PurchaseCube
TS_InvoicedPurchaseAmountWebpart PurchaseCube
TS_NetsalesVsCOGSDetail SalesCube
TS_NetsalesVsCOGSWebpart SalesCube
TS_PercentVendorsInvoicedAmountDetail PurchaseCube
TS_PercentVendorsInvoicedAmountWebpart PurchaseCube
TS_PurchaseReturnsDetail PurchaseCube
TS_PurchaseReturnsWebPart PurchaseCube
TS_SIFOTDetailed SalesCube
TS_SIFOTDetailedPerProduct SalesCube
TS_TopTenReturnedItemsWebPart PurchaseCube
TS_TopTenVendHighReturnsRateWebpart PurchaseCube
TS_TopTenVendorInvoicedAmount PurchaseCube
TS_VendorPerformanceByProduct PurchaseCube
TS_VendorPerformanceDetail PurchaseCube
TS_VendorPerformanceTimeDetail PurchaseCube
TS_VendorPerformanceTimeWebpart PurchaseCube
VendPurchasePastXPeriods Accounts Payable Cube
VendSpendCategory PurchaseCube
VendSpendCategoryDiversity PurchaseCube
VendSpendCategoryInvoice PurchaseCube
VendSpendCategoryYears PurchaseCube
VendSpendDiversity PurchaseCube
VendSpendLocation PurchaseCube
VendSpendOptimization PurchaseCube
VendSpendReviewByCategory PurchaseCube
VendSpendReviewByCompany PurchaseCube
VendSpendReviewByInvoiceType PurchaseCube
VendSpendReviewByTopVendor PurchaseCube
VendSpendReviewByVendorType PurchaseCube
VendSpendTopInvoice PurchaseCube
VendSpendVendorLE PurchaseCube
VendTopXVendorsByYTDPurchases Accounts Payable Cube
General Ledger Cube
WorkflowAutomationReport Workflow Cube
WorkflowElementsAutomationReport Workflow Cube
WorkflowElementsPerformanceReport Workflow Cube
WorkflowParticipantPerformanceReport Workflow Cube
WorkflowPerformanceReport Workflow Cube
YearToYearExpensesByPeriod General Ledger Cube

Related Posts


Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events


02jun2:00 pm2:30 pmBusiness Intelligence for Batch Manufacturers

16jun10:00 am10:30 amHow AP automation can speed up month-end close in D365 Finance

17jun11:00 am12:00 pmConfab Live with Stoneridge – Real Time Marketing Strategies for Success

23jun10:00 am10:30 amThe Modern Manufacturer: Cost Accounting in D365

30jun10:00 am10:30 amAP Automation Checklist for a 2022 Rebound

30jun2:00 pm2:30 pmAchieving Success: How Technology Is Helping Nonprofits Thrive


01jul11:00 am12:00 pmConfab Live with Stoneridge – Dataverse Virtual Entities

14jul12:00 pm12:30 pmBeyond Reporting - What Business Intelligence Can Do For Your Agribusiness

15jul11:00 am12:00 pmConfab Live with Stoneridge – Integration Strategies for End User Success

21jul10:00 am10:30 amThe Modern Manufacturer: Manufacturing Software in the Real World

21jul12:00 pm1:00 pmIs it Worth it to Upgrade to Dynamics 365 Finance and Supply Chain Management? - Everything AX Users Need to Consider

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!