Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
So I've filtered on certain values in my customer dimension table where wildmatch(FieldA, value1, value2, value3) however, I these values still show up as NULLs in my data for my Sales fact table. I can opt to exclude null values in my pivot table but not in my KPI without a set analysis.
Is there a way that I can exclude these values entirely? Not that they appear as null records in my data.
Any info is appreciated! Thanks
Hi Mayil,
Thank you for your assistance. I've managed to figure it out. I loaded my dimension table before my fact table and I used left keep. The field does not appear in the fact table.
[Dimension]:
Load *
FROM dimension
Where FieldA <> Value1;
Fact:
Left Keep (Dimension)
LOAD*
FROM Fact;
Thanks anyway 🙂
Hi
You are filtered in the dimension table only but not in the sales fact table. So either you can try like below to remove the script.
Hope FieldA occurs in both dimension & fact table.
Inner Keep (Dimtablename)
Load * from yoursalesfacttable;
-----------
or,
Load * from yoursalesfacttable where exists(FieldA);
---------
If you want to do in Front end, try like below
=Sum({<FieldA={"*"}>}Urexpression)
Hi Mayil,
Thank you for your assistance. I've managed to figure it out. I loaded my dimension table before my fact table and I used left keep. The field does not appear in the fact table.
[Dimension]:
Load *
FROM dimension
Where FieldA <> Value1;
Fact:
Left Keep (Dimension)
LOAD*
FROM Fact;
Thanks anyway 🙂