Hello,
Thanks for the response, but this isn't quite what I am looking for. I am looking to pull items related to specific journal entries, but only one side of the entry. The values I am looking for are not the only values in the accounts retrieved from my query, which is why I am trying to isolate it through an SQL and paste it somewhere else as a metric for my users to access.
I am sure I am not explaining this well.
Is it possible to use an SQL query within a dimension member formula instead of a api.data.calculate, have a query isolate a value and all the necessary other dimension members and the dimension member formula stores it?
You can do anything you want in a Member Formula, the question is whether you should (for performance reasons). Look in the Business Rules / Data Helpers section of Snippets for ways to perform SQL calls; where you perform those, is up to you.
The second part (actually storing the relevant value in an intersection) is trivial - either use a Calculate call where you pass the value in the string formula, or retrieve the DataBuffer and set the value on DataCells manually in the CellAmount property.
