Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data Model (Sharing (PowerBi (1 gb limit, excel add in - connect to),…
Data Model
Sharing
Sharepoint?
end user connection
CUBE functions
pivot table
local sharedrive?
OneDrive?
PowerBi
1 gb limit
excel add in - connect to
SQL server
PowerBI
excel add in - connect to
Sourcing
Microstrategy
\wedcb449.frmon.danet\prd_dach_DistributionServices
Topline Actuals
A&P + OVH + Operations
Attribute
Cost center
Profit center
Order
Budget Group
Can we connect query directly to server?
STND COGS
directly Torsten file?
FULL COGS
upload from operations?
Hierarchies
SAP
Customers
Products
Microstrategy sourcing
Cluster
aligned with Magnitude?
Local
DataTables
Hierarchies
Customer
Product
Time
Phase
AC
GPS
RF
D-6
Currency
EUR
CHF
Version/Source?
Final Organic
Final reported
Adjustments
Load
Unorganic
Profit Centers
Cost centers
Orders
auto table from Microstrategy
Metrics
in excel model to match data tables
hide data tables
check if it will work for formulas
or data table for each data category?
calculated metrics / not stored
CO
PM
ROS
NS
CAF
Loaded / stored
GS
Sales Discounts
Trade Terms
COGS
A&P
OIE
Data
Topline
Load phase
Microstrategy
even higher granularity if storage/transfer possible
Final phase
Unorganics
Operations
Load phase
Microstrategy
per CC
A&P
Load phase
Microstrategy upload
per order
per profit center
Final phase
input from team - allocated per sku
OVH
OIE
Data load
SAP
Microstrategy
Excel Data Model
OneDrive
Power BI import data model
Excel
Data tables
Some sources from local models
Hierarchies
From local sharedrive
Excel data model directly