I am very new in pps and we are going to build pps dashboards.
I have a questions what kinds of charts we can build in thye dashboards in PPS.
I have been told that we can only build tabular kinds of charts so my question is
can we build other types of charts in PPS Dashboards.
Also how to decide the granularity level
Also i am working on cube design for the dashboard and i have some doubts and i need suggesations about that
i have three tables green represent dimensions and red are the calculations
COST PAID(
Companycode,companyname , Postingperiod, Fiscalyear, InvoiceProcessing Cost ,CorporateClearance,CorparateClearancePerTRLS,CorparateClearance _forInvoiceProcessing,DispatchInquiry Analyst
LSAnalyst,DirectCost forFreight_Processing, Direct nvoice_ProcessingCost,Total Invoice_Processing Cost)
, EPAID green represent dimensions and red are the calculations
(Companycode ,SCACCode, Deliverytype, Forwagtfreightgrp, Invoicetype, Plant, Materialfreightgrp
F8, Volumeunit, F10
PctPerfect, Number_Invoices, PerfectInvoiceCount, PerfectRail, PerfectTruck, NumberERSLines, NoPOT0, NotEDI, Exception
PaidonTime, Invoiceamountpaid, Grossweight, Quantity, Grossvolume, Volume
time :PostingPeriod, FiscalYear
AND NON-EPay similiar to epay which has most of columns are commons now i want those all to come into single cubes so i want a suggesations what approach i should follow shall i make one measure or different differnt measure group