stoneridgesoftware: SSAS Reports and the Cubes that Source the Data

[Blog bot]

Источник: https://stoneridgesoftware.com/ssas-...urce-the-data/
==============

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 NameCubeAccountantInvestmentAnalysisGeneral Ledger Cube
Accounts Payable CubeAccountantLongTermSolvencyGeneral Ledger Cube
Accounts Payable CubeAccountantOperationalEfficiencyGeneral Ledger Cube
Accounts Payable CubeAccountantProfitabilityAnalysisGeneral Ledger CubeAccountantShortTermSolvencyGeneral Ledger CubeAccountingManagerInvestmentAnalysisGeneral Ledger CubeAccountingManagerLongTermSolvencyGeneral Ledger CubeAccountingManagerOperationalEfficiencyGeneral Ledger CubeAccountingManagerProfitabilityAnalysisGeneral Ledger CubeAccountingManagerShortTermSolvencyGeneral Ledger CubeCFOInvestmentAnalysisGeneral Ledger CubeCFOLongTermSolvencyGeneral Ledger CubeCFOOperationalEfficiencyGeneral Ledger CubeCFOProfitabilityAnalysisGeneral Ledger CubeCFOShortTermSolvencyGeneral Ledger CubeControllerInvestmentAnalysisGeneral Ledger CubeControllerLongTermSolvencyGeneral Ledger CubeControllerOperationalEfficiencyGeneral Ledger CubeControllerProfitabilityAnalysisGeneral Ledger CubeControllerShortTermSolvencyGeneral Ledger CubeCreditAndCollectionOperationalEfficiencyGeneral Ledger Cube
Accounts Payable CubeCustExpectedCashNextXDaysAccounts Receivable CubeCustReceivablePeriodDetailReportAccounts Receivable Cube
General Ledger CubeCustReceivableClassificationPeriodWebpartAccounts Receivable CubeCustSalesPastPeriodChartGeneral Ledger Cube
Accounts Payable CubeCustTopCustomersbyYTDSalesAccounts Receivable CubeEMSEnergyConsumptionEnvironmental Sustainability CubeEMSEnergyConsumptionDetailEnvironmental Sustainability CubeEMSEnergyCostEnvironmental Sustainability CubeEMSEnergyCostGraphEnvironmental Sustainability CubeEMSGreenhouseGasEmissionsEnvironmental Sustainability CubeEMSGreenhouseGasEmissionsByProcessEnvironmental Sustainability CubeLedgerCashInflowvsCashOutflowGeneral Ledger CubeLedgerControllerActivityAnalysisGeneral Ledger CubeLedgerControllerRatiosGeneral Ledger CubeLedgerGrossProfitinthePastXPeriodsGeneral Ledger CubeLedgerTotalAcctReceivablesPastXPeriodsGeneral Ledger CubeLedgerTotalAcctsPayablePastXPeriodGeneral Ledger CubeLedgerTotalExpensesByPeriodGeneral Ledger CubeOutstandingDebtByPeriodGeneral Ledger CubeProdBusinessOverviewWebpartProduction CubeProdDefectRatioDetailProduction CubeProdDefectRatioWebpartProduction CubeProdEfficiencyDetailProduction CubeProdLeadTimeDetailProduction CubeProdOnTimeProdRateDetailProduction CubeProdPlannedVsActualDetailProduction CubeProdPlannedVsActualWebpartProduction CubeProjKPIProject Accounting CubeProjTotalBudgetCostProject Accounting CubeProjTotalBudgetCostDetailProject Accounting CubeProjTotalBudgetCostProjectProject Accounting CubeProjTotalBudgetCostProjectDetailProject Accounting CubeProjUtilizationEfficiencyProject Accounting CubeProjUtilizationEfficiencyDetailProject Accounting CubeRetailBottom10ProductsRetailCubeRetailGMROIIByCategoryRetailCubeRetailGMROIIByProductsRetailCubeRetailSalesByCategoryByStoreRetailCubeRetailSalesByHourRetailCubeRetailSalesByRetailCategoryRetailCubeRetailSalesByRetailCategoryEPRetailCubeRetailSalesByStaffRetailCubeRetailSalesByStoreRetailCubeRetailSalesByStoreRoleCenterRetailCubeRetailSalesByTerminalRetailCubeRetailSalesPerformanceByProductRetailCubeRetailSalesPerformanceByProductEPRetailCubeRetailSalesRetailCategoryRoleCenterRetailCubeRetailSalesYearOverYearRetailCubeRetailStoreMetricsRetailCubeRetailTop10ProductsRetailCubeRetailTop10StoresRetailCubeRetailTrendByChannelRetailCubeRetailYoYByChannelRetailCubeSalesAnalysisSales and Marketing cubeSalesVsTargetSales and Marketing cubesmmCampaignMonthDetailsSales and Marketing cubesmmLeadsAnalysisSales and Marketing cubesmmNewLeadsTrendSales and Marketing cubesmmPipelineAnalysisSales and Marketing cubesmmPipelineByProcessStageSales and Marketing cubesmmPipelineMonthOverMonthClosingTrendSales and Marketing cubesmmPipelineWinAnalysisSales and Marketing cubesmmSalesDetailsSales and Marketing cubeTreasurerAssetAnalysisGeneral Ledger Cube
Accounts Payable CubeTreasurerLiabilitiesAnalysisGeneral Ledger Cube
Accounts Payable CubeTS_DeliveryPerformanceDetailSalesCubeTS_DeliveryPerformanceWebpartSalesCubeTS_InvoicedPurchaseAmountDetailPurchaseCubeTS_InvoicedPurchaseAmountWebpartPurchaseCubeTS_NetsalesVsCOGSDetailSalesCubeTS_NetsalesVsCOGSWebpartSalesCubeTS_PercentVendorsInvoicedAmountDetailPurchaseCubeTS_PercentVendorsInvoicedAmountWebpartPurchaseCubeTS_PurchaseReturnsDetailPurchaseCubeTS_PurchaseReturnsWebPartPurchaseCubeTS_SIFOTDetailedSalesCubeTS_SIFOTDetailedPerProductSalesCubeTS_TopTenReturnedItemsWebPartPurchaseCubeTS_TopTenVendHighReturnsRateWebpartPurchaseCubeTS_TopTenVendorInvoicedAmountPurchaseCubeTS_VendorPerformanceByProductPurchaseCubeTS_VendorPerformanceDetailPurchaseCubeTS_VendorPerformanceTimeDetailPurchaseCubeTS_VendorPerformanceTimeWebpartPurchaseCubeVendPurchasePastXPeriodsAccounts Payable CubeVendSpendCategoryPurchaseCubeVendSpendCategoryDiversityPurchaseCubeVendSpendCategoryInvoicePurchaseCubeVendSpendCategoryYearsPurchaseCubeVendSpendDiversityPurchaseCubeVendSpendLocationPurchaseCubeVendSpendOptimizationPurchaseCubeVendSpendReviewByCategoryPurchaseCubeVendSpendReviewByCompanyPurchaseCubeVendSpendReviewByInvoiceTypePurchaseCubeVendSpendReviewByTopVendorPurchaseCubeVendSpendReviewByVendorTypePurchaseCubeVendSpendTopInvoicePurchaseCubeVendSpendVendorLEPurchaseCubeVendTopXVendorsByYTDPurchasesAccounts Payable Cube
General Ledger CubeWorkflowAutomationReportWorkflow CubeWorkflowElementsAutomationReportWorkflow CubeWorkflowElementsPerformanceReportWorkflow CubeWorkflowParticipantPerformanceReportWorkflow CubeWorkflowPerformanceReportWorkflow CubeYearToYearExpensesByPeriodGeneral Ledger Cube

Источник: https://stoneridgesoftware.com/ssas-...urce-the-data/