Skip to content

Tag: olap

How to remove subtotals from groupby OLAP Cube?

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 all…

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 coun…