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

0 Comments

Submit a Comment

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

Upcoming Events

october

07oct12:00 pm1:00 pmThe Three Paths to Business Central from Dynamics GP

08oct11:00 am12:00 pmConfab with Stoneridge - Livestream - The Vision and Strategy of Microsoft Business Systems

14oct10:00 am10:30 amThe Modern Manufacturer - Managing Complex Cost Modeling

14oct12:00 pm12:30 pmGenerating Custom Inspection or Process Forms

19octAll Day22Stoneridge Connect Fall 2020

22oct11:00 am12:00 pmConfab with Stoneridge - Livestream - Stoneridge Connect Recap

28oct10:00 am10:30 amThe Modern Manufacturer - Engineering Change Management: Introduction of NEW Functionality for Manufacturers Using Dynamics 365

november

18nov10:00 am10:30 amThe Modern Manufacturer - Tears and Trauma of MRP

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!

X