Forum Discussion

sahilp's avatar
sahilp
New Contributor II
3 years ago

Exporting a Cube View with Dynamic UD8 Text

Hi all, I have a cube view that is generated entirely by dynamic UD8 members, some retrieving text fields, returning static text/numerical data, parsing descriptions, etc. I would like to export th...
Cube View
Reports
sahilp's avatar
sahilp
New Contributor II
3 years ago

I'm trying to set up a connector with the ExecuteCubeView FDX, but I'm not sure what filter this is asking for:

I tried inputting my row filter but when I attach the connector rule to a data source, I get the following error:

 

Any thoughts?

 

  • ckattookaran's avatar
    ckattookaran
    VIP
    3 years ago

    I don't think you can use the OS filters there. As far as I know the filters must be like the SQL where clauses. Account IN or Account Like or Account =. What I've done is use the filter function in vb code and then use it in the filter like SQL. So something like below.

    Dim lstOriginBase As List(Of String) = BRApi.Finance.Metadata.GetMembersUsingFilter(si, "Origin", "O#Top.Base", True, Nothing, Nothing).Select(Function(x) x.Member.Name).ToList()
Dim dt As datatable = BRApi.Import.Data.FdxExecuteDataUnit(si, "Sample", "E#Root.Base", "Local", ScenarioTypeId.Plan, "S#Plan", "T#" & strPlanYear & ".Months", "Periodic", True, "Account='Sales' AND Flow='Endbal_Input' AND " & SqlStringHelper.CreateInClause("Origin", lstOriginBase, True, True), 8, False)