Forum Discussion

MarcR's avatar
MarcR
VIP
7 months ago

Report on Data Cell Detail using UD8 dynamic calc (DataCellDetail)

Hi Guys,  I'm at a project where we use Data Cell Detail, we have created classifications and added 2 lines of test data. I can find the data via a data adapter Method query: ...
Finance
  • FredLucas's avatar
    FredLucas
    7 months ago

    Hi MarcR,

    My guess is that you are missing to define that you want that GetDataCell function to include the cell detail.

    You'd have to use this version of the function instead and use the options parameter to define that you want the cell info to include that type of detail.

    Dim objDataCellInfoUsingMemberScript As DataCellInfoUsingMemberScript = BRApi.Finance.Data.GetDataCellUsingMemberScript(si, wfClusterPk, povDataCellPk, cubeName, memberScript, options)

    However, because you are on a finance rule I'd actually use an api function instead of a Brapi as that's going to be more performant. I've not tested it myself, but feel free to give the sample code a try:

    Dim dcPK As New DataCellPK(api.pov.GetDataCellPk())
dcPK.UD8Id = DimConstants.None
dcPK.ViewId = DimConstants.Forms
Dim dispOptions As New DataCellDisplayOptions(True,True)
Dim objDataCellEx As DataCellEx = api.Data.GetDataCellEx(dcPK, dispOptions)

objDataCellEx.DataCellDetail.HasLineItems

     

FredLucas's avatar
FredLucas
Contributor III

Hi MarcR,

My guess is that you are missing to define that you want that GetDataCell function to include the cell detail.

You'd have to use this version of the function instead and use the options parameter to define that you want the cell info to include that type of detail.

Dim objDataCellInfoUsingMemberScript As DataCellInfoUsingMemberScript = BRApi.Finance.Data.GetDataCellUsingMemberScript(si, wfClusterPk, povDataCellPk, cubeName, memberScript, options)

However, because you are on a finance rule I'd actually use an api function instead of a Brapi as that's going to be more performant. I've not tested it myself, but feel free to give the sample code a try:

Dim dcPK As New DataCellPK(api.pov.GetDataCellPk())
dcPK.UD8Id = DimConstants.None
dcPK.ViewId = DimConstants.Forms
Dim dispOptions As New DataCellDisplayOptions(True,True)
Dim objDataCellEx As DataCellEx = api.Data.GetDataCellEx(dcPK, dispOptions)

objDataCellEx.DataCellDetail.HasLineItems

 

MarcR's avatar
MarcR
VIP
6 months ago

Thanks FredLucas, that was exactly what i needed. I hadn't figured out the DataCellDisplayOptions.

Have a great day!