"Only Show Nonzero Values" still shows only zero values?
The reason the 0s are still appearing in the Quick Report is because of the Adhoc field. Meaning the sources (Quantities) of the expression are not 0 for the specified range.
Creating a field with an expression [Shipment - Shipment ] which will always be 0. In this case we will still see 0 in some places because there are records that will subtract a number besides 0 (Ex : March 2018 = 400 shipment). We will not see 0 in places where the record for shipment was already 0.
Related Articles
Constellation is not showing in Security?
No constellations are shown in security when perspectives in the system model features an obsolete custom property. Removing the custom property will resolve the issue and show constellations in security.
Why are my overrides changing on their own later?
Data always gets refreshed at aggregated levels. Meaning that these new values may have been added to the quantity coming from the original override. These added combinations from after the date of the override can cause this behavior when overrides ...
"Object reference not set to an instance of an object" error?
This error occurs when the source table does not have CD values for the selected attributes. Column mapping must be done to whichever attributes you want to be able to sort by CD & TX.
I'm not seeing any databases in the Arkieva Server Selection API?
If you're not seeing any databases in the Arkieva Server Selection API, first check if the Database Discovery Is running. If the service is running but you still cannot see the databases, check the zemeter.config file. Inspect the value for the API ...
What to do if overrides are not working?
Delete Null Attribute Isolate a single override that is failing, preferably one at a very low level that affects very few rows in the fact table (a single record would be best), then capture the SQL queries made around processing that override. An ...