output The filter shows field is not null. Why am I getting a Field NULL as part the EmployeeCount output when using cube? I figured it out. Cube includes subtotal and totals where the column is null Is there an easy way to remove the rollup values in the cube results Answer use group by grouping sets, it allows you
Tag: olap
How does Impala Implements GroupBy Extension(CUBE, ROLLUP and GROUPING SETS) In a distributed way?
I’m Learning how to Implement GroupBy Extension(CUBE, ROLLUP and GROUPING SETS), I’ve watched at FE several times, But I still can’t understand how to use grouping_ids to implement GroupBy Extension throught collaboration with BE in a distributed way.How is it to collaborition with ExchangeNode? Is it collaborition with ExchangeNode? Can someone help me with the maze？ Answer Impala introduced the
Correct way to get data for BIRT reporting
We have a system which contains 4 Hierarchies. 1. Senior Manager 2. Manager 3. Supervisor 4. Employee Data related to all these are stored in different tables with respective details. There is a single address table which contains address of all these hierarchies. Sample Data Set We would be able to do a count on each IDs by City, State
Data model guidance, database choice for aggregations on changing filter criteria
Problem: We are looking for some guidance on what database to use and how to model our data to efficiently query for aggregated statistics as well as statistics related to a specific entity. We have different underlying data but this example should showcase the fundamental problem: Let’s say you have data of Facebook friend requests and interactions over time. You
Accounting Data Warehouse Design Question
The finance module in our ERP has a general ledger and sub-ledgers (accounts receivable, accounts payable etc.). All the sub-ledgers are rolled up into the GL. Standard accounting schema I believe I …