Hi Sam,
Thank you for the response. Not sure I follow what you mean though, do you mean that I should change something in the BR or in the CubeView?
This is all the code I have:
Dim cubeViewFilter = args.NameValuePairs.XFGetValue("cubeViewFilter")
Dim timeFilter = args.NameValuePairs.XFGetValue("timeFilter")
Dim entityFilter = args.NameValuePairs.XFGetValue("entityFilter")
Dim accountFilter = args.NameValuePairs.XFGetValue("accountFilter")
Dim viewFilter = args.NameValuePairs.XFGetValue("viewFilter")
Dim ud1Filter = args.NameValuePairs.XFGetValue("ud1Filter")
Dim customParams As New Dictionary(Of String, String)
customParams.Add("Select_Time",timeFilter)
customParams.Add("prm_Entity",entityFilter)
'customParams.Add("",accountFilter)
customParams.Add("prm_View",viewFilter)
customParams.Add("prm_UD1",ud1Filter)
Dim nameValuePairs As New NameValueFormatBuilder(String.Empty,customParams,False)
Dim filter As New System.Text.StringBuilder
Dim parallelQueryCount As Integer = 8
Dim logStatistics As Boolean = False
Dim includeCellTextCols As Boolean = True
Dim useStandarFactTableFields As Boolean = False
Dim dt As New DataTable
dt = BRApi.Import.Data.FdxExecuteCubeView(si, cubeViewFilter, "","","","","", nameValuePairs, includeCellTextCols, useStandarFactTableFields, filter.ToString, parallelQueryCount, logStatistics)
Return dtAnd this how I get me dynamic value with an UD8
Thanks again for the help!
The Include Text column parameter helps you get the cell-level annotation only, which means the Data Attachments that are there for the cell. I haven't seen it retrieve data from V#Annotation. I know this is not what you wanted to hear. However, you can obtain that information by querying the DataAttachment table for AttachmentType 200, which will provide the text. After running the FDX loop through the datarows, filter the earlier datatable to see if it contains a Text value, and then update your specific column with that value. It seems like a bug because it is the same table that's used to get the includeTextColumn option when enabled.
Sadly it seems like the information I want isn't being stored in the DataAttachment table as it's dynamic.
Thanks anyways for the tip, didn't know about the DataAttachment table, could be useful for other stuff
