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


01sep10:00 am10:30 amEnsuring Quality and Compliance for Batch Manufacturers in Life Sciences

01sep12:00 pm12:30 pmIs it Worth It to Move to the Cloud? A Look at Considerations for Current Agribusinesses Using Dynamics GP

01sep2:00 pm2:45 pmWhat’s New in Dynamics 365 Finance and Supply Chain

09sep11:00 am12:00 pmConfab Live with Stoneridge – Data Strategy and Reporting – Mining Decision Making Insights

15sep10:00 am11:00 amSolving the Biggest Challenges in Agribusiness Through Innovation and Technology

22sep12:00 am12:30 pmSimplifying Payroll and HR Management with ADP Workforce Now

22sep10:00 am10:30 amStreamlining Batch Manufacturing with Technology

22sep2:00 pm2:30 pmProcess Automation for Microsoft Dynamics D365 for Business Central, Finance and Operations and GP

23sep11:00 am12:00 pmConfab LIVE with Stoneridge - Riding the Wave 2 Release – Key Features Coming to Dynamics 365 this October

27sep(sep 27)9:00 am15oct(oct 15)11:00 amDynamics 365 Finance & Supply Chain Development Training - Online Workshop

29sep10:00 am11:00 amTop Five Reasons Why NOW is the Right Time to Move from Salesforce to Dynamics 365 Customer Engagement

29sep12:00 pm12:45 pmUnderstanding Job Costing and Tax Management in Business Central

29sep2:00 pm3:00 pmDigitalizing Horticulture & Agriculture - How to Sell Plants Online and Simplify Business Management

30sep12:00 pm4:00 pmSecurity and Permissions Training for D365 Business Central or Dynamics NAV


27sep(sep 27)9:00 am15oct(oct 15)11:00 amDynamics 365 Finance & Supply Chain Development Training - Online Workshop

06oct10:00 am10:30 amPreview of D365 Business Central Fall Release Features and Functionality

06oct12:00 pm12:30 pmInsider's Guide to New Features Available in the Fall Release of D365 Finance and Supply Chain

07oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Technical

21oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Functional

26oct(oct 26)9:00 am28(oct 28)5:00 pmStoneridge Connect Leadership and Community Conference

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!