Dimension Set ID

(0) Share

Report

Posted on by rcboiler

1,246

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?

Categories:

Reports and Business Intelligence

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No