Designing a Project for Financial Reporting

Financial reporting and analysis is important to every business. This can include standard reporting such as profit and loss reporting that provides analysis of a company's profits compared to its losses. An example profit and loss report is shown below:

While financial reporting is an important aspect of any company, it can be difficult to support and achieve through a standard relational database. This is partly due to the additional context and hierarchical structure that is required for the data.

In MicroStrategy, data such as Revenue and Gross Revenue is normally mapped to metrics. However, the additional context and organization required for this data is better suited to attributes in a MicroStrategy system. Since MicroStrategy provides the flexibility to integrate data from your relational database as either metrics or attributes, this allows you to support financial reporting and analysis requirements.