topic Data Quality Check between Dimensions (Show me Dimension if you have no entry in..) in App Development

Data Quality Check between Dimensions (Show me Dimension if you have no entry in..)

surtex — Fri, 15 Mar 2024 10:22:54 GMT

Hey Members,

i would like to show in the subtitle of a table, which Cost_Element are not included.

In the data editor i have two tables (mapping with Cost_Element):

1) Fact Table: Cost_Element and other informations

2) Mapping Table: Cost_Element and Kostenart1 and Kostenart2

Now the formula should give me the Cost_Element's which have no data in Kostenart1.

Formula like the following are not working:

If(Count(Distinct Cost_Element) - Count( {<Kostenart1 = {"*"}>}Distinct Cost_Element)>0, Cost_Element)

If(IsNull(Kostenart1),Cost_Element)

....

Can someone help me please?

Thanks and regards

surtex

Re: Data Quality Check between Dimensions (Show me Dimension if you have no entry in..)

Clement15 — Fri, 15 Mar 2024 10:34:18 GMT

Hello, would you like to have a formula that shows you the Cost_Element when Kostenart1 is null? IF this is the case you can use this formula.

if(len(Kostenart1 )<>0,Cost_Element )

Re: Data Quality Check between Dimensions (Show me Dimension if you have no entry in..)

surtex — Fri, 15 Mar 2024 10:47:45 GMT

Yeah i would like to show the Cost_Elements, which have no data in Kostenart1 but your formula doesn't work for me. Additional information: Table 2 (Mapping Table) has 125 Cost Elements which have all data in Kostenart1. Table 1 (Fact Table) has 128 Cost Elements. The tables are mapping about the keyword Cost_Element. So I should have 3 Cost Elements displayed..

Re: Data Quality Check between Dimensions (Show me Dimension if you have no entry in..)

Clement15 — Fri, 15 Mar 2024 10:59:56 GMT

I guess this won't work for you either?

if(len(Kostenart1 )=0,Cost_Element )

Otherwise you can take inspiration from this code to create a Flag allowing you to know if there is a Kostenart1 linked.