You’re offline. This is a read only version of the page.
1,214
Various ledger entry tables have the dimension set ID record to link back to the Dimension Set Entries table. However, our Dimension Set Entries table has multiple records with the same Dimension Set ID which causes issues with joins in report tools (such as PowerBI). Am i using this relationship correctly (DimensionSetID (DimensionSetEntries) = DimensionSetID (GeneralLedgerEntries)? Should the DimensionSetEntries table only have unique values for DimensionSetID?
The Dimension Set Entry table's key is Dimension Set ID,Dimension Code so you have the same Dimension Set ID for every rows in the set.
If you filter this table for Dimension Set ID = N, you have all the rows for the Set N.
Share
Report
All responses (
Answers (
