Would like to have country-level sales information available in Data Warehouse (stored procedure sppUpdateDW), specifically for further analysis in Dashboards. Currently only the state is stored. Ideally, this update would include the ability to retroactively add country information to data already existing in Data Warehouse.
Data Warehouse setup details: https://support.cavallo.com/kb/articles/sales-analysis-report
Include country information in Data Warehouse stored procedure sppUpdateDW Will Not Implement
Comments (3)
Product Development
Mathias Tabor
A further note: country and state information should be stored for both bill to and ship to addresses.
Product Development
After reviewing this request with our development team, we have determined this isn’t something we’re likely to pursue, as introducing this would also create complications around users having to clear the Data Warehouse.
This can still be accomplished with a custom stored procedure (spcpUpdateDW) if so desired. If you would like help with this, please reach out to our consulting team for further assistance.
Thank you for this idea! I have created an internal case for further review.