Questions tagged [reporting]
The reporting tag has no summary.
53 questions
0 votes
2 answers
184 views
Is this a bad pattern for reporting/audit?
We have a large code base with lots of workflow data (camunda) that does this: Create a reporting event in the codebase Give it a code + payload Put the item on a message queue Consume queue ...
0 votes
1 answer
145 views
Reuse same code for validation and runtime integrity checks?
Scenario I have a system where a user can upload an Excel file which is validated and then used to provide data for the application. There are two distinct operations I need to handle with this file: ...
1 vote
1 answer
194 views
Guideline choosing between reporting solution or application front-end
I am working in the data department of a middle-sized logistics company who is shifting from an 'old-school' on-premise BI data warehouse to a more 'modern' cloud-based data lake approach. Another ...
0 votes
1 answer
1k views
Software architecture for a dynamic reporting system
I have to create a reporting system based on hundreds of different tables in a database (which means a huge volume) and I'd like to know the best practices and/or your wild ideas about it. Here are ...
0 votes
3 answers
1k views
Need advice on reporting with big amounts of data
I have a monolith application in .net core 3.0 with entity framework core 3.0. using: a table with ~3 million records. Its structure is BusinessUnitId | ProfileId | Amount(it has more fields, but ...
1 vote
0 answers
48 views
How to create and store many statistics in SQL Server for Reporting Purposes
I have a C# Program that creats PowerPoint reports filled with statistics of a chosen (by the project manager who operates with the tool) company (each one has a companyID). The statistics are ...
2 votes
2 answers
168 views
Reporting with cyclic or relationships
I’ve got me a design and implementation problem extracting and formulating the results I need. What I’m trying to do is build some reporting on forecasted stock commitments in an inventory system to ...
0 votes
2 answers
229 views
Should I track my handled exceptions?
Various analytics tools will track the number of handled and unhandled exceptions (crashes) that happen in an app. This obviously helps us find problems we didn't know existed and will fix it. Quite ...
1 vote
0 answers
26 views
Batch Syncing between two system and one system reverted its state to older DB state. Syncing Problem
We have a system which generates db records and a ever increasing id named archive_id ( bigint in postgres). sample table: record_table ------ archive_id bigint,info varchar Another system ...
0 votes
1 answer
122 views
Journal Entries vs Entities - what should be the source of truth?
So, this is going to sound like an accounting question, and on top of that might be a little too opinion or discussion-based for Stack Exchange. But we've been going back and forth on this a little ...
3 votes
2 answers
3k views
CQRS, Event Sourcing and (near) Real Time Reporting
I am working with a small team that is developing a CQRS/ES "semi-microservice architecture. We are pretty far along, but running into some interesting challenges with our projections and further ...
2 votes
2 answers
663 views
how do you automate multiple reports requirements that are complex?
I was tasked to automate reports used by multiple teams. Each team have their own procedure on how to generate the report that they need to deliver. I can automate the reports but it takes so much ...
-3 votes
1 answer
167 views
Dynamic query building for report generation tool : suggestion for better approach
I have a requirement for a reporting tool in which the user will be selecting the "class" that has some associated column and "filter" option in the view. Each class is associated with a list of ...
0 votes
2 answers
226 views
How to resolve tasks completed from the backlog with no work done?
We have a mature product that we reuse for new projects. For one project, some tasks were created for already working features. Those tasks were all assigned 1 SP each. So, just as a sanity check, I ...
3 votes
2 answers
489 views
Working with data and time intervals
I have an application that measures that continuously. (About every second - it depends on the device) For example sake, let's say that data is CPUTemp (as used as an example in an answer to a related ...