Table Name where Dimension are stored
Whats the Table name where all the Dimensions are stored ? I need to generate/Automate a report which will give me a list of all Dimensions setup in our system.
I can do it using the Extract proces...
There are different tables in the backend which connects Dimensions and members together.
1. Dim Table - This gives you dimension Name and Dim type id.
2. Member Table -
3. Relationship Table -
You can write a sql query using the data adapter to output the records.
Below example to extract unique members.
SELECT Member.MemberId, Member.Name, FROM Relationship RIGHT OUTER JOIN Member ON Relationship.DimTypeId = Member.DimTypeId AND Relationship.ParentId = Member.MemberId WHERE (Member.DimTypeId = 0) AND (Relationship.ParentId IS NULL) ORDER BY Member.NameIf the answer helped you , Please give kudos and mark the solution as accepted answer 😊
Why are you not just using the BrApi member functions?
Like this one: objList = BRApi.Finance.Members.GetAllMembers(si, dimPk, includeInheritedDims)
You need to loop all dimensions, join the lists together and clean up the duplicates, but with Linq, it shouldn't be too hard to do.
Cheers
