I hear you, it is stored in a table called DataCellDetail, join those with the member tables and that should give you the intersections. Now the details are stored in XmlData, you'll need an XMLDocument and read the nodes you want.
<LineItemList>
<LastEditedUserName>Admin</LastEditedUserName>
<LastEditedDateTime>2021-11-16T16:55:39.152342Z</LastEditedDateTime>
<LineItems>
<LineItem>
<LineItemType>Default</LineItemType>
<Amount>100</Amount>
<AggregationWeight>1</AggregationWeight>
<Classification />
<Description>test</Description>
</LineItem>
<LineItem>
<LineItemType>Default</LineItemType>
<Amount>20</Amount>
<AggregationWeight>1</AggregationWeight>
<Classification />
<Description />
</LineItem>
</LineItems>
</LineItemList>
There is also a method query to retrieve cell detail. Create a data adapter and you can build your own report using Studio, BI Viewer or a TableView:
Parameters for method type 'DataCellDetail' should include {Cube Name}{Entity Filter}{Scenario Name}{Time filter}{Account Filter}{Flow Filter}{IC Filter}{UD1 Filter}{UD2 Filter}{UD3 Filter}{UD4 Filter}{UD5 Filter}{UD6 Filter}{UD7 Filter}{UD8 Filter}{Filter}, each enclosed within curly braces.
Example: {Cube}{E#US.Base}{Scenario}{T#2015M1}{}{}{}{}{}{}{}{}{}{}{}{Empty String or Filter Expression}.
You also can get the line items using a BRAPI function:
Dim objDataCellInfoUsingMemberScript As DataCellInfoUsingMemberScript = BRApi.Finance.Data.GetDataCellUsingMemberScript(si, cubeName, memberScript)
objDataCellInfoUsingMemberScript.DataCellEx.DataCellDetail.LineItems.LineItems
Thanks Keith, You do need to mention at least these members (Cube, Entity, Scenario, and Time) to get it. But yes it does give the line item number and the form total, so yessss that is the one.