Getting rid of loop

[#1]

Hi,

I have the following attached tables in my data model. How can I avoid creating loop?

Thanks,

[eduardo_sommer · Accepted solution]

Hi,

One possible solution is to rename the Company Region in the Tax Rates table to Tax Region AND bringing the Company Region from the COMPANY table to the FACT table (via a join or applymap) giving it also the name Tax Region. This will produce a synthetic key between The Tax Rates and the FACT Table, which can be resolved using a concatenated or autonumber field for the Year and Tax Region fields, maintaining both fields in the more granular side.

Something like:

COMPANY:

Load [Company Name],

        [Company Region],

        [Region Group],

        [Company Division],

        [Company Location]

From ...;

MapCompanyRegion:

Mapping

Load [Company Name],

        [Company Region]

Resident COMPANY;

FACT:

Load Year & '|' [Company Region] as YearRegion,

        [Company Name],

       KEY,

       [Reporting Currency],

       Month,

       Amount;

Load Year,

        [Company Name],

        ApplyMap('MapCompanyRegion', [Comapny Name]) as [Company Region],

        KEY,

        [Reporting Currency],

        Month,

        Amount

From ...;

TaxRates:

Load Year& '|' & [Company Region]  as YearRegion,

        Year,

        [Company Region] as [Tax Region],

        [Tax Rate]

From ...;

I hope this will help you

Regards

Eduardo

[Siva_Sankar]

Sheetal,

There are many ways to avoid. Circular References

I have attached the example based on your attached image.

Regards,

siva sankar