Forum Discussion

MartinBoglione's avatar
MartinBoglione
New Contributor
4 days ago

FdxExecuteCubeView cannot export dynamic calculations in V#Annotation

Hi All,

I'm working with FdxExecuteCubeView and cannot export the dynamic calculations in V#Annotation even though I have includeCellTextCols as True.

The OS documentation also says that it's possible to extract Dynamic Calc results.

In my CubeView I have a dynamic UD8 which returns the value kilogram in this case:

 

 

 

Here's the code I have right now:

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 dt

And the resulting data table shows 0.0 instead of kilogram:

 

 

 

 

 

 

 

 

 

 

Am I missing something here?


Thanks for the help!

 

Cubeview
Extenders

2 Replies

  • sameburn's avatar
    sameburn
    Contributor III
    20 hours ago

    Hi MartinBoglione​ 

    Have you tried overriding any of the data unit dims in your BRApi call e.g. you should not need to set V#Annotation to be able to include Commentary via the includeCellTextCols boolean (this can be set to V#YTD or V#Periodic, for example). 

    Currently you are inheriting everything from your cubeview (so it is difficult to see what is actually going on here / getting passed to the method from your cubeview).

    If you are just starting out, I recommend starting with a simple cubeview and then building up your logic

    Hope this helps

    Sam

    • MartinBoglione's avatar
      MartinBoglione
      New Contributor
      13 hours ago

      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 dt

      And this how I get me dynamic value with an UD8

       

       

       

       

      Thanks again for the help!