Question Re: Prevent empty version columns in table for version‐re... in Technology Q&A

Prevent empty version columns in table for version‐restricted measure

Eliram_Lugassi — Wed, 30 Jul 2025 11:14:45 GMT

I have a story based on an Account-based model that uses multiple versions (A0, A1, A2, B0, B1, C0, D0, E10, E20, E30). In the underlying model, I’ve created calculated measures that are restricted to specific versions—for example, a measure that only applies to version D0.

Problem:
Even though the measure is correctly defined to return values only for version D0, when I add it to a table in my story, SAC still creates separate columns for every version (A0–E30), leaving most columns empty. This results in a large number of unnecessary blank columns.

Question:
Is there a way to prevent SAC from generating empty columns for versions where the restricted measure has no data? In other words, can I force the table to show the measure only under its defined version (D0) and omit all other version columns entirely?

Re: Prevent empty version columns in table for version‐re...

N1kh1l — Wed, 30 Jul 2025 13:00:32 GMT

@Eliram_Lugassi

If you have both the restricted measures and the version in the Table axis, this behavior is as expected. It will create a cartesian combination of both restricted measures with all versions. Ideally if you are restricting the measure with a version , you should not be having version dimension also in the axis. Just enable the constant selection feature in the restricted measure. Once you have the version restricted as constant selection you can get rid of the version dimension. If you need to keep both then you need to do some Advance Filtering.

Nikhil

Re: Prevent empty version columns in table for version‐re...

William_Yu1 — Thu, 31 Jul 2025 04:09:43 GMT

Just remove version from table axis and use measure only.